The Scenario
A federal safety report is due in 72 hours and you've just inherited it from the planner who left the department last month. The handoff file is an Excel workbook with 500 rows of GPS coordinates — latitude and longitude pairs recorded at incident sites across three states. Every row needs a standardized US street address, county name, and state FIPS code before the report can go to the agency. The previous planner's notes reference a Geocodio export somewhere, but nobody knows where the file is.
The bad version:
- Copy the coordinate pairs into Geocodio's batch reverse geocode interface, which expects a specific CSV format with headers Geocodio recognizes — not the column names currently in your workbook.
- Download the enriched output, then spend an hour reconciling the 500 output rows against the 500 source rows, because the export sorted differently and three rows appear to be missing.
- Reformat the address fields: Geocodio returns "formatted_address," "county," "state," and "state_fips" — your report template wants "Street Address," "County Name," and "FIPS Code" in specific columns.
Three hours of formatting work for a task that should take ten minutes. The previous planner clearly had a process and took it with them.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads the coordinate pairs in your worksheet, sends them to Geocodio as a batch reverse geocode request, and writes the structured address fields back into the correct columns — no CSV template, no output file, no column rename step.
Open the sidebar and paste this prompt:
Use Geocodio batch reverse geocode on all 500 coordinate rows in this Excel spreadsheet and fill in the street address, county, and state FIPS code columns
What You Get
- Column C: full formatted street address (e.g., "1234 Main St, Sacramento, CA 95814")
- Column D: city
- Column E: state abbreviation (e.g., "CA")
- Column F: ZIP code
- Rows where Geocodio returns no result get "no match" in column G rather than a blank that's easy to miss
What If the Data Is Not Quite Ready
Some coordinate pairs are in DMS format (degrees-minutes-seconds) rather than decimal degrees
Convert all coordinates in columns A and B from degrees-minutes-seconds format to decimal degrees, then batch reverse geocode the converted pairs using Geocodio and write the formatted address, city, state, and state FIPS code into columns C through F
The workbook has coordinates in two separate worksheets — "Highways" and "Intersections" — and the report needs everything on one output worksheet
Combine all lat/lon pairs from the Highways worksheet columns A and B and the Intersections worksheet columns A and B into a single batch reverse geocode request using Geocodio, then write each result to the Output worksheet with the source worksheet name in column A and the formatted address, county, and state in columns B through D
Some rows have null or zero coordinates that should be excluded before the API call
Skip any rows in columns A and B where lat or lon is blank, zero, or outside the continental US bounding box, then batch reverse geocode the remaining valid pairs using Geocodio and write the street address, county, and state FIPS into the matching rows in columns C through E
The safety report needs the street address, county FIPS, state FIPS, and a source-verified flag — and the ten rows with swapped lat/lon need to be corrected first
Scan columns A and B for any coordinate pairs where latitude and longitude appear to be swapped (longitude values above 40 and below 90, or latitude values below -70), fix them, then batch reverse geocode all 500 rows using Geocodio and write the street address, county FIPS, state FIPS, and a "coordinates corrected" flag into columns C through F
One prompt handles the coordinate validation and the API call together — no intermediate step.
Try It
Get the 7-day free trial of SheetXAI and open the Excel workbook with your GPS coordinate pairs. Tell SheetXAI which columns hold the lat and lon values and what address fields you need from Geocodio — the batch reverse geocode runs and writes results back without any CSV roundtrip. See also how to batch geocode forward addresses or pull full legislative metadata for your locations.