• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Loading XML into Excel


New Member
Hi Chandoo.

I have been working in Healthcare since last 10 years and now since last 2 years there has been change in my profile and i have been assigned lots of analytical tasks.

I have around 6500 xml files where i need to load these xml files into excel and analyse the data. but when i load this is excel i am sure that there is some lost of data and i am not getting a correct value what i m looking for or what i have in hand.

i have tried doing this through Power query, but i do not get the desired result. All the 6500 xml files get load into it but it just gives me the names of the xml file in the first column and other data in the rest of the columns and file location in last.

please help me to get this task done Chandoo.