Enter a location and a date. Get the weather. Weather Stats brings 50 years of historical weather and 15-day forecasts directly into Google Sheets™, with no API key to obtain and nothing to configure. Point the add-on at a column of places and a column of dates, and the answers land in your spreadsheet.

Join 5,000+ teams already using it.

How It Works

1. Select the column holding your dates, and the column holding your locations.
2. Choose the weather elements you want.
3. Click RUN.

The results fill in beside your data. Long lists are written in batches, so a job that takes a while resumes where it left off rather than timing out.

33 Weather Elements

Temperature, max and min temperature, feels-like, conditions, cloud cover, dew point, humidity, precipitation, precipitation type, precipitation probability, precipitation cover, snow, snow depth, pressure, wind speed, wind gust, wind direction, visibility, UV index, solar radiation, moon phase, sunrise, sunset, and more.

Available for any location, in Fahrenheit or Celsius, metric or imperial.

Perfect For
✓ Event Planners — check what late September has actually done at a venue before you commit to the date
✓ Travel & Cruise Planning — build an itinerary with the forecast, or the historical average, beside each stop
✓ Researchers & Analysts — pull decades of daily observations into a sheet you can already work in
✓ Teachers & Students — climate and science projects without an API key or a line of code
✓ Agriculture — harvest windows, frost dates, and growing-season comparisons
✓ Insurance & Claims — verify conditions on a date at a location, from the historical record
✓ Operations — correlate weather against sales, staffing, or footfall data you already keep in Google Sheets™

Plans

Free
• 5 runs per month
• Up to 25 rows per run
• Up to 3 weather elements per run
• Daily values
• The full 50-year archive and 15-day forecast

Pro — $9/month
• Unlimited runs
• No row limit
• All 33 weather elements
• Hourly values as well as daily
• Compare any date against the historical normal for that location
• Save a setup as a recipe and re-run it in one click
• Insert charts and apply conditional formatting to your results

A run is one click of RUN. Continuing a long job with "Run Next" does not count against your monthly runs.

Already installed Weather Stats? Nothing about your plan changes. Everyone who installed before 1 October 2026 keeps the original free terms — 1,000 records a day, with hourly values, normals, recipes, charts and formatting all included — permanently. The Free plan described above applies to new installs only.

No API key to obtain. Install the add-on and it works.

—
Google Sheets™ is a trademark of Google LLC. Weather Stats is an independent add-on and is not endorsed by or affiliated with Google LLC. Weather data is provided by Visual Crossing.