As a podcast host I recently needed to extract some information from the podcast’s feed file (an XML file) and display it in a table in Excel. I was able to do this fairly easily using Power Query. Even if you’re not a podcaster, what this video is really about is how to import data from an XML file into Excel and clean that data to make it useable. The process that I demo works on Excel for Windows and Excel for Mac.

Notes and Resources
Download a copy of the file used in this video: https://app.box.com/s/d05zz2rg8y7ufm8001c30s893wc7l73r

The formulas that I used in the demos:
=Duration.From([Duration]/86400))

Want more FREE training?
Why not check out my other tutorials and/or subscribe to my newsletter, both of which can be done at https://theexceltrainer.co.uk

‍️ Let’s connect on social
Twitter: https://twitter.com/theexceltrainer
Facebook: https://www.facebook.com/theexceltrainer
LinkedIn: https://www.linkedin.com/in/thomasmik

#excel #powerquery #xml #podcastfeed

Please take the opportunity to connect and share this video with your friends and family if you find it useful.