Articles, videos, and documentation to help you get the most from Visual Crossing Weather
Documentation for Weather Data, the Weather API and its uses in code, programming, data science and other applications.
The Visual Crossing Weather Data Service enables users anywhere to load weather data into Excel, Google Sheets, Relational Databases, Business Intelligence Tools and more. We recently released a downloadable Weather Workbook that allows users to query weather data directly into Excel. In this blog we will show you the Multi-Site Forecast Workbook which is a …
In this article we will use Web Queries in Microsoft Excel to retrieve Weather Data such as a weather forecast, historical weather observations or historical weather and climate statistics. We will then set the queries up to refresh automatically. This powerful refresh technical can be used to ensure that the latest weather forecast is populated into …
Continue reading “How to automatically refresh Weather Data in Microsoft Excel”
The value of weather data comes from what you do with it. In order to get value from our weather data typically users will import it into other business systems or spreadsheet systems such as Excel or Google Sheets. In this document we will demonstrate how to get a Visual Crossing Weather query directly into …
Continue reading “How to add Weather Data to Google Sheets using a Dynamic Weather Query”
Learn how the Weather Workbook is constructed and how you can modify it to make your own custom interface. Background Many of you may already be familiar with the Visual Crossing Weather Workbook for Excel. If you are note and want to learn more we encourage you to first download the workbook and pull data …
Continue reading “Weather Workbook for Excel – Customization”
This tutorial will guide you through the process of joining an existing Excel sheet to both historical and forecast weather data using Visual Crossing Weather Add-in for Microsoft Excel. For sample data we will use a sheet containing several store locations on the US East Coast. First-time users are encouraged to walk through the …
Continue reading “Getting Started with Weather Add-in for Microsoft Excel”
The Visual Crossing Weather API provides a simple way to import weather data and climate information into applications and back end systems. In addition, the web services allow developers to easily integrate weather data into web sites and other development projects. This document explains the usage of the available web services including the input parameters …
This article describes how to retrieve weather data such as weather forecast, historical weather observations and historical climate summaries using an ODATA bahttps://www.visualcrossing.com/resources/documentation/weather-api/building-and-running-your-first-weather-api-query/sed request. What is ODATA and when should I use it? According to odata.org: OData (Open Data Protocol) is an ISO/IEC approved, OASIS standard that defines a set of best practices for building and consuming RESTful APIs. …
Continue reading “How do I retrieve weather data using an ODATA request?”
This document applies to the /forecast and /history endpoints. If you are using the Timeline Weather API (/timeline), you can find the JSON structure documented on the Time Weather API documentation page. This article describes the JSON structure returned from the weather API. This same basic structure is returned for both weather forecast, weather history …
This article describes the fastest way to get started with the Visual Crossing Weather API by constructing API queries using the Weather Data Services page. Steps Navigate to Visual Crossing Weather Data Services Log in to your account (create a free trial account if necessary) Add one or more locations Construct a weather forecast or weather …
Continue reading “How do I get started with the Weather API?”
There are two types of Location sources that can be provided to the Weather Excel Add-in: Latitude/Longitude and Address. This article describes how to use both forms. Latitude/Longitude Location Source Latitude and longitude are used to locate points on the globe as a pair of coordinates represented by numbers. Latitude represents how far north/south the …
Continue reading “Setting the Location Source for the Visual Crossing Weather Add-in”