Articles, videos, and documentation to help you get the most from Visual Crossing Weather
Easily import weather data into Microsoft Excel and Google Sheets with our rich tools and tutorials.
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”
Degree Days are a way to help determine how much warmth or cold there has been, typically over a season such as winter, summer or a plant’s growing season. Degree Days are used to determine a building’s typical heating or cooling requirements over a season. They are used in agriculture, farming and gardening to plan …
Continue reading “Degree Day Calculator for Microsoft Excel”
PART 3 – CREATE A GROWING DEGREE DAYS CALCULATOR USING HISTORICAL AND FORECAST WEATHER DATA Download the free Degree Day Excel workbook (no add-in required) Learn more In our previous gardening weather blog, we have learned how to use Microsoft Excel to analyze the historical and forecast weather data of a location. We can now identify the …
Continue reading “Using Microsoft Excel to Analyze Gardening Weather – Part 3, Growing Degree Days”
PART 2 – CREATING AN MICROSOFT EXCEL GARDENING WEATHER FORECAST In our previous gardening weather blog, we set up a Microsoft Excel workbook that displays a summary of the historical weather information for a location targeted towards the gardener. With the historical Excel workbook, we can understand the climate that they can expect for a particular …
Continue reading “Using Microsoft Excel to Analyze Gardening Weather and Climate – Part 2”
PART 1 – CREATING AN HISTORICAL WEATHER DASHBOARD It’s hard to think of an activity that depends on the weather and climate more than gardening. How cold does my location get? When is the last frost date? Is it too hot for this kind of plant? Do I need to water, or will it rain …
Continue reading “Using Microsoft Excel to Analyze Gardening Weather and Climate – Part 1”
Does weather affect my business? This seems like a simple question but as many of us have quickly learned, it is not a simple task. I have performance data for a set of stores and I am pretty certain that weather has been affecting my business, but I need create an analytical sheet to be …