The Scenario
You inherited a logistics sheet from a colleague who left last month. Column A has 500 customer delivery addresses. The route optimization tool your team uses needs lat/lng for every row, and the handoff notes say nothing about how the coordinates were generated last time.
The bad version:
- Open Radar's dashboard, paste address one, copy the returned lat/lng, paste into B2 and C2, repeat.
- 500 rows. At 90 seconds per address, that's 12.5 hours of copy-paste work before you can even start route planning.
- Lose track at row 63 because someone sent a Slack message, re-enter three addresses you already did, realize the count is off, start over from the last row you're sure about.
This dataset is supposed to feed a Monday morning planning run. Nobody hired you to sit in a geocoding loop — they hired you to make the logistics operation faster.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads the columns, understands what you're looking at, and talks to Radar's geocoding API so you don't have to. Open the SheetXAI sidebar, describe what you need, and it handles every row.
For each address in column A, call Radar's forward geocode API and write the returned latitude, longitude, and formatted address into columns B, C, and D — flag any rows with no result as Failed in column E
What You Get
- Column B: latitude for each address (decimal degrees)
- Column C: longitude
- Column D: the formatted address Radar matched against — useful for spotting rows where the input was ambiguous
- Column E: "Failed" for any address that returned no result, so you can review those rows specifically before the planning run
What If the Data Is Not Quite Ready
The addresses are inconsistently formatted — some have zip codes, some don't
For each address in column A, call Radar's forward geocode API and write lat, lng, and matched formatted address to columns B, C, and D — if an address returns no result, write Failed in column E and also copy the original address to column F so I can review it
Some rows have the city and street in separate columns (A = street, B = city)
Combine columns A and B into a full address string for each row, geocode via Radar, and write lat, lng, and formatted address to columns C, D, and E
There are duplicate addresses in column A and I only want to geocode each unique address once
Identify unique addresses in column A, geocode each via Radar, and write lat/lng results back to all rows that share each address — flagging any that failed in column E
Clean the address format, geocode, and build a summary of failed rows in one shot
For each address in column A, trim extra whitespace and fix obvious formatting issues like missing commas between city and state, then geocode via Radar — write lat, lng, and formatted address to columns B, C, and D, mark failures in column E, and add a summary at the bottom of column F listing all failed addresses grouped by apparent failure type
One prompt does the data cleanup and the API work at the same time. That's the pattern.
Try It
Get the 7-day free trial of SheetXAI and open any Google Sheet with a column of addresses — ask it to geocode via Radar and write lat/lng coordinates alongside each row. For a related use case, see how to reverse geocode GPS coordinates, or return to the Radar integration overview.