The Scenario
You're three hours into building a customer delivery report when you realize the dataset your team exported from the fleet tracker is GPS coordinates — 500 pairs of latitude and longitude — not addresses. The report template expects street addresses. The customer-facing version goes to the client at 9 AM tomorrow and it needs to show recognizable locations, not decimal numbers.
The bad version:
- Paste coordinates one at a time into Google Maps or a reverse geocoding website, read the address it returns, and type it into the sheet
- Do that 500 times, which at 30 seconds per row is four hours of work you absolutely do not have before 9 AM
- Miss a row somewhere in the middle and produce a report where one delivery stop shows coordinates instead of an address, which the client will definitely notice
The report is going to someone senior at the client. You can't send coordinates. You also can't spend four hours on data entry tonight.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads the lat/lng columns, calls TomTom reverse geocoding for each pair, and writes the structured address results back — in one operation.
For each pair of latitude and longitude in columns A and B, call TomTom reverse geocode and write the returned formatted address, city, and postal code into columns C, D, and E
What You Get
- Column C: full formatted address string (street number, street name)
- Column D: city name
- Column E: postal code
- Blank cells where TomTom couldn't resolve a coordinate — so you know exactly which rows need manual review
What If the Data Is Not Quite Ready
Some coordinate pairs are clearly wrong (ocean coordinates, null islands)
For each pair of latitude and longitude in columns A and B, check if the coordinates are within the bounding box of the continental US (lat 24–50, lng -125 to -66). For rows outside that range, write "invalid coordinates" in column C. For valid rows, reverse geocode using TomTom and write the formatted address into column C
You also need the nearest intersection, not just the address
For each coordinate pair in columns A and B, reverse geocode using TomTom and write the nearest cross street or intersection into column C and the full formatted address into column D
Coordinates are in a single column formatted as "lat,lng"
Split the coordinate pairs in column A on the comma into separate latitude and longitude values, then reverse geocode each pair using TomTom and write the formatted address, city, and postal code into columns B, C, and D
Cleanup, reverse geocode, and flag unresolvable rows in one pass
For each coordinate pair in columns A and B, reverse geocode using TomTom. Write the formatted address into column C. If TomTom returns no result, write "unresolved" in column C and flag the row in column D with "needs review". Then count how many unresolved rows there are and put that total in cell F1
One prompt handles the reverse geocoding, the fallback labeling, and the summary count together.
Try It
Get the 7-day free trial of SheetXAI and open the Google Sheet with your GPS coordinates, then ask it to reverse geocode every row using TomTom. If you're working with location workflows more broadly, also see the bulk geocoding spoke for converting addresses to coordinates.