Convert XML to Excel

Questions about XML that are not covered by the other forums should go here.
bene1979
Posts: 2

Convert XML to Excel

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
Costin
Posts: 345

Re: Convert XML to Excel

Tue Dec 22, 2015 6:48 pm

Hello,

If you need to export XML files into Excel documents, there is no predefined support to do this in oXygen.
Though, it might be worth trying to just copy/paste contents from the XML document, while you are working with it in the Grid tabular editing mode in oXygen, directly into a document you have opened in Excel. This is the best approach for what you might need to achieve.

However, you could even try to open the XML document file as it is with MS Excel, as it is my understanding that MS Excel should be able to open XML files directly.

Regards,
Costin
Costin Sandoi
oXygen XML Editor and Author Support
bene1979
Posts: 2

Re: Convert XML to Excel

Wed Dec 23, 2015 8:10 pm

Great, that's what I needed.
Thank you!

Return to “General XML Questions”

Who is online

Users browsing this forum: No registered users and 1 guest