Multi-Site Weather Forecast in Excel

Описание: Are you interested in providing a weather forecast for any number of locations directly into Excel? This video demonstrates the downloadable Multi-Site Forecast Workbook for Excel. Using the Power Query and Pivot Table functionality native to Excel, the workbook is automatically set up to pull weather forecast data directly into your workbook from the Visual Crossing Weather Data Service. Just download and starting retrieving forecasts today!

Only the Visual Crossing Data Service API is ideal for pulling weather data into Excel by focusing on the following features not available by other data providers:

1) CSV Stream direct to Excel - While most services only allow JSON streams, Visual Crossing provides a CSV data stream so you can load data directly into Excel, Google Sheets, PowerBI or Relational Databases.

2) Multiple Locations in a single query - Typical weather services force you to query one location at a time. Visual Crossing allows you to send in multiple locations. In Excel, you can select a range of locations and submit them in one call. No more joining of data from multiple calls.

3) Run-time Geocoding - To send your locations to weather services you must have latitude/longitude data. The process of turning strings like "400 Main St. New York, NY" into coordinates is called geocoding. Most weather services that have geocoders, require that you call first to the geocoder and then make a separate weather call. Visual Crossing makes this simple allows you to send your address strings, cities, postal codes, etc... directly into your weather call. This is ideal for Excel users that have string data in their workbooks.

Visit our Blog on Multi-Site Forecast Workbook and get your copy today:

https://www.visualcrossing.com/blog/m...

Sign up for your account today at: (Free accounts and Trials available!)

https://www.visualcrossing.com/weathe...

If you have any questions contact us at:

[email protected] (general questions)
[email protected] (technical help)