XML to CSV
Turn record-style XML into a CSV table.
How to use
- 1 Paste your record-style XML into the input box.
- 2 Choose the delimiter your spreadsheet or database expects.
- 3 Check the generated CSV and the row/column summary.
- 4 Copy the CSV or paste it straight into your sheet.
About XML to CSV
The XML to CSV converter flattens a list of repeating XML records into a clean comma-separated table you can open in Excel, Google Sheets or any database import wizard.
It expects the common "list of records" shape — a single root element wrapping a series of identical child elements, each holding simple field elements — and turns every record into a CSV row and every field into a column.
The header is built from the union of all field names it sees, in first-seen order, so records that are missing a field still line up correctly and no data is silently dropped.
Values containing commas, quotes or newlines are escaped with the standard double-quote rules, and common XML entities such as &, < and > are decoded back to their characters.
You can switch the output delimiter to a semicolon, tab or pipe to match whatever your target program expects, and a small summary shows the row and column counts.
The conversion runs entirely in your browser using a tiny dependency-free parser — your XML is never uploaded or stored — so it is safe for sensitive exports and works offline once loaded.
FAQ
What XML structure does it expect?
A single root element wrapping repeated record elements, each containing simple field elements — for example <rows><row><id>1</id></row></rows>. Each record becomes a CSV row.
How are missing fields handled?
The header is the union of every field name found across all records, so a record missing a field simply leaves that cell empty rather than shifting the columns.
Are special characters escaped?
Yes. Values with the delimiter, quotes or line breaks are wrapped in double quotes, and XML entities are decoded back to their characters.