Python将xml文件转换为csv

import csv
import xml.etree.ElementTree as ET

def xml_to_csv(xml_file, csv_file):
    tree = ET.parse(xml_file)
    root = tree.getroot()

    # 创建CSV文件并写入表头
    with open(csv_file, 'w', newline='') as file:
        writer = csv.writer(file)
        writer.writerow(['Field1', 'Field2', 'Field3'])  # 表头字段名

        # 遍历XML树并写入数据行
        for item in root.findall('item'):
            field1 = item.find('Field1').text
            field2 = item.find('Field2').text
            field3 = item.find('Field3').text
            writer.writerow([field1, field2, field3])  # 数据行

# 使用示例
xml_to_csv('input.xml', 'output.csv')

<root>
    <item>
        <Field1>Value1</Field1>
        <Field2>Value2</Field2>
        <Field3>Value3</Field3>
    </item>
    <item>
        ...
    </item>
    ...
</root>