How to download weather forecast data as a Microsoft Excel Workbook

In this article, I’m going to show how to download weather forecast data as a standard Microsoft Excel file.

The estimated time to complete this exercise is less than 5 minutes.

Step 1 – Open the Weather Data Query Page

We’ll start by going to the Weather Data Services page.  Then we need to click on the link to go to weather data download page near the top of the page. If you would like to read more the weather datasets that we offer, head over to our weather data page.

Step 2 – create a free weather data account and sign in

Once on the query page, you can sign into your Visual Crossing Weather account.  If you don’t already have an account, you can click on the top of the page to create a free account.  Signing up for a free account will give you immediate access to a full 15-day weather forecast for any location around the globe.

For more information on signing up, please see our detailed article.

If you intend to complete these tutorial and download the data you will need an account. If you would like to view a preview of the data in a browser, an account is not necessary.

Step 3 – enter a location address for weather data

For this example, we’ll select the option to manually enter a location address to use for the weather forecast. 

For the address,  we enter an address, a city name, or a postal code (or a latitude and longitude).  If you enter a city name, also include the state and country if possible as there are many locations with the same town or city name!

Optionally, we can also give the location a friendly name for our own reference in the output data.  This feature can be useful when you are comparing multiple locations in the same dataset. Entering the location name is available once you have previewed your first dataset.

Step 4 – choose the weather data time range

As soon as we enter the location information, the 15-day weather forecast is retrieved However, in this panel there are other options as well including weather history queries, and hourly data.  These are among the many options covered by our other tutorials and videos.  Please take a look at those or reach out to us if you need more information on these options.

Weather forecast or historical weather data is available

Step 5 – viewing the weather data in the browser

The grid displays the full weather data in the browser. Data available includes the temperature, feels like (heat index and wind chill), precipitation, wind and many more weather elements. If you want to reduce the amount of columns, you can use the ‘Weather elements’ link in the toolbar.

Step 6 – View the full weather forecast data view

In addition to the daily data, additional data views are available. These include grids showing the hourly data. For weather forecast queries, additional tables may be populated including any active weather alerts for the selected location.

There is also a chart view which summarizes some of the weather elements at the daily or hourly view. This provides a quick way to view the data,

Charts of common weather elements

You can see the various weather metrics that are provided in the output data.  These metrics include common values such as temperature, precipitation, and wind as well as less common value such as heat index, cloud cover, and wind gusts.  For more information on the details and how to use all of our weather metrics, please see our weather data documentation.

The ‘Stations’ view provides a map of the selected location and any weather station data that was used to create the weather report. Weather station data is used for historical data and weather forecast data will use our model based forecast.

We can now download the data as a Microsoft Excel workbook by pressing the “Download” button.  If you only need data for a single location, you can skip the next step and start with step 8.  However, often you need forecast data for more than one location.  So, we can continue with an additional step to show that working with multiple locations is as easy as working with one.

Step 7 – add a second location (optional)

To add a second location, we need to click on the Locations dropdown at the top of the window and then click on ‘Multiple locations’ top create a list of locations.

The multiple location link brings up the location list editor.  We can add any location that interests us, including international locations such as Paris France.

Simply add each location you need. Once you have finished, you can click ‘Close’

In the query page, we can now switch between out locations using the locations drop down:

As soon as we click on Paris, France, the query is updated and each view now shows the 15-day forecast for Paris. Here’s the location map updated:

Step 8 – Download the weather data as a Microsoft Excel Workbook

To download the weather data into Microsoft Excel, we can use the download button:

This button brings up the Download data popup which presents a series of options to export the data to various formats such as CSV (comma separated values), Excel and JSON.

In this case we are going to select Excel:

We then choose which table of data we would like to export to Excel. These options mirror the options that we saw on the grid view of the query view:

In this case, we are going to use the daily data. If we want, we can rename the download dataset definition. This is useful if you plan to return and run the same dataset again.

Pressing ‘Submit’ will submit the download. We will then create the Excel datasets and offer them for download.

You can also use the ‘My datasets’ link in the top right of the page to return and retrieve the data at a later date.

When you click download, the Excel data will be retrieved to your local computer. If you have submitted multiple locations, you will download a Zip file containing the individual Excel files.

Finding out more about Visual Crossing Weather data

If you would like to learn more about using Visual Crossing Weather options such as history data, multiple location import, and use within other analysis tools please see our other tutorials.

We also offer a Weather API that can be used to retrieve data into Excel using the PowerQuery scripting language.

Questions or need help?

If you have a question or need help, please post on our actively monitored forum for the fastest replies. You can also contact us via our support site or drop us an email at support@visualcrossing.com.