onlinetsvtools logo

Tsv to json converter

World's simplest tsv tool

World's simplest online Tab Separated Values to JavaScript Object Notation converter. Just paste your Tab Separated Values in the form below and they will instantly get converted to JSON. Free, quick, and very powerful. Paste TSV, get JSON. Created by programmers from team Browserling.
announcement a new site!
We just launched a new site – Online Unicode Tools – utilities for working with Unicode. Check it out!
JSON Indentation
Indent JSON with spaces.
How many spaces per indent?
Indent output with tabs.
Don't indent and compress JSON.
Tsv to json converter tool What is a tsv to json converter?
This tool transforms Tab Separated Values (TSV) files to JavaScript Object Notation (JSON) data structures. The output JSON is an array of hashes, where each hash contains one TSV row. The first row of the TSV data is used for column titles. The JSON hash keys are the values on the first row and the JSON hash values are the TSV values of that row. You can change the JSON's indentation to spaces, tabs or output compressed JSON. Coming soon, you will be able to switch between various JSON output formats, such as an array of arrays and an array of objects. TSVabulous!
Tsv to json converter examples Click to use
Transpile TSV to JSON
This example translates TSV to JSON and sets JSON indentation to 1 space. The input data contains 3 columns and 3 rows. The first row defines column titles, and the remaining 2 rows contain the data. When the input is converted into JSON, the column titles are used as JSON keys.
foo bar baz aaa bbb ccc ddd eee fff
[ { "foo": "aaa", "bar": "bbb", "baz": "ccc" }, { "foo": "ddd", "bar": "eee", "baz": "fff" } ]
Required options
These options will be used automatically if you select this example.
Indent JSON with spaces.
How many spaces per indent?
Minified JSON
In this example, we minify the output JavaScript object. The input TSV contains the most popular games of the last decade. The first column contains the years and the second column contains the game titles.
Year Video Game 2010 Mass Effect 2 2011 Dark Souls 2012 The Walking Dead 2013 Dota 2 2014 The Last of Us 2015 The Witcher 3 2016 Overwatch 2017 Legend of Zelda 2018 Minecraft 2019 Resident Evil 2 2020 Mortal Kombat 11
[{"Year":"2010","Video Game":"Mass Effect 2"},{"Year":"2011","Video Game":"Dark Souls"},{"Year":"2012","Video Game":"The Walking Dead"},{"Year":"2013","Video Game":"Dota 2"},{"Year":"2014","Video Game":"The Last of Us"},{"Year":"2015","Video Game":"The Witcher 3"},{"Year":"2016","Video Game":"Overwatch"},{"Year":"2017","Video Game":"Legend of Zelda"},{"Year":"2018","Video Game":"Minecraft"},{"Year":"2019","Video Game":"Resident Evil 2"},{"Year":"2020","Video Game":"Mortal Kombat 11"}]
Required options
These options will be used automatically if you select this example.
Don't indent and compress JSON.
Pro tips Master online tsv tools
You can pass input to this tool via ?input query argument and it will automatically compute output. Here's how to type it in your browser's address bar. Click to try!
https://onlinetsvtools.com/convert-tsv-to-json?input=foo%09bar%09baz%0Aaaa%09bbb%09ccc%0Addd%09eee%09fff&indent-use-spaces=true&indent-spaces=1
All tsv tools
Didn't find the tool you were looking for? Let us know what tool we are missing and we'll build it!
Quickly convert a TSV file to a JSON data structure.
Quickly convert a JSON data structure to TSV format.
Quickly convert a TSV file to XML markup.
Quickly convert XML markup to a TSV file.
Quickly convert a TSV file to YAML markup.
Quickly convert YAML data to a TSV file.
Quickly convert TSV data to CSV data.
Quickly convert CSV data to TSV data.
Quickly convert TSV data to nicely aligned text columns.
Quickly convert text columns to TSV columns.
Quickly convert TSV data to base64 encoding.
Quickly convert base64-encoded TSV data to TSV data.
Quickly convert a TSV file to URL-encoding.
Quickly convert a URL-encoded TSV file back to TSV.
Quickly change TSV delimiter to a new one.
Quickly prepend new columns at the start of a TSV file.
Quickly append new columns at the end of a TSV file.
Quickly insert new columns anywhere in a TSV file.
Quickly extract columns from a TSV file.
Quickly replace columns in a TSV file.
Quickly delete columns in a TSV file.
Quickly swap columns in a TSV file.
Quickly remove extra spaces around TSV columns.
Quickly truncate the contents of TSV cells to any length.
Quickly add quotes around TSV columns.
Quickly remove quotes that surround TSV columns.
Quickly exchange TSV columns with rows.
Quickly exchange TSV rows with columns.
Quickly transpose a TSV file.
Quickly generate random TSV data.
Coming soon These tsv tools are on the way
Display TSV Statistics
Print information about a TSV file.
Convert TSV to HTML
Convert a Tab Separated Values file to an HTML table.
Convert TSV to PDF
Convert a Tab Separated Values file to a PDF document.
Convert TSV to an Image
Draw Tab Separated Values as a table and output it as an image.
Convert TSV to Excel
Convert a Tab Separated Values file to an Excel spreadsheet.
Preview and Edit TSV
Show a Tab Separated Values file in the browser and allow easy editing.
Convert TSV to LaTeX
Convert a Tab Separated Values file to LaTeX code that generates a table.
Convert TSV to an ASCII Table
Convert a Tab Separated Values file to a neat ASCII table.
Convert TSV to SQL
Convert a Tab Separated Values file to an SQL query.
Merge TSV Files
Merge together two Tab Separated Values files.
Delete Empty TSV Columns
Delete columns that have no values in a Tab Separated Values file.
Delete Empty TSV Rows
Delete rows that have no values in a Tab Separated Values file.
Compress TSV
Minify a Tab Separated Values file. Remove extra spaces and indentation.
Diff Two TSV Files
Compare two Tab Separated Values files and visually display the differences.
Randomize TSV Columns
Shuffle the order of TSV columns.
Randomize TSV Rows
Shuffle the order of TSV rows.