Convert XML to Excel

[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

[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

[bene1979]

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