How can I use the Visual Crossing Weather date chooser to jump to historical weather for any time?

Finding historical weather data for any time range using Visual Crossing Weather is very easy. However, a common question we get is how to use the date chooser calendar control to quickly jump months, years, or even decades. This short video will show you how to become a master of the calendar widget in just …

Multi-site Forecast Workbook for Excel

Multi-Site Forecast 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. We recently released a downloadable Weather Workbook that allows users to query weather data directly into Excel. In this blog we will show you the Multi-Site Forecast Workbook which is a …

How to automatically refresh Weather Data in Microsoft Excel

In this article we will use Web Queries in Microsoft Excel to retrieve Weather Data such as a weather forecast, historical weather observations or historical weather and climate statistics. We will then set the queries up to refresh automatically. This powerful refresh technical can be used to ensure that the latest weather forecast is populated into …

How to add Weather Data to Google Sheets using a Dynamic Weather Query

The value of weather data comes from what you do with it.   In order to get value from our weather data typically users will import it into other business systems or spreadsheet systems such as Excel or Google Sheets.   In this document we will demonstrate how to get a Visual Crossing Weather query directly into …

Getting Started with Weather Add-in for Microsoft Excel

  This tutorial will guide you through the process of joining an existing Excel sheet to both historical and forecast weather data using Visual Crossing Weather Add-in for Microsoft Excel.  For sample data we will use a sheet containing several store locations on the US East Coast.  First-time users are encouraged to walk through the …