How to convert multiple xml files to one csv file

Question

There are 33 xml files with varying schema that have to combined and converted to one csv file is this possible with EXCEL?

Answer 1

There are 33 xml files with varying schema that have to combined and converted to one csv file

If the 33 XML have varying schema, then how should the reuslt look like?

Have the XML data hierachies with 1:n relation? How should that be presented in a CSV?

Answer 2

Hi @CJoeS

From an Excel perspective, if these xml files can be converted into the same data structure, they can be merged using Power Query.

Besides, there are several types of XML schema element constructs Excel doesn't support, such as "<any>", "Recursive structures".

Reference:

Import XML data

Map XML elements to cells in an XML Map

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment". Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

---