How do I add weather data into Microsoft Word?
In this article we will describe various techniques to include both historical weather data and weather forecast data into a Microsoft Word document.
How do I add weather data into Microsoft PowerPoint?
We are going to walk you through building a PowerPoint that has a graph of your current forecast. We will utilize the ability to pull Visual Crossing Weather Data directly into your PowerPoints and have them update the forecast everytime you open it. Weather data provider We are going to use a number of techniques …
Continue reading “How do I add weather data into Microsoft PowerPoint?”
Multi-site Forecast Workbook for Excel
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 …
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 …