Weather Workbook – Legacy Version
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 …
How to schedule weather data queries
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 …
How to download weather data for multiple locations
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”
Timeline Weather API
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 …
How to load weather data using Python
In this article we load historical weather data and weather forecast data using Python
How to download weather forecast data as a Microsoft Excel Workbook
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”
How can I load weather forecast data into Google Sheets?
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?”
How to build a great Weather Dashboard
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 …
Using remote data sources in the Weather API
The Visual Crossing Weather API provides access to both historical and future, forecasted weather data. Wherever possible, we use official, physical weather station observations to provide the historical weather data. This ensures that the observations are of the highest quality. However in some cases, such as remote locations away from official weather stations or stations …
Continue reading “Using remote data sources in the Weather API”
Degree Day Weather API
Degree days are a standardized method to calculate the total heat or warmth a location has experienced. They are used in agriculture and gardening to estimate the growth stages of plants and phenology. Degree days can be also be used in building construction and maintenance as a way to estimate the heating and cooling needs …