The Scenario
Your logistics coordinator runs a weekly route-planning document in Excel. This week's batch: 400 delivery GPS coordinates collected from driver devices over the past month, sitting in columns A and B — latitude in A, longitude in B, nothing else.
The route-planning tool expects full postal addresses and local timezones. Without them, the coordinator has to look up addresses one at a time using an online geocoder, copy the results by hand, and manually figure out which timezone each delivery location falls in before scheduling handoff windows.
Someone handed this task off three weeks ago and it never got done because it's 400 rows of repetitive lookups.
The bad version:
- Export the coordinate columns as a CSV, write a script to call the reverse geocoding API, handle the rate limits.
- Get the output back as a CSV, reimport it into the workbook, reformat the columns to match the template.
- Discover the address format for international deliveries uses a different field order than domestic ones, go back and normalize the output.
The route planning meeting is tomorrow and the workbook still has 400 empty address cells.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that runs inside your Excel workbook and calls BigDataCloud's reverse geocoding API on your behalf. You describe the task — it handles the coordinate-to-address conversion and the timezone lookup, then writes the results back into your worksheet.
Open SheetXAI from the Excel add-in panel and type:
Convert all coordinate pairs in my Deliveries Excel sheet to readable street addresses and add a local timezone column
What You Get
- Column C: formatted postal address (street, city, state/province, country)
- Column D: IANA timezone identifier (e.g., "America/Chicago", "Europe/Paris", "Asia/Tokyo")
- Rows where the coordinate pair returns no result get a blank cell; the SheetXAI add-in panel notes the count of unresolved coordinates after the run
What If the Data Is Not Quite Ready
The coordinate columns have inconsistent decimal precision
Reverse-geocode the lat/lon pairs in columns A and B of the Deliveries worksheet using BigDataCloud — round each coordinate to 6 decimal places before the API call, then write formatted address and timezone into columns C and D
Some rows have the coordinates reversed — longitude first, latitude second
Reverse-geocode the coordinates in columns A and B using BigDataCloud — column A contains longitude and column B contains latitude (reversed from standard), swap them before the API call, then write address and timezone into columns C and D
The data spans two worksheets — one for domestic deliveries, one for international
Reverse-geocode all lat/lon pairs in column A and B on the "Domestic" worksheet and the "International" worksheet using BigDataCloud, write formatted address and timezone into columns C and D on each worksheet, then copy all rows into a combined worksheet called "All Deliveries"
Full route-prep pass in one prompt
Reverse-geocode all coordinate pairs in columns A and B using BigDataCloud and write address and timezone into columns C and D — then flag in column E any row where the timezone is outside UTC-5 to UTC+3 (international delivery requiring special coordination), and sort the flagged rows to the top of the worksheet
One prompt handles the geocoding, the timezone enrichment, the flagging, and the sort.
Try It
Get the 7-day free trial of SheetXAI and open any Excel workbook with a column of GPS coordinates — paste the prompt above and have your delivery addresses and timezones ready for the route-planning meeting. See the IP-to-timezone spoke if you also need to resolve timezone data from IP addresses in a separate worksheet.