Articles, videos, and documentation to help you get the most from Visual Crossing Weather
Easily import weather data into Microsoft Excel and Google Sheets with our rich tools and tutorials.
In other documents we have show you how to use the Visual Crossing Weather Data Services capability to do Query API loading of weather data directly into Excel. There are three primary Excel use cases for Weather Data. 1) Load a fixed query set of data into a table and reference that table for …
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 …
Continue reading “How to use the Microsoft Excel WEBSERVICE function to retrieve weather data”
While it is very easy to load weather data into Google Sheets via CSV, loading JSON can seem a bit more challenging. However, for the savvy Google Sheets user, loading JSON weather data from the Visual Crossing Timeline Weather API is almost as easy as using CSV and offers additional benefit and functionality that CSV …
Continue reading “How To Load Weather Data into Google Sheets using JSON”
Pivot Tables are an invaluable tool for displaying and analyzing data of all types. They allow users to pivot all types of data so that the data is formatted exactly as the viewers of data would get the most benefit whether they are viewing a grid of data or they are viewing graphs that require …
Continue reading “How do I load Weather History data into a Pivot Table?”
This articles shows how to download weather forecast data as a standard Excel file format that can be opened in Apache OpenOffice Calc. If you would prefer, you can also download weather data in CSV format. See how to download weather forecast data or weather history data as CSV format. Step 1 – Open the …
Continue reading “How to load Weather Data into Apache OpenOffice Calc”
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 …
Continue reading “How to automatically refresh Weather Data in Microsoft Excel”
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 …
Continue reading “How to add Weather Data to Google Sheets using a Dynamic Weather Query”
Learn how the Weather Workbook is constructed and how you can modify it to make your own custom interface. Background Many of you may already be familiar with the Visual Crossing Weather Workbook for Excel. If you are note and want to learn more we encourage you to first download the workbook and pull data …
Continue reading “Weather Workbook for Excel – Customization”
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 …
Continue reading “Getting Started with Weather Add-in for Microsoft Excel”