Web Query Connection
Bring weather data into Microsoft Excel using the 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 in their own locations, dates and more without modifying the query string.
Import from file
The most common method for getting data into Excel is by opening a saved data files. Visual Crossing’s Data Services allows users to build the weather query they want and with a click of a button they can download their weather data file directly to their desktop.
Our CSV file format is 100% compatible with Excel’s File Import functionality. Users can easily take weather data with them, share with colleagues or create a shareable data store.
Add-in for Microsoft Excel
Visual Crossing is the only weather data provider to offer an Excel Add-in for Weather Data. After installation in Excel, the plugin offers your users a one-stop weather data capability. From inside of your Workbook you can login to the Visual Crossing Weather Service, build a weather query and retrieve the data directly into the cell range of your choosing.
One additional advantage is that the plugin also serves as a powerful join engine. Instead of loading weather data into a separate cell range, the user can select of range of locations from an existing table and join columns of weather data directly into the existing table. The result is a single, actionable data set ready for analysis.
Weather for Power BI
Users of 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.
The Visual Crossing Historical Summary reports also utilize an internal aggregation engine that can save you even more time by slicing and aggregating weather data to allow users to see summary reports such as average rainfall by year. Visual Crossing was designed for power business users and is the perfect complement to a Power BI user's toolkit.
Weather History from Thousands of global weather stations
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.
15-day Weather forecast
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.
Find trends and patterns
Correlate weather data directly with your existing Excel data. Easily find the relationship between your existing worksheet data and dozens of weather metrics such as temperature, rainfall, wind, snow and more.
Automatic data refresh
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.
High-Performance Weather Join Engine
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.
Hourly data for optimal business correlations
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