How to automatically refresh Weather Data in Microsoft Excel
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”
How to add Weather Data to Google Sheets using a Dynamic Weather Query
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”
Weather Workbook for Excel – Customization
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”
Getting Started with Weather Add-in for Microsoft Excel
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”
Weather API Documentation
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 …
How do I retrieve weather data using an ODATA request?
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?”
Weather API JSON result structure
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 …
How do I get started with the Weather API?
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?”
Available Data for Visual Crossing Weather – Updated December 2020
Overview The Visual Crossing Weather platform is able to join and analyze both historical weather and weather forecast data from many sources. The product includes both historical and forecast weather data loaded periodically from various data providers. This document describes the data that is currently available. (Please note that additional data options are available for …
Continue reading “Available Data for Visual Crossing Weather – Updated December 2020”
Getting Started With Weather Data Services
Weather Data Services provides an easy way to access weather forecast data, historical weather observation data and historical summary data. The data is accessible in three ways – directly in the browser, as a data download or as a Restful API link. We will show you how to build the query in your browser and how …
Continue reading “Getting Started With Weather Data Services”