Convert TSV to XML

Turn TSV files into XML. Objects become elements inside one root element and every value becomes text, with characters a tag name cannot hold turned into underscores.

Converted in an isolated sandbox on our serversDeleted after 24 hours

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

Your TSV data as one XML file.Rows become elements inside a single root element, and every value becomes text.

  1. What you get

    One XML file. The data sits inside one root element, and objects become elements. Every value is written as text, so numbers and other values are not typed in the XML.

    A list repeats its element once for each item.

  2. What changes

    Characters that a tag name cannot hold are turned into underscores. A column name with such characters comes out with underscores in its place.

    Keys that start with @ become attributes, and lists and objects in them are written as JSON text. A key named #text becomes the element's own text.

  3. What disappears

    An empty list leaves nothing behind, because a list is written by repeating its element and there are no items to repeat. A list of lists is flattened into one level.

    To go the other way, use XML to TSV.

TSV and XML.What each format is.

The formats

From · TSV

Tab-Separated Values

Tab-separated values.

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

XML

XML documents and data.

Extensions
.xml
MIME type
application/xml
Kind
Text and data

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

terminal
$ cv convert sheet.tsv sheet.xml
$ cv convert sheet.tsv sheet.xml

Questions.What people ask about TSV to XML.

01OF 04

No. Every value becomes text.

Characters a tag name cannot hold are turned into underscores.

Yes. A key that starts with @ becomes an attribute. A key named #text becomes the element's own text.

No. A list repeats its element, so an empty list disappears.

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