Convert TSV to JSON

Turn TSV files into JSON. An array with one object per row, keyed by the header row.

Converted in an isolated sandbox on our serversDeleted after 24 hours

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

Rows become JSON objects.Each row of the TSV becomes one object in a JSON array.

  1. What you get

    One JSON file that holds an array. Each row of the TSV becomes one object in that array, and the header row supplies the keys.

    A TSV with a header and three rows of data gives an array of three objects, each with the header names as its keys.

  2. Options

    This conversion has no options. The output is one file, and nothing needs to be set before you convert.

  3. Going the other way

    To turn a JSON array back into a table, use JSON to TSV. To join several TSV files before converting, use merge TSV.

TSV and JSON.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 · JSON

JSON

JSON, the data format of every API.

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

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

terminal
$ cv convert sheet.tsv sheet.json
$ cv convert sheet.tsv sheet.json

Questions.What people ask about TSV to JSON.

01OF 04

It is an array with one object per row. The keys of each object come from the header row.

They come from the header row of the TSV. Each data row is keyed by those names.

No. There are no options for this conversion.

No. The header row supplies the keys, and each row after it becomes one object.

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