Import Multiple XML Files into Excel



Dear all,

I would like to find some statistic of data from multiple XML files
using Excel 2007. I want to import all the files in a folder and sub-
folder into one EXCEL spreadsheet. Each XML file has the identical
structure, but different data. I want to define the XML map in Excel,
and import data for each file, with each file's data being on a new

By the way, it seems that excel does not allow to import many files at
once. :(

Any hints?

Thanks in advance.



Actually you can import multiple xml files into Excel (at least I could in
2003). If the files have identical structure create a map from any of them.
Then just import the files you want through Data - XML - Import. The files
should be located in one folder just select as many as you like.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question