parse XML file into excel sheet

[zcabeli]

hello,


i've got XML file which contain the following records as shown in example below.

 
<group name="ddd" >
 
     <param name="abc" def="0xc" tag="1"  encapsulated="1" 
     PATH (level1.level2.level3.abc) />
 
     <param name="def" def="0xc" tag="1"  detected="1" encapsulated="1" 
     PATH (level1.level2.level3.def) >
     short description about parameter def ... 
     </param> 
 
</group>
 

as you can observe there is an hierarchy of :group name" and "param name". i want to parse this file to an excel sheet. so each line will contain all param data (one cell for each field name and each field value). can anybody recommand me of a simple way to do it ?

thanks alot for all the help,

[jkmyoung]

Since this isn't properly formed XML, I suggest using a scripting language to get the values, using regular expressions. Create a CSV file with the script.