Как сконвертировать xml в csv?

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21

import csv
import xml.etree.ElementTree as ET

def xml_to_csv(xml_file, csv_file):
    tree = ET.parse(xml_file)
    root = tree.getroot()
    
    with open(csv_file, 'w', newline='') as csvfile:
        writer = csv.writer(csvfile)
        writer.writerow(['Column1', 'Column2', 'Column3'])  # Имена столбцов
        
        for element in root.findall('Element'):
            column1 = element.find('Column1').text
            column2 = element.find('Column2').text
            column3 = element.find('Column3').text
            writer.writerow([column1, column2, column3])

# Пример использования
xml_file = 'input.xml'
csv_file = 'output.csv'
xml_to_csv(xml_file, csv_file)

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13

<RootElement>
    <Element>
        <Column1>Value1</Column1>
        <Column2>Value2</Column2>
        <Column3>Value3</Column3>
    </Element>
    <Element>
        <Column1>Value4</Column1>
        <Column2>Value5</Column2>
        <Column3>Value6</Column3>
    </Element>
    ...
</RootElement>