The Scenario
Your fleet management team exported a GPS tracking log from the vehicle monitoring system. 600 rows in Excel — latitude in column A, longitude in column B — covering a month of delivery routes. Finance wants a breakdown of which cities each vehicle visited for the mileage reimbursement report. The tracker gives you coordinates. Finance needs city names.
Your field operations manager handed you the file Thursday at 2 PM. The finance review is Friday morning.
The bad version:
- Look up how to call a reverse geocoding API, write a macro or VBA script that calls it row by row
- Get blocked at the API authentication step because you've never written a macro that calls an external API
- Ask a developer colleague for help, wait until Friday morning, miss the review
This report is not complicated. The data exists. The tool to convert it exists. The gap is that bridging those two things requires skills you don't have and shouldn't need to have for a task like this.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook. Through its built-in Neutrino integration, it reverse-geocodes every coordinate pair in columns A and B and writes the address and city into the columns you specify — no API authentication, no scripting.
For each row in this workbook, 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: formatted street address for every coordinate pair
- Column D: city name — ready to filter and pivot for the finance mileage report
- Any row that cannot be reverse-geocoded surfaces explicitly rather than silently dropping from the output
What If the Data Is Not Quite Ready
Coordinates have low precision (2 decimal places) on some rows
For each row, check whether the latitude in column A and longitude in column B have at least 4 decimal places. Flag any row with fewer than 4 with LOW PRECISION in column E. Then reverse-geocode all rows with Neutrino and write address in column C and city in column D.
You need country, region, and city in separate columns
Reverse-geocode all 600 coordinate pairs in columns A and B with Neutrino and add the country in column C, region (state or province) in column D, and city in column E.
There are duplicate coordinate pairs from the tracker refreshing in place
Before reverse-geocoding, identify duplicate coordinate pairs and flag them with DUPLICATE in column F. Then reverse-geocode all unique coordinates and write address in column C and city in column D.
Full fleet report prep in one shot
Reverse-geocode all coordinate pairs in columns A and B using Neutrino. Write 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 showing the count of rows per city for the finance report.
Try It
Get the 7-day free trial of SheetXAI and open your GPS log workbook, then ask SheetXAI to reverse-geocode columns A and B with Neutrino and write the city and address columns your finance team needs for the mileage report. See also the geocoding spoke if you need to go the other direction on a different workbook.