Four free Excel datasets covering every US zip code — built from official NOAA station records.
Built from NOAA GHCN station records · 40,000+ US zip codes · Trusted by Fortune 500 and university teams
Get four free Excel datasets covering every US zip code: long-term average temperature, rainfall, snowfall, and humidity, all built from official NOAA station records. Each dataset gives the single long-term average value for every US zip code. Enter your email below and we will send one message containing all four download links.
Look up the climate by zip code
Every US zip code has its own climate fingerprint: decades of temperature, rainfall, snowfall and humidity records that describe what a place is actually like — not what the forecast says for tomorrow. Enter a zip code below to see the average weather by zip code, how it ranks against every other US zip, and a few things those long-term numbers say about snow, growing seasons and which famous places share its climate. Every figure comes from the same NOAA-built dataset you can download free on this page.
Your Zip Code’s Climate Fingerprint
Type any US zip code for an instant climate snapshot — computed from the same NOAA-built dataset you can download free below.
One email, four download links. Unsubscribe anytime.
What’s in the free datasets
| Dataset | Coverage | Data | Source | Format |
|---|---|---|---|---|
| Temperature | Every US zip code | One long-term average per zip | NOAA station records | .xlsx |
| Rainfall | Every US zip code | One long-term average per zip | NOAA station records | .xlsx |
| Snowfall | Every US zip code | One long-term average per zip | NOAA station records | .xlsx |
| Humidity | Every US zip code | One long-term average per zip | NOAA station records | .xlsx |
Sample rows from the free datasets
| Zip Code | City | State | Avg temperature (°F) | Avg rainfall (in/month) | Avg snowfall (in/month) | Avg humidity (% RH) |
|---|---|---|---|---|---|---|
| 98101 | Seattle | WA | 53.7 | 2.2 | 0.4 | 72.6 |
| 97201 | Portland | OR | 55.4 | 3.0 | 0.5 | 69.0 |
| 89101 | Las Vegas | NV | 70.8 | 0.3 | 0 | 26.5 |
| 85004 | Phoenix | AZ | 77.1 | 0.5 | 0 | 30.3 |
| 80202 | Denver | CO | 53.3 | 1.1 | 3.7 | 68.4 |
| 73301 | Austin | TX | 69.5 | 2.8 | 0.1 | 69.9 |
| 64101 | Kansas City | MO | 58.1 | 2.7 | 1.2 | 63.3 |
| 60601 | Chicago | IL | 53.5 | 3.0 | 2.7 | 64.3 |
| 55401 | Minneapolis | MN | 47.2 | 2.3 | 4.5 | 66.2 |
| 33101 | Miami | FL | 78.2 | 5.8 | 0 | 72.5 |
| 30301 | Atlanta | GA | 62.5 | 4.4 | 0.1 | 69.9 |
| 14201 | Buffalo | NY | 50.5 | 3.5 | 7.7 | 70.1 |
| 10001 | New York | NY | 56.5 | 4.2 | 1.8 | 61.6 |
| 02108 | Boston | MA | 53.1 | 3.6 | 3.0 | 65.9 |
Values are long-term averages over the rolling 10-year window (currently July 2016 – June 2026), shown to one decimal. The full files cover 40,000+ US zip codes.
How the data is built
Free vs. paid
- One overall long-term average per zip code
- All four metrics: temperature, rainfall, snowfall, humidity
- Instant email delivery — no credit card
- The underlying month-by-month and daily time series
- Every US zip code, plus 40,000+ global locations
- Excel/CSV files, one-time purchase
Frequently asked questions
Is it really free?
Yes. There is no credit card, no trial, and no payment step. You enter an email address and receive all four datasets.
What’s the catch?
The datasets are delivered by email, so we need a working address. We also send occasional emails about our paid datasets. You can unsubscribe at any time and keep the free files.
Can I use the data commercially?
Yes, within a single organization. You can use the data in internal analysis, reports, and client work, but you may not redistribute or resell the files themselves. See our terms for details.
How current is the data?
The averages cover a rolling 10-year window, currently July 2016 through June 2026, and are updated monthly as NOAA publishes new station records.
What units are used?
Temperature is in degrees Fahrenheit, rainfall and snowfall are in inches, and humidity is in percent relative humidity.
Do you have data outside the US?
The free datasets cover US zip codes only. Paid datasets cover more than 40,000 global locations in daily and monthly form — see pricing.
Get the free datasets
Enter your email in the form above to receive all four Excel datasets in one message. If you need the full 10-year daily or monthly time-series, see pricing.