The Scenario
Your field operations team ran 300 delivery routes last week. The GPS tracking system dumped a spreadsheet of coordinates — one lat/lng pair per delivery completion event. Now the operations director wants a post-route audit report that shows readable street addresses, not decimal pairs that mean nothing to anyone outside the engineering team.
The bad version:
- Copy the first coordinate pair from columns A and B, open a reverse geocoding tool, paste the values, read the address, type it into column C. Repeat 299 more times.
- Realize halfway through that you've been copying the wrong column — lat and lng were swapped in your paste — and you have to go back and redo rows 1 through 140.
- The audit report is due in three hours and you're on row 180.
The report is going to the operations director, who is going to share it in Monday's team review. Submitting a half-filled spreadsheet of coordinates is not an option.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Google Sheet. It reads the coordinate columns, calls Radar's reverse geocoding API for each row, and writes the structured address fields back where you need them. No copying, no pasting, no column mixups.
For each row in this sheet, use the latitude in column A and longitude in column B to reverse geocode via Radar and write the returned street address, city, and country to columns C, D, and E
What You Get
- Column C: full street address for each coordinate pair
- Column D: city
- Column E: country
- Any rows where Radar returned no match get a clear "No result" entry so you can spot them in the audit without hunting through blank cells
What If the Data Is Not Quite Ready
The lat/lng columns are labeled but not always populated — some rows have blanks
For each row in this sheet where both column A (latitude) and column B (longitude) are non-empty, reverse geocode via Radar and write street address, city, and country to columns C, D, and E — skip blank rows and leave them empty
The coordinates have extra precision and some are clearly outside valid ranges
For each row in this sheet, validate that column A is a valid latitude (-90 to 90) and column B is a valid longitude (-180 to 180), then reverse geocode valid rows via Radar and write the address, city, and country to columns C, D, and E — mark invalid rows as Invalid Coordinates in column C
The results need to be organized by region for the report
Reverse geocode all coordinate pairs (lat in A, lng in B) via Radar, write the street address and city to columns C and D, then sort all rows by country in column E and add a count of rows per country at the bottom of the sheet
Validate, reverse geocode, and flag anomalies — all at once
For all 300 rows in this sheet (lat in A, lng in B): check that each coordinate pair falls within plausible delivery geography (continental US), reverse geocode via Radar, write street address and city to columns C and D, and flag any row that falls outside expected bounds as Out of Range in column E
The combination of validation and geocoding in a single prompt catches data quality issues before they land in the report.
Try It
Get the 7-day free trial of SheetXAI and open any Google Sheet with GPS coordinate columns — ask it to reverse geocode every pair via Radar and write the human-readable addresses back into the sheet. For the inverse task, see bulk forward geocoding addresses, or return to the Radar overview.