Add historical weather data and forecasts to your Google Sheets using the Weather Stats add-on. This tool helps you analyze weather patterns directly within your spreadsheets.
Use this add-on to correlate weather conditions with your Google Sheets data. For detailed analysis, you can import hourly data to track weather changes throughout the day.
Available Weather Elements
The add-on provides 50 years of historical data and 15-day forecasts, with information available in hourly or daily increments. Here’s a list of available weather elements:
-
Temperature
- The mean temperature in Fahrenheit or Celsius.
-
Max Temperature (Day Only)
-
Min Temperature (Day Only)
-
Conditions
- Notable weather conditions (rainfall, overcast, sunny) reported by weather stations. Not all stations report conditions.
-
Cloud Cover
- Percentage of the sky covered by clouds. The daily value is the mean of the hourly values.
-
Dew Point
-
Feels Like
- How hot it feels, considering heat and humidity.
-
Max Feels Like (Day Only)
-
Min Feels Like (Day Only)
-
Humidity
-
Moon Phase
- 0 – new moon
- 0-0.25 – waxing crescent
- 0.25 – first quarter
- 0.25-0.5 – waxing gibbous
- 0.5 – full moon
- 0.5-0.75 – waning gibbous
- 0.75 – last quarter
- 0.75 -1 – waning crescent
-
Precipitation
- The sum of the liquid equivalent rainfall, snow, or other precipitation in inches or millimeters.
-
Precipitation Cover (Day Only)
- This percentage represents the duration of measurable precipitation during a specific period. For instance, if a 24-hour period has twelve hours of measurable rainfall, the precipitation coverage is 50% (12/24*100). This data is only available for historical weather observations and summaries. Trace precipitation is considered zero for the precipitation element, but trace precipitation is still considered precipitation in the precipitation coverage. Consequently, it’s possible to have zero reported precipitation but still have some precipitation coverage.
-
Precipitation Probability (Forecast Only)
-
Precipitation Type (Forecast Only)
- Possible values are rain, snow, freezing rain, and ice.
-
Pressure
- The atmospheric pressure at a location with reduced pressure due to the location’s altitude removed is expressed in millibars.
-
Snow
- Amount of new fallen snow in inches or centimeters.
-
Snow Depth
- The average amount of snow on the ground for the time period. Snow depth increases with additional snow and decreases with melting and compaction in inches or centimeters.
-
SourceStations (Historical Only)
-
Sunrise (Day Only)
-
Sunset (Day only)
-
UV Index
- A value between 0 and 10 represents the ultraviolet (UV) exposure level for a specific hour or day. A value of 10 indicates high UV exposure, while 0 signifies no exposure. The UV index is determined by the amount of short-wave solar radiation, which is influenced by factors such as cloudiness, the type of clouds, the time of day and year, and the location’s altitude. Daily values represent the highest UV exposure among the hourly readings.
-
Visibility
- Visibility refers to the distance that can be seen during daylight. It encompasses weather phenomena like haze, mist, fog, and smoke. The distance is measured in miles or kilometers.
-
Wind Direction
- The wind direction indicates the direction from which the wind is blowing. It is measured in degrees from north. The range of wind direction is from 0 degrees (north) to 90 degrees (east), 180 degrees (south), 270 degrees (west), and back to 360 degrees.
-
Wind Gust
- Wind gust refers to the maximum wind speed recorded over a short duration, usually less than 20 seconds. It’s important to note that a wind gust necessitates a significant increase in the measured short-term wind speed compared to the average wind speed. The wind speed should typically be 10 knots (11 mph or 18 kph) higher. If the wind gust fails to meet these criteria, a null or empty value is returned.
-
Wind Speed
- The hourly speed and direction values are the average (mean) of the speed and direction for the two minutes before the measurement is recorded. Daily and other time period values represent the highest hourly values. The units of the data will vary depending on the unit group: miles per hour, kilometers per hour, or m/s. Wind speed is usually measured at a height of 10 meters above the ground in a location free from nearby obstructions.
-
Max Wind Speed (Day Only)
-
Mean Wind Speed (Day Only)
-
Min Wind Speed (Day Only)
-
Solar Radiation
- Solar radiation measures the power (in watts per square meter) at the exact moment of observation (or forecast prediction).
-
Solar Energy
- Solar energy (in MJ/m2) represents the cumulative solar radiation accumulating over an hour or a day.
-
Severe Risk (Forecast Only)
- Severe risk, a scaled measure between 0 and 100, represents the likelihood of convective storms, including thunderstorms, hail, and tornadoes. It incorporates various factors like convective available potential energy (CAPE) and convective inhibition (CIN), as well as predicted rain and wind. Generally, a severe risk value below 30 indicates low risk, between 30 and 70 moderate risk, and above 70 high risk.
How to Use Weather Stats
The process of using the app is as follows:
Step 1: Tell Weather Stats the dates for which you want the weather elements by pointing the add-on to the range in the spreadsheet containing the dates.
Step 2: List the locations in your spreadsheet and point the add-on to them with a reference to their cell range. You can use any description that identifies the locations, such as the city’s name or a popular tourist destination.
Step 3: Pick your data elements. If using hourly data, you can pick one at a time. If you are using daily data, use as many as you would like.
Click Run, and the weather data will appear in your spreadsheet.
Hourly or Daily
The weather elements are available in hourly or daily increments. Hourly data contains 24 entries for each day at the local time of the requested location.
Pricing
| Clear | Drizzle | Cloudburst | Downpour | |
|---|---|---|---|---|
| Price | Free | $9 / month | $19 / month | $.00012 per record** |
| Volume | 100 records* / day | 60,000 records* / month | 150,000 records* / month | $100 for 840K prepaid records |
| Upgrade | Upgrade | Purchase |
* A record is one row of weather data.
** Must prepay in $100 increments. $100 prepays for 840,000 searches.
Choose from the free plan or upgrade to a paid plan for more records.
Video Tutorials
FAQ
How do I solve the Permission Denied error code?
The error message “We’re sorry, a server error occurred while reading from storage. Error code PERMISSION_DENIED.” occurs when a user is logged into multiple Google accounts. Log out of all other Google accounts, restart your browser, and start the add-on again.
How do I use the add-on with my iPad?
Open your Google Sheet in the Safari web browser instead of Chrome or the Sheets mobile app. If you still do not see the full version of Google Sheets, go to Settings, then Safari, and select Request desktop website. Toggle this setting to on.
This add-on offers a comprehensive solution for integrating weather data into your Google Sheets. Install the add-on today to begin exploring weather trends and their impact on your data.