How to convert multiple xml files to one csv file

CJoeS 20 Reputation points
2025-02-25T13:45:05.0233333+00:00

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

Microsoft 365 and Office Excel For business Windows
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Olaf Helper 47,436 Reputation points
    2025-02-25T14:04:17.7166667+00:00

    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?


  2. Jiajing Hua 18,060 Reputation points Moderator
    2025-02-26T09:40:01.8333333+00:00

    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.


    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.