Articles for "weather history"

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

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 can I load weather forecast data into Google Sheets?

This article shows how to easily load weather forecast data into Google sheets.  It will walk through the process step-by-step showing 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 the companion article that discusses importing historical weather data …

How do I find my nearest weather station?

Visit https://www.visualcrossing.com/weather-history Enter your location and any date range Scroll down to the “Location and station map” section to find your nearest station Background Most weather data today is collected and stored by weather stations all over the globe. Weather stations are all around us; often residing at local airports or municipal locations. When you are looking for weather …