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: app.box.com/s/d05zz2rg8y7ufm8...
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 theexceltrainer.co.uk
🙋♂️ Let's connect on social
Twitter: / theexceltrainer
Facebook: / theexceltrainer
LinkedIn: / thomasmik
#excel #powerquery #xml #podcastfeed
Негізгі бет Excel for Mac: Import an XML File Using a Real World Example - Analyzing Podcast Stats
Пікірлер: 6