Importing large amounts of flat XML files to excel

Question

Hi, I have a bunch of XML files that have a flat hierarchy, but each contain a differing amount of (uniquely named) nodes. Example:

<?xml version="1.0" encoding="UTF-8"?>   
<SomeName>   
  <Node1> 
    DataA 
 </Node1>   
 <Node2> 
    DataB 
 </Node2>   
  <Node3> 
    DataC 
 </Node3>   
  <AnotherNode1> 
    DataD 
 </AnotherNode1> 
  <AnotherNode2> 
    DataE 
 </AnotherNode2> 
  <AnotherNode3> 
    DataF 
 </AnotherNode3> 
 <SingleNode> 
    DataG 
 </SingleNode> 
</SomeName>   

I need to import all these files into an excel table with each column bein associated to a specific node.

Example:

Node1      Node2     Node3     AnotherNode1    AnotherNode2     Anothernode3     SingleNode

DataA      DataB     DataC        DataD           DataE            DataF            DataG

Is there some way to batch import these files or convert them first? Thanks!

Answer 1

www.smooks.org will turn almost anything into almost anything else. You could even use XSLT to create a CSV file. how-do-i-write-an-xslt-to-transform-xml-to-csv

Answer 2

Why not use ActiveWorkbook.XmlImport in VBA?