Share via

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

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Olaf Helper 47,441 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,065 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

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.