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 …

How do I retrieve weather data using an ODATA request?

This article describes how to retrieve weather data such as weather forecast, historical weather observations and historical climate summaries using an ODATA bahttps://www.visualcrossing.com/resources/documentation/weather-api/building-and-running-your-first-weather-api-query/sed request. What is ODATA and when should I use it? According to odata.org: OData (Open Data Protocol) is an ISO/IEC approved, OASIS standard that defines a set of best practices for building and consuming RESTful APIs. …