Articles, videos, and documentation to help you get the most from Visual Crossing Weather
For those of you familiar with the original Weather Workbook, this is the original mode of operation for users to connect Excel to the Visual Crossing Weather Server and retrieve, live, parameterized queries. This version differs from the new version that focuses on retrieving scheduled CSV datasets built using the new QueryBuilder and producing downloadable …
In many cases, it is very useful to be able to schedule a weather query to run for you periodically and then deliver the latest data directly into your analysis. Imagine having the forecast for all of your business locations updated fresh each morning in your Excel sheet right before your planning meeting? Consider a …
Downloading weather data for multiple locations in CSV, Excel, or JSON format is easy using our Query Builder page. In this guide, we will walk through the process of uploading a file of location or pasting in CSV data from the clipboard, composing a weather query, previewing weather data for these locations, and then downloading …
Continue reading “How to download weather data for multiple locations”
The Timeline Weather API is the simplest and most powerful way to retrieve weather data. You can request data over any time window including windows that span the past, present, and future. The API will take care of the combining historical observations, current 15-day forecasts, and statistical weather forecasts to create a single, consolidated dataset …
In this article we load historical weather data and weather forecast data using Python
In this article, I’m going to show how to download weather forecast data as a standard Microsoft Excel file. The estimated time to complete this exercise is less than 5 minutes. Step 1 – Open the Weather Data Query Page We’ll start by going to the Weather Data Services page. Then we need to click …
Continue reading “How to download weather forecast data as a Microsoft Excel Workbook”
In this article, I’m going to show you how to easily load weather forecast data into Google sheets. We’ll walk through the process step-by-step showing you how to construct the query in Visual Crossing Weather and then use the query URL to import the weather results into Google Sheets. Also see our companion article that …
Continue reading “How can I load weather forecast data into Google Sheets?”
When you are exploring forecast weather data for business and personal use, it is important to know what weather measures are available. In this article we’ll provide a overview of the available weather metrics (also known as weather variables and weather parameters) grouped by theme. In addition, we’ll supply links to more detailed information where …
Continue reading “What forecast weather measures are available?”
Dashboards are one of the most effective ways to communicate data to users. Originating, from the dashboard in cars and vehicles, data dashboards typically combine multiple data visualization elements such as charts, maps, grids and KPIs to provide users with a fast, concise, and clear way to interpret a set of data. For businesses, organizations …
If you are getting an expired certificate error running Visual Crossing Weather API queries, this article will explain the likely cause and how to fix it. The problem On September 30, 2021, an old version of the Let’s Encrypt “intermediate” certificate expired. While our servers have been delivering the updated version of this certificate for …
Continue reading “Certificate error running Weather API requests”