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 …

What is a Weather API?

A weather API is an Application Programming Interface that allows weather data to be queried from scripts and code. Good weather APIs provide both historical weather data and forecast data via an easy-to-use, well-defined programming interface. The best APIs have dozens of weather measures, near-real-time current conditions reporting, and decades of worldwide historical weather reports. …

Where can you find high quality Historical Weather Data at a low cost?

Finding weather data on the internet is easy. While finding historical weather data is a little more difficult, there are various places to find data including free consumer sites, government data feeds, and commercial services and APIs. However, the easiest data sources to find tend to be the hardest to use and the least complete. …

Where can I find historical heat index and wind chill data?

Historical heat index and wind chill data are very important “feels like” weather measures for use in measuring the comfort level of people and animals outdoors. Whether you are using these metrics to plan events, predict attendance levels, or plan heating and cooling for large groups or your personal outdoor activities, a weather data service …

How to add free weather information to an Evernote notebook

Weather information plays an important role in a lot of your daily tasks. Having the forecast and the conditions of the past days on your fingertips helps you to successfully manage your tasks. In combination with evernote you will have the necessary information where and whenever you need it. This tutorial will show how to …

What historical weather measures are available?

When you are exploring historical 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 …