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 …
Visual Crossing has introduced a new Query Builder tool scheduling service for creating bulk, scheduled datasets that can be downloaded at any time. We have updated Weather Workbook to download these datasets directly into Excel. In this blog we will show you how to get the Weather Workbook, enable it with your own link and …
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”
Have you ever want to do more with weather data in your Excel workbooks? In this blog entry we are going to consider the tasks of a construction site manager and we want to create a workbook where we can easily monitor the weather at a large number of sites to evaluate many different weather …
Filter and Alert on Large Volumes of Weather Forecast Data. The Weather Alert Workbook is designed for the end-user who wants to query a large number of site forecasts and be alerted to exceptional weather conditions at those locations. It is a free Excel Workbook for all of our users to download and use and/or …
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 …
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”