Automate recent weather history data retrieval using Microsoft Power Query
In our previous articles about integrating Weather History data into Power BI and Microsoft Excel, we have used the Visual Crossing Weather API to retrieve historical weather data. In this article we discuss how to make those weather data queries automatically read the latest weather conditions using Microsoft Power Query. If you would like to …
Continue reading “Automate recent weather history data retrieval using Microsoft Power Query”
Get Free Weather Data with our Weather Data Ambassadors Program
The Visual Crossing Ambassadors program is designed to get weather data and weather APIs into the hands of people who may not be able to pay but are willing to help spread the word about Visual Crossing Weather. If this sounds like a good arrangement to you, please read on and sign up below.
Weather Alerts for Excel
Filter and Alert on Large Volumes of Weather Forecast Data. The Weather Alert Workbook is designed for the end-user who wants to query a large number of site forecasts and be alerted to exceptional weather conditions at those locations. It is a free Excel Workbook for all of our users to download and use and/or …
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.
Announcing our free Weather API Plan
We are excited to announce the introduction of a free plan for our Weather API. We are the only weather API provider to offers both 15-day weather forecast and historical weather data in our free tier. Key Weather API Features The free tier of the Weather API includes the core features of all our plans. These …
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?”
Announcing Expanded Historical Weather Data
We are excited to announce the expansion of our historical weather data database to include 7500 additional weather stations around the world. These additional weather stations will further expand our weather history data to provide more localized historical weather observations that are updated even more frequently. Expanded Historical Weather Data for Germany The new weather …
Continue reading “Announcing Expanded Historical Weather Data”
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 …
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”