Page 1 of 1

Convert XML to Excel

Posted: Tue Dec 22, 2015 5:42 pm
by bene1979
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

Re: Convert XML to Excel

Posted: Tue Dec 22, 2015 6:48 pm
by Costin
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

Re: Convert XML to Excel

Posted: Wed Dec 23, 2015 8:10 pm
by bene1979
Great, that's what I needed.
Thank you!