Every dataset covers all US zip codes and downloads instantly as an Excel or CSV file. Start with the data type you need:
Every dataset on this site is delivered as a flat file you can open directly in Microsoft Excel — no API keys, no query language, no subscription required. You buy the file once, download it instantly, and keep it.
Each download is a spreadsheet (.xlsx or CSV) with one row per US zip code. Columns are simple and consistent: zip code, city, state, and the weather values — long-term averages, monthly values, or daily values depending on the dataset. Temperature is in degrees Fahrenheit, rainfall and snowfall in inches, and humidity in percent relative humidity. Files cover 40,000+ US zip codes, built from official NOAA station records over a rolling 10-year window and updated monthly.
The files open in Excel, Google Sheets, Apple Numbers, or any tool that reads spreadsheets — including Python and R for analysis work. There are no formulas, macros, or locked cells: just clean rows of data you can sort, filter, pivot, and join to your own sales, claims, or research data by zip code.
Not ready to buy? Start with our free historical weather data by zip code — four Excel datasets (average temperature, rainfall, snowfall, and humidity for every US zip code) delivered by email.
Every dataset is compiled from NOAA / NCEI weather station records. We map station observations to US zip codes so you can look up temperature, precipitation, snowfall, or humidity for any location without processing raw station files yourself.
Datasets are delivered as flat Excel (.xlsx) or CSV spreadsheets. They open directly in Excel or Google Sheets and load cleanly into Python (pandas), R, SQL databases, and BI tools. No API keys and no special software.
No. Every dataset is a one-time purchase with an instant download link. You buy the file once and keep it.
Time-series datasets cover the most recent 10 years of daily or monthly observations. Long-term average datasets summarize typical conditions for each month of the year. Longer histories and custom date ranges are available as custom requests.
Yes. Standard files already include every US zip code, and we build custom extracts (specific regions, longer histories, other variables) on request. Email contact@weatherdatabyzipcode.com or use the chat on this site.
Yes. Every file opens directly in Microsoft Excel, and also works in Google Sheets, Apple Numbers, LibreOffice, Python, and R. No conversion or special software is needed.