The Scenario
You are three days into a new logistics role and you have inherited a 500-row Excel workbook of customer delivery addresses from someone who left without documentation. The route optimization software your company uses requires lat/lng for every record. The handoff notes say nothing about how geocoding was handled before.
The bad version:
- Open Radar's dashboard, paste address one, copy lat/lng, type into B2 and C2. Repeat 499 more times.
- Lose your place at row 211 because you switched tabs to check an email, re-enter the last dozen addresses, realize you may have duplicated row 198 twice.
- Spend the rest of the afternoon in a geocoding loop instead of learning the actual job.
There is a planning run scheduled for tomorrow morning. The dataset has to be complete before then, and this is supposed to be your week to get up to speed — not to act as a human geocoder.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads the address column, calls Radar's geocoding API for every row, and writes the coordinates back without requiring you to touch a single API call yourself.
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
- Column C: longitude
- Column D: the formatted address Radar matched — useful for spotting rows where the input was ambiguous
- Column E: "Failed" for any address that returned no result, so you know exactly what needs a manual check before the planning run
What If the Data Is Not Quite Ready
Addresses are split across two columns — street in A, city-state in B
For each row, combine columns A and B into a single address string, geocode via Radar, and write lat, lng, and the matched formatted address to columns C, D, and E
Some rows have trailing whitespace or are entirely blank
For each row in column A that is non-empty: trim whitespace, call Radar's forward geocode API, and write lat, lng, and formatted address to columns B, C, and D — skip blank rows and leave them empty
There are duplicate addresses and you only want to geocode each once
Identify unique addresses in column A, geocode each via Radar, then write the lat/lng results back to every row sharing that address — mark failed geocodes with Failed in column E
Clean addresses, geocode, and flag problem rows for review in one pass
For each address in column A: standardize formatting (trim whitespace, fix obvious state abbreviation errors), call Radar's forward geocode API, write lat and lng to columns B and C and formatted address to column D — mark any that failed to resolve as Failed in column E and append a note in column F with the original raw address for follow-up
One prompt does the cleanup and the API work together.
Try It
Get the 7-day free trial of SheetXAI and open any Excel workbook with a column of delivery addresses — ask it to geocode each one via Radar and write coordinates alongside every row. For the inverse task, see reverse geocoding GPS coordinates, or return to the Radar integration overview.