The Scenario
You inherited the job from someone who left three weeks ago. The handoff note said "addresses are in column A" and not much else. You're staring at 800 rows of service addresses — a mix of free-text entries, some with unit numbers, some without postal codes, some that look like they were typed on a phone — and you need latitude and longitude for every one of them before the GIS team can load the data into their mapping tool. They need it by end of day Thursday.
The bad version:
- Copy 50 rows at a time into a geocoding website, download the result CSV, open it, figure out which column is latitude and which is longitude, paste them back into the right rows in the sheet
- Repeat 16 times, keeping track of which batch you're on and which rows have already been processed
- Discover at row 600 that the geocoding site formatted the confidence score differently for rows with missing postal codes, so now you have to go back and check all of them
Nobody hired you to geocode 800 addresses. The GIS team is waiting, the deadline is Thursday, and you have other things on the list besides this one task.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads the data, calls TomTom's geocoding API for each address, and writes the results into the columns you specify — all in one pass.
For each address in column A, geocode it using TomTom and write the returned latitude, longitude, match confidence score, and formatted address into columns B, C, D, and E
What You Get
- Column B: decimal latitude for each address
- Column C: decimal longitude for each address
- Column D: TomTom match confidence score (0–1) so you can flag low-confidence rows for review
- Column E: TomTom's normalized formatted address, useful for catching entries that resolved to the wrong place
What If the Data Is Not Quite Ready
Some addresses are missing postal codes
For each address in column A, geocode it using TomTom. Where the confidence score returned is below 0.7, flag the row in column F with "low confidence — check address" and still write whatever lat/lng TomTom returned into columns B and C
Address components are split across four columns
For each row, combine the street in column A, city in column B, state in column C, and postal code in column D into a structured TomTom geocoding request. Write the returned latitude into column E and longitude into column F
Addresses from two different worksheets need geocoding
Geocode all addresses in column A of the "Sites" tab and all addresses in column A of the "Prospects" tab using TomTom. Write latitude and longitude back into each tab in columns B and C respectively
Full cleanup and geocode in one shot
For each row in column A, strip any unit or suite numbers from the address, geocode the cleaned version using TomTom, and write the latitude, longitude, confidence score, and cleaned address into columns B, C, D, and E. Flag any row where confidence is below 0.6 in column F
Ask for the cleanup and the geocoding together — you get clean addresses and coordinates in a single operation.
Try It
Get the 7-day free trial of SheetXAI and open the Google Sheet with your address list, then ask it to geocode every row using TomTom. If you're working with coordinate enrichment regularly, also see how to bulk reverse-geocode GPS coordinates.