᠎᠎᠎          
51K

TSV to JSON Converter

World's simplest tsv tool
World's simplest online Tab Separated Values to JavaScript Object Notation converter. Just paste your TSV file in the form below and it will instantly get converted to JSON. Free, quick, and very powerful. Paste TSV, get JSON. Created by programmers from team Browserling.
love commas more than tabs? foo,bar,baz
We also have Online CSV Tools — utilities for working with comma separated values. Check it out!
A link to this tool, including input, options and all chained tools.
Import from file
Save as...
Copy to clipboard
Download
Export to Pastebin
Can't convert.
An error has occured.
Chain with...
Remove chain
Save as...
Copy to clipboard
Download
Export to Pastebin
Remove no tools?
This tool cannot be chained.
TSV Format
What character separates TSV columns? (Usually a tab "\t".)
What character encloses TSV values in quotes? (Usually double quotes.)
What character denotes the beginning of a TSV comment? (Usually a hash "#".)
Conversion Options
Generate an associative JSON array where the headers from the first row of TSV are used as keys.
Detect numeric and boolean data types in TSV and leave them unquoted in JSON.
Skip empty TSV lines and exclude them from being converted to JSON.
JSON Format
Use two spaces for hierarchical indentation.
Use one tab for hierarchical indentation.
Output the JSON as a single line (minified).

What is a TSV to JSON Converter?

learn more about this tool
This tool transforms Tab Separated Values (TSV) files to JavaScript Object Notation (JSON) data structures. The output JSON can either be an array of objects or an array of arrays. You can control whether it's objects or arrays via the "Convert Headers to JSON Keys" option. If this option is on, then the first row of your TSV data with column names will be used as keys for the JSON objects (one TSV row will be converted to one object with as many keys as there are columns). Otherwise, the data will simply be converted as arrays (one TSV row will be converted to one array with as many elements as there are columns). If your TSV data doesn't have headers, then you can disable this option. Numbers and boolean values can be represented in JSON without quotes using the "Unquote Numbers and Booleans" option. The "Remove Empty Lines" option can be used to eliminate empty lines from the output. You also can change JSON indentation to spaces, tabs, or output compressed JSON. If your input TSV uses different delimiter, quote, and comment characters than tabs (\t), double quotes ("), and hashes (#), you can customize them in the options. These options make the tool very flexible and it can work with non-standard TSV file formats. To convert JSON back to TSV, you can use our Convert JSON to TSV tool. TSVabulous!

TSV to JSON Converter examples

Click to use
Transpile TSV to JSON
This example translates TSV to JSON and sets JSON indentation to 2 spaces. The input data contains 3 columns and 3 rows. The first row defines column titles ("foo", "bar", "baz") and the remaining 2 rows contain the data ("aaa", "bbb", "ccc", etc). When the input TSV is converted into JSON, the column titles are used as JSON keys and the data are used as JSON values.
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.
What character separates TSV columns? (Usually a tab "\t".)
What character encloses TSV values in quotes? (Usually double quotes.)
What character denotes the beginning of a TSV comment? (Usually a hash "#".)
Generate an associative JSON array where the headers from the first row of TSV are used as keys.
Detect numeric and boolean data types in TSV and leave them unquoted in JSON.
Skip empty TSV lines and exclude them from being converted to JSON.
Use two spaces for hierarchical indentation.
Create a JSON Object from a TSV
In this example, we convert a TSV file into an array of JavaScript objects. The input TSV contains a list of the most popular games of the last decade. The first column contains the years and the second column contains the game titles. After converting this two-column list to JSON, each row becomes a separate object with the keys "Year" and "Video Game". Additionally, we activate the "Unquote Numbers and Booleans" option and use tabs to add hierarchical indentation to the output JSON.
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.
What character separates TSV columns? (Usually a tab "\t".)
What character encloses TSV values in quotes? (Usually double quotes.)
What character denotes the beginning of a TSV comment? (Usually a hash "#".)
Generate an associative JSON array where the headers from the first row of TSV are used as keys.
Detect numeric and boolean data types in TSV and leave them unquoted in JSON.
Skip empty TSV lines and exclude them from being converted to JSON.
Use one tab for hierarchical indentation.
Create a Minified JSON from TSV
In this example, we transform TSV data into a minified JSON array. By disabling the option to convert headers into JSON keys, we obtain a bunch of arrays as output, where each array represents one tab-separated record. Additionally, we remove empty lines and comments from the input TSV data. The comments are removed because they start with the hash symbol "#" and we entered this symbol in the tool settings.
Name Department Position Alice Marketing Manager Bob HR Specialist Charlie Finance Analyst David IT Developer Emily Operations Coordinator #Micheal
[["Name","Department","Position"],["Alice","Marketing","Manager"],["Bob","HR","Specialist"],["Charlie","Finance","Analyst"],["David","IT","Developer"],["Emily","Operations","Coordinator"]]
Required options
These options will be used automatically if you select this example.
What character separates TSV columns? (Usually a tab "\t".)
What character encloses TSV values in quotes? (Usually double quotes.)
What character denotes the beginning of a TSV comment? (Usually a hash "#".)
Generate an associative JSON array where the headers from the first row of TSV are used as keys.
Detect numeric and boolean data types in TSV and leave them unquoted in JSON.
Skip empty TSV lines and exclude them from being converted to JSON.
Output the JSON as a single line (minified).
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&char-delimiter=%5Ct&char-quote=%22&char-comments=%23&convert-headers=true&convert-dynamic-types=true&convert-skip-empty=true&formatting-spaces=true
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!
Change TSV Delimiter
Quickly change the TSV delimiter to a different symbol.
Generate a Random TSV
Quickly generate random TSV data.
Extract a TSV Column
Quickly extract columns from a TSV file.
Delete a TSV Column
Quickly delete columns in a TSV file.
Quote TSV Columns
Quickly add quotes around TSV columns.
Unquote TSV Columns
Quickly remove quotes that surround TSV columns.
Swap TSV Columns
Quickly swap columns in a TSV file.
Convert TSV to JSON
Quickly convert a TSV file to a JSON data structure.
Convert JSON to TSV
Quickly convert a JSON data structure to TSV format.
Convert TSV to XML
Quickly convert a TSV file to XML markup.
Convert XML to TSV
Quickly convert XML markup to a TSV file.
Convert TSV to YAML
Quickly convert a TSV file to YAML markup.
Convert YAML to TSV
Quickly convert YAML data to a TSV file.
Convert TSV to CSV
Quickly convert TSV data to CSV data.
Convert CSV to TSV
Quickly convert CSV data to TSV data.
Convert TSV to Text Columns
Quickly convert TSV data to nicely aligned text columns.
Convert Text Columns to TSV
Quickly convert text columns to TSV columns.
Base64-encode TSV Data
Quickly convert TSV data to base64 encoding.
Base64-decode TSV Data
Quickly convert base64-encoded TSV data to TSV data.
URL-encode a TSV File
Quickly convert a TSV file to URL-encoding.
URL-decode a TSV File
Quickly convert a URL-encoded TSV file back to TSV.
Prepend TSV Columns
Quickly prepend new columns at the start of a TSV file.
Append TSV Columns
Quickly append new columns at the end of a TSV file.
Insert a TSV Column
Quickly insert new columns anywhere in a TSV file.
Replace a TSV Column
Quickly replace columns in a TSV file.
Trim TSV Columns
Quickly remove extra spaces around TSV columns.
Truncate TSV Columns
Quickly truncate the contents of TSV cells to any length.
Convert TSV Cols to Rows
Quickly exchange TSV columns with rows.
Convert TSV Rows to Cols
Quickly exchange TSV rows with columns.
Transpose TSV
Quickly transpose a TSV file.
Coming soon These tsv tools are on the way
Validate TSV
Quickly check a TSV file for errors and report them.
Display TSV Statistics
Print information about a TSV file.
Calculate TSV Entropy
Find the complexity of a TSV file.
Show TSV Structure
Create an abstract drawing that shows the structure of a TSV.
View and Edit TSV
Show a TSV file in a neat editor and allow easy editing.
Convert TSV to Double-TSV
Convert a TSV file to a double-TSV file.
Convert Double-TSV to TSV
Convert a double-TSV file to a regular TSV file.
Convert TSV to HTML Table
Convert a Tab Separated Values file to an HTML table.
Convert HTML Table to TSV
Convert an HTML table to a Tab Separated Values file.
Convert TSV to Markdown
Convert a TSV file to a Markdown table.
Convert Markdown to TSV
Convert a Markdown table to a TSV file.
Convert TSV to PDF
Convert a Tab Separated Values file to a PDF document.
Convert PDF to TSV
Convert a PDF document to a Tab Separated Values file.
Convert TSV to Image
Draw Tab Separated Values as a table and output it as an image.
Convert Image to TSV
Extract data in an image and format it as a TSV file.
Convert TSV to Excel
Convert a Tab Separated Values file to an Excel spreadsheet.
Convert Excel to TSV
Convert an Excel file to a Tab Separated Values file.
Convert TSV to LaTeX
Convert a TSV file to LaTeX code that generates a table.
Convert TSV to ASCII Table
Convert a Tab Separated Values file to a neat ASCII table.
Convert ASCII Table to TSV
Convert an ASCII table to a Tab Separated Values file.
Convert TSV to SQL
Convert a Tab Separated Values file to an SQL query.
Convert TSV to SQLite
Convert a Tab Separated Values file to an SQLite database.
Convert SQLite to TSV
Export tables from an SQLite database as TSV files.
Convert TSV to PSV
Convert a TSV file to a PSV (Pipe Separated Values) file.
Convert PSV to TSV
Convert a PSV (Pipe Separated Values) file to a TSV file.
Convert TSV to HSV
Convert a TSV file to a HSV (Hash Separated Values) file.
Convert HSV to TSV
Convert a HSV (Hash Separated Values) file to a TSV file.
Convert TSV to SSV
Convert a TSV file to a SSV (Semicolon Separated Values) file.
Convert SSV to TSV
Convert a SSV (Semicolon Separated Values) file to a TSV file.
Convert TSV to 0SV
Convert a TSV file to a 0SV (Null Separated Values) file.
Convert 0SV to TSV
Convert a 0SV (Null Separated Values) file to a TSV file.
Split a TSV File
Create multiple TSV files from the given TSV file.
Merge TSV Files
Merge together two Tab Separated Values files.
Delete TSV Tabs
Remove tabs that go between TSV columns and merge all data.
Delete Empty TSV Columns
Remove columns that have no values in a TSV file.
Delete Empty TSV Rows
Remove rows that have no values in a TSV file.
Delete Empty TSV Lines
Remove lines in a TSV file that are blank.
Delete TSV Comments
Delete TSV lines that are comments.
Filter TSV Data
Filter rows and columns that match a pattern.
Find Values in TSV
Find certain values in TSV cells.
Compress TSV
Minify a TSV file and remove extra spaces and indentation.
Compare Two TSV Files
Diff two TSV files and visually display the differences.
Rotate TSV Columns
Rotate TSV columns to the left or right.
Rotate TSV Rows
Rotate TSV rows up or down.
Cut a TSV File
Cut a fragment from a TSV file.
Slice a TSV File
Extract a slice (rows/columns/cells) of a TSV file.
Randomize TSV Values
Shuffle all data values in a TSV file.
Randomize TSV Columns
Shuffle the order of TSV columns.
Randomize TSV Rows
Shuffle the order of TSV rows.
Sort TSV Columns
Sort values in a TSV column.
Sort TSV Rows
Sort values in a TSV rows.
Count TSV Columns
Find how many columns there are in the given TSV data.
Count TSV Rows
Find how many rows there are in the given TSV data.
Count TSV Entries
Find how many total entries there are in a TSV file.
Color a TSV File
Add colors to TSV data for easy visual overview of the file.
Add Errors to TSV
Create random errors in a TSV file for fuzz testing.
Create a Custom TSV
Generate a custom TSV with n rows and m columns.
Open a TSV File
Open a TSV file directly in your browser.
Created with love by
51K
@browserling
We're Browserling — a friendly and fun cross-browser testing company powered by alien technology. At Browserling we love to make developers' lives easier, so we created this collection of online tsv tools. Unlike many other tools, we made our tools free, without ads, and with the simplest possible user interface. Our online tsv tools are actually powered by our programming tools that we created over the last couple of years. Check them out!
Secret message
If you love our tools, then we love you, too! Use coupon code TSVLING to get a discount at Browserling.
Privacy Policy we don't log data!
All conversions and calculations are done in your browser using JavaScript. We don't send a single bit about your input data to our servers. There is no server-side processing at all. We use Google Analytics and StatCounter for site usage analytics. Your IP address is saved on our web server, but it's not associated with any personally identifiable information. We don't use cookies and don't store session information in cookies. We use your browser's local storage to save tools' input. It stays on your computer.
Terms of Service the legal stuff
By using Online Tsv Tools you agree to our Terms of Service. TLDR: You don't need an account to use our tools. All tools are free of charge and you can use them as much as you want. You can't do illegal or shady things with our tools. We may block your access to tools, if we find out you're doing something bad. We're not liable for your actions and we offer no warranty. We may revise our terms at any time.