XML to CSV Converter

Paste XML text with repeating value... records and convert it to CSV/TSV.

Tips

  • This tool is the reverse of the CSV to XML converter (dev.csv.csv_to_xml) — paste output from that tool to get your original CSV back.
  • The CSV/TSV header row is taken from the child element tag names found in the first element.
  • Columns are matched by tag name rather than position, so rows with a slightly different element order are still handled correctly.
  • Useful for importing SOAP web service responses or exports from legacy business systems into Excel or a spreadsheet.
  • Character references such as `&`, `<`, and `>` are automatically decoded back to `&`, `<`, and `>` in the output.

Frequently Asked Questions

It supports XML with a repeating element, each containing child elements shaped like value. This matches the output of the CSV to XML converter (dev.csv.csv_to_xml), and many SOAP responses and legacy system exports use the same one-record-per-element structure.

Elements whose opening and closing tags do not match are simply skipped, leaving the corresponding cell empty, rather than causing a crash. However, if no elements are found at all, no result is produced and an error message is shown instead.

Many SOAP-based web services and legacy core banking or government systems built before JSON became widespread still rely on XML as their standard data exchange format. As a result, there is still a real-world need to import XML data received from partners or internal systems into spreadsheet tools.

The CSV to XML converter (dev.csv.csv_to_xml) does the reverse conversion. Used together, the two tools let you move data back and forth between XML and CSV as needed.
ツールくん

Side Note — Why SOAP and XML are still around

SOAP (Simple Object Access Protocol), the dominant standard for web service integration in the 2000s, represents both requests and responses as XML. While new development rarely chooses SOAP now that REST APIs and JSON have taken over, core banking systems and some government systems still run on SOAP/XML today because of the strict schema validation the format enables.

It is still common to find teams manually retyping XML exported from such legacy systems into Excel — an inefficient workflow that persists in many organizations. This tool aims to close that gap: when XML is the only format available but a spreadsheet is what you actually need, the conversion can happen entirely in the browser. Paired with the CSV to XML converter, it also makes it easy to move data back and forth whenever different departments or systems expect different formats.

All conversion in this tool runs client-side in your browser — the XML you paste is never sent to a server. That makes it safe to use even with confidential partner data or personal information embedded in the XML. File upload is also supported, so you can skip copy-pasting from a text editor entirely.

→ Read related trivia

→ Browse all trivia

More tools in this category