Retrieve Real-time Weather Data from Weather.gov in Excel using FILTERXML




About this tutorial:

Video duration: 6:26
Subscribe for more at georgejmount.com

*Requires Excel 2013 or greater*

You can import .XML data straight from the web into Excel with the WEBSERVICE( ) and FILTERXML( ) functions.

In this video we will get real-time updates from Weather.gov. Data source:

We will then build a dynamic input source to display current weather conditions for locations across Ohio (the heart of Excel!).

Post Author: OfficeTutes.com

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads

Leave a Reply

Your email address will not be published. Required fields are marked *