Weather Data for Microsoft Excel

Weather history data & weather forecast data

Web Query Connection

Real-time weather data feed

Import from file

Import weather data directly into your workbook

Power BI

Import weather data directly into Power BI

Web Query Connection

Bring weather data into Microsoft Excel using Web Query Connections. With just a few clicks, users can paste in a URL query string and pull Historical Weather, 15-day Weather Forecast or Historical Climate Data into any workbook or worksheet.

The Visual Crossing Web Query Feed is fully integrated with the Excel Web Query functionality and provides a Weather Query URL Builder that allows users to construct weather queries from an easy-to-use interface. Power Query users can take advantage of the parameterized query support allowing workbook users to easily enter their own locations, dates and more without modifying the query string.

Import from file

A common method for loading data into Excel is by opening saved data files. Visual Crossing’s Weather Data Query Builder allows you to build your weather query dynamically with an interactive web-based interface. You can preview the data and then download it directly to your local machine in industry standard CSV or XLSX formats.

Use our XLSX downloads directly in Excel for analysis and sharing with your team. Combine weather data with your existing business data or planning processes to help your business make better decisions using weather insights.

Weather for Power BI

Users of Microsoft Power BI can utilize the same query as Microsoft Excel capability to pull weather data directly into a more powerful tool for deeper analysis. All Visual Crossing data is delivered in a report and dashboard-ready format. Columns and Rows are organized properly and ready for aggregation or slicing. This eliminates an expensive ETL step for ad hoc analysts that want to get data quickly and find the answers they need.

Key benefits

Our worldwide historical weather database contains millions of hourly weather reports from a network of thousands of reporting stations. Visual Crossing Weather harmonizes data from multiple near-by stations to find the most accurate reports for every location.

The longest available weather forecast, 15-days, is available to users at all service levels. This allows you to see beyond the typical 5 or 7-day forecast and plan your activities and business up to two weeks in advance. Intelligently plan for upcoming weather changes and mitigate the risk of severe weather events.

The longest available weather forecast, 15-days, is available to users at all service levels. This allows you to see beyond the typical 5 or 7-day forecast and plan your activities and business up to two weeks in advance. Intelligently plan for upcoming weather changes and mitigate the risk of severe weather events.

Configure your Excel sheets to automatically reload live weather data every time they are loaded or on a timer to ensure that you are always looking at the latest and most accurate results.

Join years of Excel data to decades of historical weather conditions to find hour-by-hour patterns and correlations that are directly actionable for your planning. The Visual Crossing Weather join engine serves up the data that you need in seconds.

Since weather varies throughout the day, businesses that are not open for customers 24-hours per day should not settle for daily weather summaries. Our data goes down to the hourly level allowing you to correlate weather data to the specific hours that your business is active.

How to start using weather data in Microsoft Excel

Comprehensive documentation, samples, FAQs, forums & support offerings

Quick Start

How to Load Weather Data into Microsoft Excel

Forum & Support

Ask questions in our forum or log a ticket for rapid answers.

Scroll to Top
This site is registered on wpml.org as a development site. Switch to a production site key to remove this banner.