Importing historical weather data into your spreadsheet is a valuable planning tool. You can predict future trends based on correlations with previous weather. This tutorial will cover a technique to bring historical weather directly into your spreadsheet.
The Weather Stats Google Sheets add-on automates importing historical daily or hourly weather data into Google Sheets. Whether you’re looking for temperature, precipitation, or something more obscure, here’s how to get started.
Contents
Install the Weather Stats Add-On
- Open Google Sheets and click on the “Extensions” menu
- Click “Add-ons” then “Get Add-ons”
- Search for “Weather Stats”
- Click “Individual Install” to install the add-on
- The add-on is now available in your browser’s side panel.
Pick the Locations and Dates
The add-on uses dates and locations listed in your spreadsheet. You can use any location format, including zip codes, city/state combinations, or place names.
For this example, we’ll look at the weather in the first seven days in March for three years in the ski resort town of Winter Park, Colorado.
Import Historical Weather Data
Once you have installed the add-on and choose dates and locations, here’s how to pull your first weather dataset:
- Click the “Weather Stats” icon to open the side panel
- Choose between “Hours” or “Days”
- Select the cells containing your date range
- Select the cells with your location (Winter Park, CO)
- Choose the weather elements you need.
- In this example, we’ll choose temperature, conditions, and humidity.
- Click “Run.”
The add-on automatically formats your data in columns, with one row for each location.
Work with the Data
After looking at the temperature and snowpack data for Winter Park, it appears you have good data to compare to sales trends. In this next post, let’s look at how to correlate weather data to business data.
How to Use the Weather Stats Add-On
Related Articles
-
How Weather Impacts Your Bottom Line: Analyzing Historical Data
Learn how to analyze patterns in weather and how they correlate to your business profitability.
-
Get Historical Weather Data 🌤️ Google Sheets Weather Stats
Learn how to import historical weather statistics into Google Sheets using the Weather Stats add-on.
-
Get Weather Forecasts in Google Sheets 🌤️ Weather Stats Add-On
Use the Weather Stats Google Sheets add-on to bring historical or forecasted weather data into your spreadsheet. Stats can be hourly or daily.
-
Weather Stats – Google Sheets Add-On
Use the Weather Stats add-on to import historical or forecast weather elements into Google Sheets.