Convert XML to Excel
Posted: Tue Dec 22, 2015 5:42 pm
Hello,
I have a XML file with a lot of nested tags like
<levelone>
<content>abc</content)
<contentb>def</contentb>
.
.
.
</levelone>
And I want to convert each tag into a separate column with the corresponding value in Excel.
Has anyone a hint where to start here?
I tried opening it in Excel but it only displays the structure like in any text editor.
Cheers,
Ben
I have a XML file with a lot of nested tags like
<levelone>
<content>abc</content)
<contentb>def</contentb>
.
.
.
</levelone>
And I want to convert each tag into a separate column with the corresponding value in Excel.
Has anyone a hint where to start here?
I tried opening it in Excel but it only displays the structure like in any text editor.
Cheers,
Ben