Bulk Reverse Geocode GPS Coordinates From an Excel workbook Into Addresses

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 workbook
• 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 Excel workbook. 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 coordinate pair in my Excel sheet columns A and B, reverse geocode using TomTom and write the nearest cross street or intersection into column C

What You Get

• Column C: nearest cross street or intersection for each coordinate pair
• Full formatted addresses, city, and postal code available if you include them in your prompt
• 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)

For each pair of latitude and longitude in columns A and B, check if the coordinates fall within a reasonable geographic range for the UK (lat 49-61, lng -8 to 2). 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

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

You also need the nearest intersection, not just the address

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

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". Count unresolved rows and put the total in cell F1.

One prompt handles the reverse geocoding, the fallback labeling, and the summary count.

Try It

Get the 7-day free trial of SheetXAI and open the Excel workbook with your GPS coordinates, then ask it to reverse geocode every row using TomTom. For the forward direction — converting addresses to coordinates — see the address geocoding spoke.