The Scenario
It's 6:45 AM and your dispatch sheet has 40 job site addresses in column A. Crews start loading trucks at 7:30. Your field manager just messaged asking whether Site 12 and Site 27 are safe to send people to today — high winds were in the forecast.
You don't have weather for any of those sites. You have a list of cities in an Excel workbook and nothing else.
The bad version:
- Open Weathermap's interface in one tab, your workbook in another, look up Site 12's city, copy the temperature and wind speed into the row by hand
- Repeat for all 40 addresses, keeping track of which row you're on as the tab count climbs
- Finish 35 minutes later to find Site 12's data is already stale and your field manager has stopped waiting
Your dispatch window is 45 minutes. That's not enough time to hand-enrich 40 rows, field the follow-up questions, and still get crews briefed before they leave. The lookups are the job — but nobody hired you to do them one at a time.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that sits inside your Excel workbook. It reads the data in your worksheet and talks to Weathermap directly, pulling current conditions for every location in one pass. No tabs, no copying, no row-by-row lookups.
For each city name in column A (40 rows), geocode the location with Weathermap then fetch current weather and write temperature in Celsius, weather description, and wind speed into columns B, C, and D
What You Get
- Column B: current temperature in Celsius for each site
- Column C: weather description (e.g. "light rain," "overcast clouds," "clear sky")
- Column D: wind speed in m/s
- Any row where geocoding fails surfaces a note in the description column so you know which site needs a manual check
What If the Data Is Not Quite Ready
City names are inconsistent — some rows have "Chicago, IL," others have just "Chicago"
For each address in column A, normalize the city name by stripping state abbreviations and extra punctuation, then use Weathermap to fetch current weather and write temperature, description, and wind speed into columns B, C, and D
Some rows have full street addresses instead of city names
For rows in column A where the value looks like a street address rather than a city name, extract just the city from the address, use that city with Weathermap to fetch current weather, and write temperature in Celsius, description, and wind speed into columns B, C, and D
You only want weather for sites flagged as active in column E
For every row where column E says "Active," use the city in column A to fetch current Weathermap weather and fill columns B through D with temperature in Celsius, weather description, and wind speed — leave rows where column E is blank or says anything else untouched
Full kill chain: normalize city names, enrich weather, and flag unsafe conditions in one shot
For each row in column A: extract the city name if the value is a full address, then use Weathermap to fetch current weather and write temperature in Celsius, description, and wind speed into columns B, C, and D — then add a column E that says "Hold" if wind speed exceeds 10 m/s or description contains "storm" or "thunderstorm," otherwise "Clear"
One prompt handles the cleanup, the enrichment, and the dispatch decision simultaneously — which is the point.
Try It
Get the 7-day free trial of SheetXAI and open your dispatch workbook with field site cities in column A, then ask it to enrich every row with live weather before your crews head out. See also: geocode delivery cities with weather and the full Weathermap hub.