jsonecho

XML to CSV

Turn repeating XML records into CSV rows for Excel or a database import.

Loading the tool...

How to use XML to CSV

Paste your XML or load the file.
Pick a delimiter.
Copy the CSV or download it.

About XML to CSV

Exports from shop systems, ERP software and government portals often arrive as XML, with one element per record. Spreadsheets cannot read that. This converter finds the repeating element, makes one row from each, and uses the child elements and attributes as columns.

Nested elements are flattened with dotted names. If your file contains several different lists, the longest one is used as the table.

Frequently asked questions

How does it decide what a row is?

It looks for the repeating element, the one that appears several times under the same parent. In an order file, for instance, that is each item element.

Where do attributes go?

Each attribute becomes its own column with the prefix @_, for example @_sku.

What if my XML has two repeating lists?

The longest list becomes the table. To export the other one, copy that part of the XML into the input on its own.

Can I open the result in Excel?

Yes. If everything lands in one column, change the delimiter to a semicolon.

More in Converters

All tools →

JSON to XMLConvert JSON to indented XML with a custom root element.Convert JSON to YAMLConvert JSON to clean, readable YAML.Convert JSON to TSVConvert JSON to tab-separated values.Convert JSON to StringConvert JSON into an escaped string for code and configs.Convert String to JSONUnescape a JSON string and format it as readable JSON.Convert JSON to HTML TableConvert a JSON array into an HTML table.Convert JSON to Markdown TableConvert JSON into a neatly aligned Markdown table.Convert XML to YAMLConvert XML to readable YAML.Convert