Retrieve Real-time Weather Data from in Excel using FILTERXML

About this tutorial:

Video duration: 6:26
Subscribe for more at

*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 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:

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 *