Importing an XML file into excel
Posted
by
Sudhee
on Super User
See other posts from Super User
or by Sudhee
Published on 2014-05-27T09:08:26Z
Indexed on
2014/05/27
9:32 UTC
Read the original article
Hit count: 306
I have a multilevel XML file. When I import the XML into excel, it creates multiple columns for the multilevel data. However, I need the multilevel data as additional rows.
Is there any way I can achieve this ? Thanks a lot for your help.
My XML File:
<L1>
<L1dataId>07320</L1dataId>
<DateDetail>13-Oct-2013</DateDetail>
<TypeDetail>
<TypeId>1</TypeId>
<Rate1>
<Current>
<onsite>100</onsite>
<net>100</net>
<gross>100</gross>
</Current>
<Past>
<onsite>100</onsite>
<net>100</net>
<gross>100</gross>
</Past>
</Rate1>
<Rate2>
<Current>
<onsite>2100</onsite>
<net>2100</net>
<gross>2100</gross>
</Current>
<Past>
<onsite>2100</onsite>
<net>2200</net>
<gross>1200</gross>
</Past>
</Rate2>
<Rate3>
<Current>
<onsite>300</onsite>
<net>300</net>
<gross>300</gross>
</Current>
<Past>
<onsite>400</onsite>
<net>400</net>
<gross>400</gross>
</Past>
</Rate3>
</TypeDetail>
<TypeDetail>
<TypeId>2</TypeId>
<Rate1>
<Current>
<onsite>100</onsite>
<net>100</net>
<gross>100</gross>
</Current>
<Past>
<onsite>100</onsite>
<net>100</net>
<gross>100</gross>
</Past>
</Rate1>
<Rate2>
<Current>
<onsite>2100</onsite>
<net>2100</net>
<gross>2100</gross>
</Current>
<Past>
<onsite>2100</onsite>
<net>2200</net>
<gross>1200</gross>
</Past>
</Rate2>
<Rate3>
<Current>
<onsite>300</onsite>
<net>300</net>
<gross>300</gross>
</Current>
<Past>
<onsite>400</onsite>
<net>400</net>
<gross>400</gross>
</Past>
</Rate3>
</TypeDetail>
</L1>
How Excel converts it and how I need it:
© Super User or respective owner
