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

Download the exercise file here. Requires Excel 2013 or greater. These are new functions in Excel. You can import .XML data straight from the web into Excel with the WEBSERVICE( ) and FILTERXML( ) functions. In this lesson we will get real-time updates from Weather.gov. Data source: http://w1.weather.gov/xml/current_obs/ View the YouTube tutorial here. Be sure […]