The Scenario
Your fleet management team exported a GPS log from the vehicle tracker. Six hundred coordinate pairs, one per row — latitude in column A, longitude in column B — covering the last month of delivery routes. Finance wants a report showing which cities each vehicle visited and on what dates. The tracker only gives you coordinates. The report needs addresses.
Your field operations manager handed this to you on a Tuesday afternoon. The finance review is Thursday morning.
The bad version:
- Write a script that calls a geocoding API row by row, handle the rate limiting, save the results to a new CSV
- Re-import the CSV, align the columns against the original export, discover that the script's output file has 597 rows and the original has 600 and you don't know which three failed
- Manually scan the results file to find the gaps, re-run those rows, re-import
You don't write scripts regularly. This one took two hours to get working. It's now 6 PM on Tuesday.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. Through its built-in Neutrino integration, it reverse-geocodes every coordinate pair in columns A and B and writes the results — formatted address, city, country — into the columns you specify. Results land inline, same row, no re-importing.
For each row in this sheet, reverse-geocode the latitude in column A and longitude in column B using Neutrino and write the formatted address into column C and the city into column D.
What You Get
- Column C: the formatted street address for each coordinate pair
- Column D: the city name — ready to pivot or filter for the finance report
- Any row that could not be reverse-geocoded surfaces explicitly rather than silently disappearing from the output
What If the Data Is Not Quite Ready
Coordinates have too many decimal places and some rows have them truncated
For each row, check whether the latitude in column A and longitude in column B have at least 4 decimal places of precision. Flag any row with fewer than 4 decimals with LOW PRECISION in column E, then reverse-geocode all rows using Neutrino and write the address to column C and city to column D.
You need country, region, and city in separate columns for the finance breakdown
Reverse-geocode all 600 coordinate pairs in columns A and B with Neutrino and add the country in column C, the region (state or province) in column D, and the city in column E.
Some rows are duplicate coordinates from the tracker refreshing in place
Before reverse-geocoding, identify duplicate coordinate pairs (same lat/lng) and flag them with DUPLICATE in column F. Then reverse-geocode all unique coordinates with Neutrino and write the address to column C and city to column D.
Full fleet report prep in one shot
Reverse-geocode all coordinate pairs in columns A and B using Neutrino. Write the country in column C, region in column D, city in column E, and formatted address in column F. Flag duplicate coordinate pairs with DUPLICATE in column G. Then produce a pivot summary below the data showing the count of rows per city.
Try It
Get the 7-day free trial of SheetXAI and open your GPS export workbook, then ask SheetXAI to reverse-geocode columns A and B with Neutrino and write the city and address into the columns your finance team is waiting for. See also the geocoding spoke if you need to go the other direction — addresses to coordinates.