Flatten XML rows to CSV
Take a simple XML document with rows of children and pull the data into CSV. Headers come from the union of child element names. Runs in your browser.
How XML rows become CSV
The tool reads the root element's direct children as rows, and each row's child elements as columns. Missing fields become empty cells.
- 01
Paste XML
Document with a root holding repeated <row>-style elements.
Parsing is strict-but-tolerant — comments and trailing commas are accepted on input where the source format historically permits them; output stays canonical.
inputstricttolerantliveparseinput · sourcexml · live<rows><row>…</row></rows>
loaded · parsedtarget · ready - 02
Headers detected
Union of every child tag becomes the header row.
Conversion preserves type information where the target supports it (numbers stay numeric, booleans stay boolean) so the destination parser never has to re-coerce.
headerstype-preservinglosslesslivememoisedheaders · optionsauto · livename,age
options applied · liveround-trip - 03
Cells filled
Text content of each child fills the cell — missing ones are blank.
Re-encoding is idempotent: running output back through the same converter produces the same bytes, which keeps round-trips git-friendly.
cellsidempotentround-tripdiff-cleandeterministicrows · convertedout · readyAlice,30 Bob,25
converted · livediff-clean - 04
Copy or download
Drop the CSV into Excel, Sheets, or a CSV importer.
Copy writes via
navigator.clipboard.writeText; downloads use the target’s native MIME so editors apply the right syntax highlighting on open.exportclipboardtarget MIMEblobclient-side✓ · copiedready · done✓ Copied
shipped · ready to shipsuccess
Converting between formats, safely
Pick the strictest source format
Lossy formats hide bugs. Choose JSON or YAML as your source-of-truth, convert downstream as needed.
Round-trip in CI
If your converter is idempotent, your CI can verify A → B → A equals the original. Catches subtle data loss.
Numbers vs strings differ
YAML/TOML have a number type; CSV doesn’t. Quote IDs in CSV to keep leading-zero values intact.
Watch character encoding
Source format may be Latin-1 / Windows-1252; target should be UTF-8. Convert encoding before structure.
Preserve comments where you can
YAML and TOML support comments. Don’t silently drop them — they often encode intent.
Schema-aware beats blind
Use a schema to guide conversion. Field types, required-ness, and defaults survive better with structure.
When to convert XML to CSV
Reporting, spreadsheets, legacy XML feeds.
Legacy feeds
Turn legacy XML data feeds into spreadsheets. Type information survives: numbers stay numeric, booleans stay boolean, strings stay strings. The destination parser doesn't have to re-coerce, which avoids the "'true' becomes "true"" bug class.
round-trip safeReports
Drop into Excel for ad-hoc analysis. Run output back through the inverse converter to verify idempotent round-trips in CI. A → B → A should produce byte-identical input — if it doesn't, you've found data loss.
type-preservingETL pipelines
Stage as CSV before loading into a warehouse. Comments and metadata survive where the target format supports them (YAML, TOML, HCL). The tool doesn't silently drop intent-encoded annotations, which keeps your config self-documenting.
schema-awareDB import
Many DB tools have a CSV importer but no XML one. Pair with a schema (JSON Schema, OpenAPI, Zod, Pydantic) to catch shape drift on either side. Catch breaking changes at conversion time rather than at runtime in production.
losslessQuick scan
Diff structured XML data with familiar columns. Output respects target-format conventions: quoting in CSV, indent in YAML, brackets in JSON. Existing parsers don't need patches, and the result drops into legacy pipelines unchanged.
diff-cleanSharing
Send a CSV to non-technical teammates. Encoding-aware: handles UTF-8 vs UTF-16 vs Latin-1 / Windows-1252 transparently. The character-set surprise that breaks "works on my machine" doesn't apply here.
spec-gradeFrequently asked questions
Something missing?
Tell us what you need. We ship the top requests every two weeks.