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.
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.
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.
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
XML
XML documents and data.
- Extensions
- .xml
- MIME type
- application
/xml - Kind
- Text and data
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.
$ cv convert report.xml report.tsv$ cv convert report.xml report.tsvQuestions.What people ask about XML to TSV.
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.