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 …

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

Plan for the weather on your next camping or RV trip

If you are a keen campers or RV-ers like our family, you are looking forward to a summer of exploration. Exploring beaches, cities and mountains around the country is what makes camping and RV-ing such as wonderful experience. However camping is inherently weather-based. Extremely hot or cold weather or strong storms, hurricanes (and blizzards if …

Understanding the “fair use” system in Visual Crossing Weather

Visual Crossing Weather is the most powerful and cost effective way to obtain weather data for your data analysis project, weather app, or virtually any other weather use case. We pride ourselves in providing the highest-quality weather data at the most affordable prices. In order to protect our user community from runaway scripts, malicious abusers, …