How to use the Microsoft Excel WEBSERVICE function to retrieve weather data

The Microsoft Excel WEBSERVICE function retrieves data from a URL into a single cell within an Excel worksheet. In this article we describe how to use WEBSERVICE to retrieve weather forecast and historical weather data directly into Excel without the need for macros or scripts. However, is it always the best way to work with …

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 …