How To Load Weather Data into Google Sheets using JSON
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”
Importing data from a JSON Weather API into Microsoft Excel using Power Query
In this article we are going to demonstrate how to import data from a RESTful Weather API. This API returns JSON-based data into Microsoft Excel. We are also going to explain how to create a loop within our script so that we can call the API multiple times for multiple locations and create a combined …
Continue reading “Importing data from a JSON Weather API into Microsoft Excel using Power Query”
Weather API JSON result structure
This document applies to the /forecast and /history endpoints. If you are using the Timeline Weather API (/timeline), you can find the JSON structure documented on the Time Weather API documentation page. This article describes the JSON structure returned from the weather API. This same basic structure is returned for both weather forecast, weather history …
How to include sunrise, sunset, moon phase, moonrise and moonset data into your API requests
In addition to providing historical weather observations and weather forecast data, the Weather API also provides astronomical information. This astronomical information includes sunset, sunrise and moon phase data. Why is astronomical information useful? Sunset, sunrise and moon information goes hand-in-hand with weather data in many use cases. The information can help answer some basic questions: …
How can I load weather forecast data into Microsoft Power BI?
In this article, I’m going to show how you can quickly and easily load weather forecast data for any worldwide location into Microsoft Power BI for further analysis. Visual Crossing Weather enables you to import forecast or historical weather data into Power BI. The data can be imported as CSV or JSON depending on your …
Continue reading “How can I load weather forecast data into Microsoft Power BI?”
What exactly is a weather record?
A weather record is the smallest unit of weather data that is used in the Visual Crossing Weather accounting process for our plans. Whether you have unlimited data access or are limited to 1000 records per day as a member of our Free plan, it is useful to understand the accounting behind weather records What …
How to Build a Weather Dataset for Download, Bulk Import or Scheduling
If you have ever tried to download weather data for your specific location(s), timeframe and format needs you will know that it is a challenging exercise. Most of the time the solution is for you use the API to build a script or using coding to create this set. This creates additional cost, time and …
Continue reading “How to Build a Weather Dataset for Download, Bulk Import or Scheduling”
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