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 workbook
- 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 Excel workbook. 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 row in my Excel sheet where columns A through D contain street, city, state, and postal code, use TomTom structured geocoding and write the lat/lng into columns E and F
What You Get
- Column E: decimal latitude for each address
- Column F: decimal longitude for each address
- TomTom's match confidence score available if you include it in the prompt
- Any address TomTom couldn't resolve left blank so you know which rows need review
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" and still write whatever lat/lng TomTom returned into columns D and E
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" sheet and all addresses in column A of the "Prospects" sheet using TomTom. Write latitude and longitude back into each sheet 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 Excel workbook with your address list, then ask it to geocode every row using TomTom. For the reverse direction — turning coordinates into readable addresses — see the reverse geocoding spoke.