Articles, videos, and documentation to help you get the most from Visual Crossing Weather
Documentation for Weather Data, the Weather API and its uses in code, programming, data science and other applications.
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 …
In our previous article, we discussed how the sun powers the weather around us. By heating the Earth, the energy from the sun, radiates across space and is absorbed by the Earth. The energy of the earth is raised as therefore so is the temperature. In this article, we will discuss how this energy powers the …
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 …
In this article we will describe various techniques to include both historical weather data and weather forecast data into a Microsoft Word document.
We are going to walk you through building a PowerPoint that has a graph of your current forecast. We will utilize the ability to pull Visual Crossing Weather Data directly into your PowerPoints and have them update the forecast everytime you open it. Weather data provider We are going to use a number of techniques …
Continue reading “How do I add weather data into Microsoft PowerPoint?”
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”
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”