Articles for "weather history"

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 …

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 …

How to use the Microsoft Excel WEBSERVICE function to retrieve weather data

The Microsoft Excel WEBSERVICE function retrieves data from a URL into a single cell within an Excel worksheet. In this article we describe how to use WEBSERVICE to retrieve weather forecast and historical weather data directly into Excel without the need for macros or scripts. However, is it always the best way to work with …

Replacing the OpenWeatherMap API with Visual Crossing Weather

Visual Crossing is a superior replacement for the OpenWeatherMap API (also known as the OpenWeather API) in both cost and functionality. By offering up to 1000 free results a day and full access to forecast historical data, Visual Crossing Weather makes it easy for everyone to test the API, compare data, evaluate extended weather functionality, …

How to import weather data into Microsoft SQL Server

When you want to drive data analysis of all types including data science and business intelligence applications, loading weather data into a relational databased is often the first step. As one of the most popular database platforms in the world, Microsoft SQL Server is the backend datastore for millions of applications from homebrew to enterprise. …