Convert XML to TSV

Turn XML files into TSV. The first list of repeated elements, such as the items of a feed, becomes the rows, with one column per child element or attribute, attributes starting with @.

Converted in an isolated sandbox on our serversDeleted after 24 hours

Drop XML files on the dialor turn it to pick what to do

A table from the repeated items in XML.The first list of repeated elements becomes the rows of a TSV file.

  1. What you get

    One TSV file. The first list of repeated elements in the XML, such as the items of a feed, becomes the rows. Each child element or attribute becomes a column.

    Attributes start with @ in the column name, so you can tell them apart from child elements.

  2. What changes

    Only the first list of repeated elements is used as rows. Deeper nesting does not get its own columns. It is written into the cell as JSON text.

    A document without repeated elements becomes one row.

  3. When it stops

    If the XML cannot be parsed, the conversion stops with input_corrupted. The file has to be readable as XML for any rows to be produced.

    To go the other way, use TSV to XML.

XML and TSV.What each format is.

The formats

From · XML

XML

XML documents and data.

Extensions
.xml
MIME type
application/xml
Kind
Text and data
To · TSV

Tab-Separated Values

Tab-separated values.

Extensions
.tsv .tab
MIME type
text/tab-separated-values
Kind
Text and data

In your code.The same XML to TSV conversion through the API, for your app or your agent.

terminal
$ cv convert report.xml report.tsv
$ cv convert report.xml report.tsv

Questions.What people ask about XML to TSV.

01OF 04

The first list of repeated elements becomes the rows. Each child element or attribute becomes a column.

It marks an attribute. Columns from child elements have no @ at the start.

Nesting deeper than the columns is written into the cell as JSON text.

The whole document becomes one row.

More conversions.Other ways in and out of XML and TSV.