XML to TSV Converter

Tab-separated text is what a spreadsheet takes straight from the clipboard: paste it into a cell and every value lands in its own column, with no import dialog and no trouble from commas inside values. This converter turns XML records into exactly that, which makes it the quick route from an XML export or API response into Excel, Google Sheets or Numbers.

Because everything runs in your browser, it suits data you would rather not upload: internal exports, draft records, anything mid-pipeline. The document is parsed locally, and nothing persists once you close the tab.

Drop or open an .xml file, or paste the XML, then run it. The parser is strict: an unclosed tag, a stray & or text outside the root element stops the run with the line and column of the problem. There is no upload and no server round trip.

The element that repeats most often under the root becomes the row. Within each row, attributes become @-named columns, simple child elements become columns, and deeper fields are named by path. A field that repeats within one record gets a numbered column instead of being merged into another cell.

Values containing a tab, a quote or a line break are wrapped in quotes so columns stay aligned. The output is UTF-8 text with a header row.

Records with different fields give sparse columns, and very deep XML gives long path-named headers. Both keep every value; tidy them in the spreadsheet afterwards if you only need some fields.

Values arrive as text, but the spreadsheet you paste into may reformat numbers, dates and codes with leading zeros. Set those columns to plain text before pasting if the exact characters matter.

If nothing in the document repeats, it becomes a single row. That usually means the records sit one level deeper than the root's children; converting a smaller part of the XML that starts at the list will give one row per record.

Confirm the header row lists the fields you expected, including attributes, and that the number of rows matches the number of records.

Look for numbered columns such as phone_2: they mark a field that repeated inside a record.

For anything official, financial or legal, treat the conversion as a draft and verify key fields against the original XML before using it.