The Scenario
The logistics coordinator who built your route planning workbook left the company three weeks ago. You inherited an Excel file with 25 delivery destination cities in column A, no coordinates, no weather, and a note in the header row that says "enrich before routes finalize."
You have no idea what enrichment process they used. You have a route review call in an hour.
The bad version:
- Search online for a geocoding tool that accepts city names in bulk, export the results, copy the lat/lon columns into your workbook
- Switch to Weathermap, look up conditions for each city one at a time, note the temperature and description for each row
- Reconcile the two datasets to make sure the lat/lon and weather values line up with the right city — because the order got shuffled somewhere in the export
Two separate tools, two separate export/import cycles, and you're the one manually ensuring they're aligned. By the time you're done, the weather data from the first city you looked up is already an hour old.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads your data and talks to Weathermap directly — including its geocoding API — so it can resolve city names to coordinates and pull current conditions in a single pass, writing everything back into the same worksheet.
For each city name in column A (25 rows), geocode with Weathermap to get lat/lon and write them into columns B and C, then fetch current weather and write temperature and condition description into columns D and E
What You Get
- Column B: latitude for each city
- Column C: longitude for each city
- Column D: current temperature (the unit you specified, or Celsius by default)
- Column E: plain-language weather description ("broken clouds," "moderate rain")
- Rows where a city name fails geocoding get a note in column E so you can spot them before the review call
What If the Data Is Not Quite Ready
Some cities have country codes appended and others don't
For each city in column A, strip any country code or region suffix before geocoding with Weathermap, then write lat/lon into columns B and C and current weather temperature and description into columns D and E
You want more detail than just temperature and description
Geocode every city in column A using Weathermap, paste lat in column B and lon in column C, then look up current weather and add temperature, humidity, wind speed, and description in columns D through G
You only need to enrich cities where column F is marked "Pending"
For rows where column F says "Pending," geocode the city in column A with Weathermap to get lat/lon and write into columns B and C, then fetch current weather and fill columns D and E with temperature and condition description — leave all other rows unchanged
Kill chain: geocode, enrich weather, flag road condition risk, and mark routes ready in one shot
For each city in column A: geocode with Weathermap and write lat/lon into columns B and C, fetch current weather and fill columns D through G with temperature, humidity, wind speed, and description, add a column H with 'Weather Risk' if wind exceeds 20 mph or description contains "fog" or "rain," and mark column I as "Route Ready" for all rows without a weather risk flag
That's geocoding, enrichment, risk classification, and route readiness in a single instruction — which is what you actually needed before the call.
Try It
Get the 7-day free trial of SheetXAI and open your route planning workbook with delivery cities in column A, then ask it to geocode and enrich every row with live conditions before routes are finalized. See also: enrich job sites with weather and the full Weathermap hub.