Import XML Files Into Excel

In this video we are going to look at how to import XML data into Excel using power query (get and transform).
Check out the full written tutorial here:
www.howtoexcel.org/power-quer... 👇
Check out my full courses and ebooks here
👉 www.howtoexcel.org/courses/
DOWNLOAD the example workbook here
📖 www.howtoexcel.org/downloads/
SUBSCRIBE & get my 3 FREE eBooks
📧 www.howtoexcel.org/newsletter/
CONNECT with me on social
Facebook: / howtoexcelblog
Twitter: / howtoexcelblog
LinkedIn: / john-macdougall
Thanks for all your support!

[@HowToExcelBlog]

Check out my full courses and ebooks here 👉 www.howtoexcel.org/courses/

[@phelipe_matos]

I don't know who you are, but I NEED to thank you SO MUCH for upload this video. You saved my life!

[@alkobond]

This is great, I'm pretty good with computers and excel, but the tricky little tick box had me stumped for much longer than i'd care to admit. You're a legend, thank you!

[@HowToExcelBlog]

Glad it helped George!

[@gregfeneis609]

Thanks! This was particularly helpful for weeding a single value out of multiple test records and presenting in tabular format.

[@txreal2]

always wondered how to better handle all that text in an xml file. thanks for the lesson!

[@markthomas9641]

Great explanation, thank you. DeltaXML have some really useful XML compare and merge tools with API for building into applications.

[@kharchenko28]

Thank you. I have found exactly what I was looking for.

[@gladwynvandermerwe3522]

Thank you! This video really saved me a lot of time...

[@Nijanthan30]

Wow.. This video is useful and it served me as a good reference for my project.

[@wisdompassenger]

Thank you man !

[@ILcimant]

great stuff!!!!

[@oatferrari7057]

Thank you!

[@leotestoy486]

thanks! awesome

[@DHARMYOGCOM]

great thank you

[@txreal2]

Been getting good stuff from you as a follower. I happen to have multiple xml files in a folder. After filter for only xml, I still have 4 nested tables in each xml. I transformed a sample file like you suggested. But how do I do this transformation for all xml files in the folder? (Basically, I'm having trouble extracting & joining/appending different nested tables on multiple files) Thanks.

[@ramehharmouch5300]

Hello, I want to ask you, if i have an excel file mapped to an xml map. When i save the file as xml, the empty cells of the excel are not created in the xml file. So, how can i edit the xml to create empty xml tags for the empty elements in the excel file? Thank you in advenced.

[@ftapiavalentin]

Thank you

[@HowToExcelBlog]

No problem Felix!

[@saidulpathan4253]

@@HowToExcelBlog open xx on

[@HowToExcelBlog]

❓

[@mehrabanbarimani]

Thanks for the great video, but where can I download that .xml file to practice ?

[@a7solar]

I wonder if you can explain how to do in a Mac Computer. I would really appreciated it. I have been looking for days.

[@HowToExcelBlog]

Sorry, Excel for Mac doesn't support power query.

[@DonaldsonClan]

How do you create a proper XML Schema file. I'm having issues. I have a valid XML file, I open it, Excel creates the XML Mapping/Schema but when I try to save imported spreadsheet data it fails. "Cannot save or export XML data. The XML maps in this workbook are not exportable."

[@SocialMediaJunk]

Watch in 1.5 speed. You are welcome

[@HowToExcelBlog]

Definitely more efficient 😜

[@sathyanarayanansatagopan9069]

Sir, if I modify some data in the spreadsheet and convert into xml, shall it work?

[@HowToExcelBlog]

You can convert any proper XML into a table with power query.

[@rahulkalingeri1206]

Can we add this process of importing xml data into excel in Vba Macro!?

[@HowToExcelBlog]

Not sure. I avoid VBA.

[@dnbat7889]

I love u

[@HowToExcelBlog]

We have a lot in common, because I love me too! 😂

[@deepsudeep]

I need to do the opposite, help!!!

[@psnirupama]

how do I change the date format if the date shows all numbers after I import xml into excel

[@HowToExcelBlog]

Depends what those numbers look like.

[@da_yyaam]

I have a exported xml file from sql database which has 1.1 Million rows. Is it possible to work on it with power query?

[@HowToExcelBlog]

Connect power query directly to the SQL database! Then load it to the data model and you can work with the 1.1 M rows in a pivot table.

[@da_yyaam]

@@HowToExcelBlog thanks. Let me try that

[@misaelflores8148]

How do I import an XML file that has more than a million lines of information?

[@HowToExcelBlog]

You can add it to the data model and use a pivot table to analyze it.

[@mishrag3484]

Can we send sms from Excel if yes Pease tell us process.

[@HowToExcelBlog]

Yep, I wrote a blog post about it. www.howtoexcel.org/microsoft-flow/sending-sms-text-messages/

[@sawseries2939]

น่ารัก

[@Trackhoe075]

😂