XML files import

Topic

New Reply

Hi,

I have thousands xml files in different folders. I would like to import those xml files with the folder name to a excel worksheet. For instance, I have a folder call: Test1, inside of Test1 folder, I have two xml files with column: Name, Number.

So I would like the excel worksheet display as the following after the importing:

Name Number Folder Name
Tom 123 Test1
Anna 456 Test2

Thanks in advance.

Reply | Quote

Replies

Unless the folder name is in the XML file you will have to add that manually, then sort as required.
The XML import requires a template / library. I found this nice library in about 2 seconds.

cheers, Paul

Reply | Quote