XML to CSV Converter

XML exports from shops, banks, feeds and old systems are hard to read and impossible to sort until they are in a spreadsheet. Paste the XML and get CSV (or TSV) with one row per record: the converter finds the repeating record element — every <book>, <item> or <order> — and turns its attributes and child elements into columns, using dot paths such as price.@currency or ship.city for nested data. Values are decoded and quoted correctly, so commas, quotes and line breaks survive the trip into Excel.

How to use this tool

1. Paste the XML (it is checked for well-formedness first).
2. Leave the record element empty to detect it, or type a name or path such as item or channel/item.
3. Choose the delimiter: comma, semicolon or tab.
4. Pick how attributes are named and what happens to repeated child elements.
5. Copy the CSV, or check the preview table first.

Formula

record element → row · attribute → @name column · child element → column · nested child → parent.child column

Columns appear in the order they are first met and a record without a value gets an empty cell. Repeated child elements are joined in one cell with the separator, or spread over numbered columns (tag.1, tag.2). Fields containing the delimiter, a quote or a line break are wrapped in double quotes and inner quotes are doubled, as RFC 4180 specifies; lines end with CRLF by default.

Example

In the sample catalog, <book> repeats, giving 2 records and 7 columns: @id, @lang, author, title, price, price.@currency and tag. The first row is bk101,en,"Gambardella, Matthew",XML Developer's Guide,44.95,USD,xml | programming — the author is quoted because it contains a comma and both tags share one cell. The second book has no lang and no tags, so those cells are empty.