XML to CSV

What Does This Converter Do?

This tool converts tabular XML - XML where the root element contains a repeated set of child elements each representing a row - into CSV format. Each direct child of the root becomes a CSV row; the sub-elements and attributes of those children become columns. The first row of the output is the header row, derived from the union of all child element names and attribute names found across the dataset.

For example, a <bookstore> root with repeated <book> children becomes a spreadsheet where each book is a row and each <title>, <author>, and @category attribute is a column.

CSV Output Rules

• Header row is built from the union of all child-element tag names and attribute names (prefixed @) found across all rows.
• Missing fields produce an empty cell. Rows that lack a column present in other rows will have a blank value for that column.
• RFC 4180 quoting - values containing commas, double quotes, or newlines are wrapped in double quotes; internal double quotes are doubled.
• Only direct children of each row element are flattened. Deeply nested XML sub-trees are not recursively flattened - only the immediate text content is used.

Common Use Cases