The Scenario
You are a logistics analyst. Your monitoring system recorded 200 GPS pings from a delivery van — latitude in column A and longitude in column B of an Excel workbook. Your compliance report requires street-level addresses, not coordinates. The ops director needs it by end of day Thursday. It is Wednesday afternoon.
The bad version:
- Paste coordinates into an online reverse geocoder one row at a time, copy the result, switch back to the workbook, paste, move to the next row.
- Reach row 50 and discover three coordinates are over water — GPS drift — with no street address to return.
- Realize you also need city and country in separate columns and the tool you used only returns a combined address string.
The compliance report is not optional. You have 150 rows left and two hours.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads the coordinate data and calls Mapbox reverse geocoding for each row, then writes address, city, and country back into the workbook in one pass.
For each row with latitude in column A and longitude in column B, use Mapbox reverse geocoding to look up the address and write the full address into column C, city into column D, and country into column E. Flag any rows where the coordinates appear to be over water or return no match in column F.
What You Get
- Column C with the full street-level address for each coordinate pair.
- Column D with city name.
- Column E with country.
- Column F flagged with OVER WATER or NO MATCH for coordinates Mapbox cannot resolve to a road-level address.
What If the Data Is Not Quite Ready
Some coordinates are clearly out of range
First, check all values in columns A and B. Flag any latitude outside -90 to 90 or longitude outside -180 to 180 in column F as INVALID COORD. Then reverse-geocode only the unflagged rows using Mapbox and write address, city, and country into columns C, D, and E.
The GPS pings cluster at repeated stops and you want one address per cluster
Group the GPS coordinates in columns A and B by clusters of pings within 50 meters of each other. For each cluster, reverse-geocode the centroid using Mapbox and write the resolved address into column C with the number of original pings in that cluster in column D.
Longitude and latitude are in the wrong columns
Your upstream export swapped them.
The coordinates in this workbook have longitude in column A and latitude in column B. Swap them before reverse geocoding, then call Mapbox reverse geocoding for each row and write the full address into column C and the city into column D.
Full pipeline: validate, deduplicate, reverse-geocode, and flag outliers
Flag any coordinates in columns A and B that fall outside continental US bounds in column F as OUT OF BOUNDS. Then cluster the remaining pings within 100-meter radius groups, take the centroid of each cluster, reverse-geocode it using Mapbox, and write the address to column C and ping count to column D. Mark any clusters of one as SINGLETON in column E.
One pass handles validation, deduplication, and lookup.
Try It
Get the 7-day free trial of SheetXAI and open your next GPS export workbook — ask SheetXAI to reverse-geocode the coordinates through Mapbox. The forward geocoding article covers the address-to-coordinates direction. The Mapbox hub has the full workflow list.