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.
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.
Options
This conversion has no options. The output is one file, and nothing needs to be set before you convert.
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
Tab-Separated Values
Tab-separated values.
- Extensions
- .tsv .tab
- MIME type
- text
/tab -separated -values - Kind
- Text and data
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.
$ cv convert sheet.tsv sheet.json$ cv convert sheet.tsv sheet.jsonQuestions.What people ask about TSV to JSON.
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.