The Scenario
You manage a team of twelve field technicians. Every afternoon they submit GPS check-ins through a mobile app, and every afternoon those coordinates land in a Google Sheet — 150 rows, columns A and B, latitude and longitude. Column C is supposed to say what address they were at. It's blank.
Your compliance lead just sent you a message: the auditors need formatted street addresses for every check-in from the last three months. Not coordinates. Addresses. And the audit starts Tuesday.
The bad version:
- Copy coordinates in pairs, paste them into a reverse geocoding tool one at a time, copy the address back, paste it into column C.
- Get through about 30 rows before realizing the address format coming back is inconsistent — sometimes "123 Main St, Springfield, IL 62701," sometimes "123 Main Street," sometimes just a neighborhood name with no street number.
- Decide to normalize the format manually, which adds another step to each of the 150 rows.
Three months of check-ins is over 3,000 rows. Doing this by hand is not a plan. It's a punishment.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads the tab, understands the coordinate columns, and through its built-in Geokeo integration it can reverse geocode all 150 rows and write the addresses back without you touching a single row manually.
Paste this into the SheetXAI sidebar:
For each lat/lon pair in columns A and B of the "Field Check-ins" tab, use Geokeo reverse geocoding to find the corresponding street address and write the formatted address into column C. Use the format: street number, street name, city, state, ZIP. If a coordinate pair returns no result, leave column C blank and add a note in column D.
What You Get
- Column C filled with formatted street addresses for every row that returned a result.
- A consistent address format — street number, street name, city, state, ZIP — rather than whatever Geokeo happens to return by default.
- Column D flagging any coordinate pair that came back empty so your compliance review has a clear list of gaps.
- Columns A and B untouched.
What If the Data Is Not Quite Ready
The coordinates came from different devices and some are stored as a single "lat,lon" string in one column instead of two separate columns
In the "Field Check-ins" tab, column A contains GPS strings in the format "lat,lon". Split each string into its latitude and longitude components and reverse geocode them using Geokeo. Write the street address into column B. Format the output as: street number, street name, city, state, ZIP.
Some coordinate pairs are clearly out of range — negative latitudes that should be positive, or values that don't resolve to any address
Reverse geocode the lat/lon pairs in columns A and B of the "Field Check-ins" tab using Geokeo. Before geocoding, flag any row where the latitude is outside the range -90 to 90 or the longitude is outside -180 to 180 in column D as "invalid coordinate." For valid pairs, write the address to column C.
The compliance log needs the city and state in separate columns from the street address
For each lat/lon pair in columns A and B of the "Field Check-ins" tab, use Geokeo reverse geocoding. Write the street address (number + street name) to column C, the city to column D, and the state to column E. If Geokeo returns a result without a street number, write just what it returns and add "no street number" to column F.
The data spans three months of tabs and needs to be consolidated, cleaned, and geocoded in one pass before the audit Tuesday morning
Combine the check-in data from the "Jan Check-ins," "Feb Check-ins," and "Mar Check-ins" tabs into a single output. For each row, reverse geocode the lat/lon in columns A and B using Geokeo. Write the formatted street address to column C. Remove duplicate rows where columns A and B match exactly. Flag any row with no address result in column D as "no result." Write the consolidated output to a new tab called "Audit Export."
The cleanup, the dedup, and the geocoding happen in one shot — nothing left to do before you hand it to the auditors.
Try It
Get the 7-day free trial of SheetXAI and open the field check-in sheet, then ask it to reverse geocode the coordinate columns into readable addresses. If you need to go the other direction and geocode addresses into coordinates, see Geocode a Column of Addresses Into Lat/Lon Coordinates. For the full Geokeo integration overview, visit Geokeo in Google Sheets.