Bulk Fetch Current Weather for a List of Cities Into a Excel workbook

The Scenario

The weekly supply chain standup is in 90 minutes. You're the ops coordinator, and your job before that call is to flag any warehouse or supplier location that might have shipment delays today based on weather. You have an Excel workbook with 30 city names in column A — warehouses, cross-docks, and Tier 1 suppliers across North America. Columns B through F are empty.

The bad version:

• You open the OpenWeather website, search each city one at a time, and note down the conditions manually — 30 cities, 30 lookups, 30 copy-paste moments just to get a temperature and a description into the workbook.
• Around city 14 you realize you forgot to log the wind speed, which someone always asks about during the call, so you start over on a second pass.
• You finish with 20 minutes to spare, but two of the city names returned "not found" in the search bar and you're not sure if that means no data or a typo in the original list.

This standup happens every Monday. The weather changes every week. The list of cities occasionally changes too. You are not being paid to do 30 manual API lookups before a standup — you are being paid to know what the data means.

The Easy Way: One Prompt in SheetXAI

SheetXAI is an AI agent that lives inside your Excel workbook. It reads the city names in column A, calls the OpenWeather API for each location, and writes the weather data back into the columns you specify. You describe what you need once.

For each city name in column A, fetch the current weather from OpenWeather and write the temperature (°C), weather description, wind speed, and humidity into columns B, C, D, and E — then flag any row in column F as 'DELAY RISK' where the weather description contains 'storm', 'snow', or 'heavy rain'

What You Get

• Column B: current temperature in Celsius for each city
• Column C: weather description (e.g., "heavy snow", "broken clouds", "thunderstorm with heavy rain")
• Column D: wind speed in m/s
• Column E: humidity as a percentage
• Column F: "DELAY RISK" for any row where the description matches the flagging criteria; blank otherwise
• Cities that return no result from OpenWeather are noted with an error marker so you can investigate the name format

What If the Data Is Not Quite Ready

The city names are inconsistent — some are "New York", some are "NYC", some have state abbreviations

Normalize all city names in column A to standard city-state format (e.g., "New York, NY") before fetching current weather from OpenWeather — then write temperature, description, wind speed, and humidity into columns B through E and flag column F for delay risk

Some rows have missing city names and should be skipped

For each non-empty row in column A, fetch current weather from OpenWeather and write temperature (°C), description, wind speed, and humidity into columns B–E — leave columns blank for any empty city rows and note 'SKIPPED' in column F

The workbook has a second worksheet called 'Suppliers' with additional cities that need the same enrichment

Fetch current weather from OpenWeather for all city names in column A of both the 'Warehouses' worksheet and the 'Suppliers' worksheet — write temperature, description, wind speed, and humidity into columns B–E on each sheet, and flag column F as 'DELAY RISK' on both where applicable

You need cleanup, analysis, and the flagging done in one shot before the call

Clean up any inconsistent city names in column A (fix abbreviations, remove trailing spaces), fetch current weather from OpenWeather for each city and write temperature (°C), description, wind speed, and humidity into columns B–E, flag column F as 'DELAY RISK' for storm/snow/heavy rain conditions, then add a summary row at the bottom of the workbook counting how many locations are flagged

The pattern: pair the cleanup task with the fetch and the analysis in a single prompt — SheetXAI handles all three passes in sequence.

Try It

Open an Excel workbook with any list of cities or locations and Get the 7-day free trial of SheetXAI — ask it to fetch current weather for each row and flag severe conditions, exactly as you'd do it before your next ops review. You can also see how it handles 5-day forecast enrichment or browse the OpenWeather API overview for all supported use cases.