The Scenario
Your field operations team logged 300 GPS coordinates from driver check-ins across last week's delivery runs. The coordinates came in as a raw Excel dump — one lat/lng pair per row, nothing else. The regional manager needs a readable audit trail with street-level addresses before the end-of-week operations review. She will not be reading decimal pairs.
The bad version:
- Copy the first lat/lng pair, open a reverse geocoding website, paste the values, read the address, type it into column C. Repeat 299 more times.
- Midway through realize you have been pasting lng, lat instead of lat, lng because the column headers were ambiguous. Every address up to row 140 is wrong.
- Redo rows 1 through 140. The review is in 90 minutes.
You were supposed to have this ready an hour ago. The issue is not the volume — 300 rows is manageable. The issue is that no part of this work requires a human decision, yet it's taking all of yours.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook. It reads the lat and lng columns, calls Radar's reverse geocoding API for each row, and writes the structured address fields back — columns in the right order, no manual copy-paste.
Reverse geocode all 300 coordinate pairs in this Excel workbook (lat in A, lng in B) using Radar and write the full formatted address, city, and state to columns C, D, and E
What You Get
- Column C: full formatted street address for each GPS coordinate
- Column D: city
- Column E: state or region
- Any rows where Radar returned no match get "No result" in column C, making them easy to spot in the audit
What If the Data Is Not Quite Ready
Some rows have null coordinates or values of 0,0
For each row in this workbook where column A and column B are both non-zero and non-empty: reverse geocode via Radar and write street address, city, and state to columns C, D, and E — mark invalid or empty rows as Invalid Coordinates in column C
You need ISO country codes in addition to city and state
Reverse geocode all coordinate pairs (lat A, lng B) via Radar and write full address to column C, city to column D, state to column E, and ISO country code to column F
The results need to be filtered to only rows where the city matches an expected coverage list
Reverse geocode all coordinate pairs (lat A, lng B) via Radar and write address, city, and state to columns C, D, and E — then add a flag in column F: "In Coverage" if the city in column D appears in the coverage list in Sheet2, column A, or "Out of Coverage" otherwise
Validate, reverse geocode, and flag coordinates that fall outside expected delivery regions in one pass
For each of the 300 rows (lat in A, lng in B): check that coordinates are within continental US bounds, reverse geocode via Radar, write street address and city to columns C and D — flag any coordinate outside the expected region as Out of Region in column E
The flag column tells the regional manager immediately which check-ins need follow-up.
Try It
Get the 7-day free trial of SheetXAI and open any Excel workbook with GPS coordinate columns — ask it to reverse geocode every pair via Radar and write human-readable addresses into the sheet. For forward geocoding a list of addresses, see bulk forward geocoding, or return to the Radar integration overview.