Weather Data Workbooks for Excel

Our free Excel Workbooks provide the easiest way to incorporate weather data into your spreadsheets & worksheets
Our workbooks are all open source. We even provide descriptions on how they work so you can learn more about our Weather API.

The Weather Workbook

The Weather Workbook

The Visual Crossing Weather Data Service enables users anywhere to load weather data into Excel, Google Sheets, Relational Databases, Business Intelligence Tools and more. Recently released was a downloadable workbook that allows the user to simply enter locations and query the data to their Excel workbook.

More info Download

Degree Day Calculator

Degree Day Calculator

Degree Days are a way to help determine how much warmth or cold there has been, typically over a season such as winter, summer or a plant's growing season. Degree Days are used to determine a building's typical heating or cooling requirements over a season. They are used in agriculture, farming and gardening to plan plant and crop planting, management and harvest dates. In this blog we provide Microsoft Excel-based degree day calculator that you can download and use.

More info Download

Multi-site Weather Forecast Workbook for Excel

Multi-site Weather Forecast Workbook

In this blog we will show you the Multi-Site Forecast Workbook which is a modified variation of the Weather Workbook dedicated to showing the forecast for multiple sites in an Excel Pivot Table for optimal viewing. One of the biggest requests we get from users is the ability have a forecast for just a few weather variables where they can quickly see the forecast for all of their locations in a single view. They also want the capability to easily modify those locations as well as flag any temperatures that are outside of a particular range.

More info Download