Import Multiple XML Files into Excel

[Mungkol]

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
row.

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

Any hints?

Thanks in advance.

Mungkol

 

[Ron de Bruin]

Hi Mungkol

You can try the code here and change the extension in the code to xml
http://www.rondebruin.nl/fso.htm

 

[Mungkol]

Thanks, I'll give it a try

Regards,

--Mungkol

 

[Lena]

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.