How to convert large xml file into csv using Python

Question

I want to convert a very large XML file into CSV format without hardcoding tagnames.

Can anyone help me out?

Without any additional information about the structure of your XML files there is no reasonable answer to your question. — Johann Hagerer
– Johann Hagerer, Commented Feb 10, 2016 at 8:23

Glorfindel · Accepted Answer · 2021-09-11 05:45:58Z

2

Firstly, you need to parse your XML files. This can be done via ElementTree API:

Example code:

import xml.etree.ElementTree as ET
root = ET.parse('your_data.xml').getroot()
with open("output.csv", "w") as file:
    for child in root:
        print(child.tag, child.attrib)
        # naive example how you could save to csv line wise
        file.write(child.tag+";"+child.attrib)

There are also solutions to parse your XMLs directly as dictionary.

Then csv.DictWriter can be used to save the dictionary as CSV.

edited Sep 11, 2021 at 5:45

Glorfindel

22.8k13 gold badges97 silver badges124 bronze badges

answered Feb 10, 2016 at 8:37

Johann Hagerer

1,0872 gold badges10 silver badges28 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Vladimir Vargas Over a year ago

root = ET.parse('your_data.xml').getroot() this fails for very large XML files, as they cannot be loaded into memory

Collectives™ on Stack Overflow

How to convert large xml file into csv using Python

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related