How to import multiple xml file into excel

Anonymous
2012-09-13T00:07:12+00:00

I have a lot of xml files which need to be imported into single excel file. I can able to import one by one but cannot select all at a time to import.

Is it possible to do through batch process or any other process?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

66 additional answers

Sort by: Newest
Most helpful Newest Oldest
  1. Anonymous
    2014-06-05T00:06:57+00:00

    This article relates to Excel 2007, not 2013+, and therefore seems to be missing relevant information.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2014-06-04T10:36:02+00:00

    Thanks for the code. It worked for me

    Was this answer helpful?

    0 comments
  3. Anonymous
    2014-06-01T19:17:12+00:00

    HI there.

    When I use the original code posted all XML files import fine, but when I use any of the updated codes to remove headers (and sorting issues) I get the"No XML" error and only one XML file imports. why might this be?

    thank you

    Was this answer helpful?

    0 comments
  4. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    Comments have been turned off. Learn more