What XML shape does it expect?

A flat structure: a root element containing repeating child elements with the same fields. ` 1 2 ... ` becomes a two-column CSV.

How are attributes handled?

Attributes become columns. ` a ` becomes `id,name` with the attribute in column 1.

Optional — toggle 'flatten with dots' to get `parent.child` columns. Deep nesting produces many columns; simple shapes produce cleaner CSV.

Auto-detected as the most-frequent child of the root. Override if your document structure is unusual.

A worked example, rendered from real sample data. Sign in to run the tool on your own input.

Input

<products><product><name>Laptop</name><price>999</price></product><product><name>Mouse</name><price>29</price></product></products>

Output

name,price
Laptop,999
Mouse,29

Convert XML data to CSV format. Part of the DevTools Surf developer suite. Browse more tools in the Converters collection.

Converting XML to CSV requires flattening hierarchical data, which can result in data duplication for nested elements.
XSLT 1.0 (1999) was one of the earliest tools used to transform XML into flat formats like CSV.
The loss of hierarchy when converting XML to CSV is sometimes called 'impedance mismatch' in data engineering.

What XML shape does it expect?: A flat structure: a root element containing repeating child elements with the same fields. `<rows><row><a>1</a><b>2</b></row>...</rows>` becomes a two-column CSV.
How are attributes handled?: Attributes become columns. `<row id="1"><name>a</name></row>` becomes `id,name` with the attribute in column 1.
What about nested XML?: Optional — toggle 'flatten with dots' to get `parent.child` columns. Deep nesting produces many columns; simple shapes produce cleaner CSV.
Does the tool infer the record element?: Auto-detected as the most-frequent child of the root. Override if your document structure is unusual.

A worked example, rendered from real sample data. Sign in to run the tool on your own input.

Input

<products><product><name>Laptop</name><price>999</price></product><product><name>Mouse</name><price>29</price></product></products>

Output

name,price
Laptop,999
Mouse,29

Convert XML data to CSV format. Part of the DevTools Surf developer suite. Browse more tools in the Converters collection.

Converting XML to CSV requires flattening hierarchical data, which can result in data duplication for nested elements.
XSLT 1.0 (1999) was one of the earliest tools used to transform XML into flat formats like CSV.
The loss of hierarchy when converting XML to CSV is sometimes called 'impedance mismatch' in data engineering.

What XML shape does it expect?: A flat structure: a root element containing repeating child elements with the same fields. `<rows><row><a>1</a><b>2</b></row>...</rows>` becomes a two-column CSV.
How are attributes handled?: Attributes become columns. `<row id="1"><name>a</name></row>` becomes `id,name` with the attribute in column 1.
What about nested XML?: Optional — toggle 'flatten with dots' to get `parent.child` columns. Deep nesting produces many columns; simple shapes produce cleaner CSV.
Does the tool infer the record element?: Auto-detected as the most-frequent child of the root. Override if your document structure is unusual.