Importing data from a JSON Weather API into Microsoft Excel using Power Query

This article shows how to import data into Microsoft Excel using Power Query from a RESTful Weather API. This API returns JSON-based data. 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 result table …

How to Load Weather Data into Microsoft Excel using a Web Query Data Connection

One of the powerful features of the Visual Crossing Weather Service is the ability to query data via a Web Service or URL.  This benefits not only coders but rather can be utilized to import data into most Business Intelligence Systems including Excel.   When you include your data into Excel, you can refresh the data …

How can I download weather forecast data as a CSV file?

In this article, we will show you how to easily download forecast weather data as a standard CSV file that can be imported into thousands of data analysis and storage applications such as business intelligence systems, visualization tools, statistical analysis packages, and databases. If you would like to download weather history data as a CSV, …

How Historical Weather Data Records are Created from Local Weather Station Observations

Visual Crossing Weather Data offers historical weather data coverage for most locations in the world. To provide as accurate a historical weather data picture as possible, the product looks at multiple nearby weather stations so that the most accurate weather picture is created.  This article explains the process used to create the historical weather records, how …

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: …