How to Convert XML to CSV (Flatten Nested Data)

Why Flatten XML to CSV?

XML feeds from partners, marketplaces, and government portals are rarely spreadsheet-friendly. Analysts need rows and columns. Converting XML to CSV flattens repeating records so Excel, Google Sheets, and BI tools can filter, sort, and chart the data.

The Flattening Strategy

Pick one repeating element as the "row". Everything else becomes columns.

• Repeating siblings (e.g. <item> under <items>) → one CSV row each.
• Child element text → columns named after the child.
• Attributes (id, sku) → columns, often prefixed or using the attribute name.
• Parent fields shared across children → duplicated on each child row, or kept in a separate table.

order_id,customer_name,sku,qty
1001,Ada Lovelace,A1,2
1001,Ada Lovelace,B2,1

Step-by-Step: In the Browser

Best for one-off partner files and quick reviews.

• Open the XML to CSV Converter.
• Paste or upload the .xml file.
• Confirm which repeating element became rows.
• Preview columns and sample values.
• Download CSV, then open in the Online CSV Editor or Excel.

Step-by-Step: With Python

ElementTree plus csv.DictWriter is enough for many feeds.

import csv
import xml.etree.ElementTree as ET

root = ET.parse("orders.xml").getroot()
rows = []

for item in root.findall(".//item"):
    order = item.find("..")  # adjust to your structure
    rows.append({
        "sku": item.get("sku", ""),
        "qty": item.get("qty", ""),
        "name": (item.findtext("name") or "").strip(),
    })

with open("items.csv", "w", newline="", encoding="utf-8") as f:
    writer = csv.DictWriter(f, fieldnames=["sku", "qty", "name"])
    writer.writeheader()
    writer.writerows(rows)

Attributes, Text, and Mixed Content

Real XML mixes these freely. Decide a rule before you convert.

When One CSV Is Not Enough

Deep documents sometimes need multiple flat tables: orders.csv, line_items.csv, shipments.csv, linked by order_id. That is healthier than a mega-wide sheet with hundreds of sparse columns.

Real-World Examples

Common conversion jobs.

Common Mistakes

Flattening bugs look like "missing data".

• Picking the wrong repeating element (parent instead of child).
• Dropping attributes entirely.
• Ignoring XML namespaces and getting empty results.
• Not quoting CSV fields that contain commas from XML text.
• Assuming one XML file always maps to one tidy sheet.

Best Practices

A short playbook for reliable flats.

• Identify the row element before converting.
• Preserve attributes as columns.
• Handle namespaces explicitly.
• Validate row counts against the source XML.
• Keep the original XML; regenerate CSV when the feed updates.

Why Use Convert CSV Online?

Convert CSV Online is free, browser-based, and requires no account for everyday conversions. The XML to CSV Converter flattens feeds for spreadsheet work; the Online CSV Editor lets you clean columns before Excel or a database import. Client-side workflows work on Windows, macOS, and Linux browsers.

Conclusion

XML to CSV succeeds when you choose the right repeating element, keep attributes, and verify row counts. Use a browser converter for one-offs and a small script when the feed arrives every night.