onlinejsontools logo

Convert tsv to json

World's simplest json tool

Free online TSV to JSON converter. Just load your TSV and it will automatically get converted to JSON. There are no ads, popups or nonsense, just an awesome TSV to JSON converter. Load TSV, get JSON. Created by developers for developers.
announcement heads up!
We just launched a new site — Online MATH Tools — utilities for doing mathy things. Check it out!
fullscreen fullscreen_exit
Converting
Skip lines starting with this
Don't convert empty lines
Indentation
Indent output with spaces
How many spaces per indent? Set to 0 to minify JSON
Indent output with tabs
Convert tsv to json tool What is a convert tsv to json?
This tool converts TSV (Tab Separated Values) to JSON (JavaScript Object Notation) files. You can skip lines that start with comments and you can also skip empty lines. The resulting JSON can be minified or neatly beautified using tabs or spaces.
Convert tsv to json examples Click to use
Simple example
Convert three columns separated by tabs to a JSON array of objects with three keys.
a b c 1 2 3 4 5 6
[ { "a": "1", "b": "2", "c": "3" }, { "a": "4", "b": "5", "c": "6" } ]
Skip commented lines
Another example that converts two TSV columns to JSON and skips lines that start with a dash.
foo bar aaa bbb -ccc ddd eee fff
[ { "foo": "aaa", "bar": "bbb" }, { "foo": "eee", "bar": "fff" } ]
Required options
These options will be used automatically if you select this example.
Skip lines starting with this
Pro tips Master online json 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://onlinejsontools.com/convert-tsv-to-json?input=a%09b%09c%0A1%092%093%0A4%095%096
All json tools
Didn't find the tool you were looking for? Let us know what tool we are missing and we'll build it!
Quickly color code the syntax of a JSON file.
Quickly beautify a JSON data structure.
Quickly compress a JSON file.
Quickly check JSON for errors and report them.
Quickly escape special JSON characters.
Quickly unescape an escaped JSON string.
Quickly convert a JSON data structure to an XML file.
Quickly convert an XML file to a JSON data structure.
Quickly convert a JSON data structure to a YAML file.
Quickly convert YAML markup to a JSON data structure.
Quickly convert a JSON file to a TSV file.
Quickly convert TSV data to a JSON file.
Quickly convert a JSON document to a CSV document.
Quickly convert a CSV document to a JSON document.
Quickly convert JSON to a PNG, GIF, JPG or BMP Image.
Quickly encode JSON to base64.
Quickly decode base64 to JSON.
Quickly convert JSON to URL-encoding.
Quickly convert URL-escaped JSON back to JSON.
Quickly convert JSON data to plain text.
Quickly edit a JSON file in a neat JSON editor in your web browser.
Coming soon These json tools are on the way
Display JSON Statistics
Display detailed information about a JSON data structure.
Flatten JSON
Loop over JSON structure and extract all values as a list.
Obfuscate JSON
Obfuscate a JSON data structure.
Convert JSON to a HTML
Create a HTML table from JSON object keys and values.
Convert JSON to Bencode
Convert a JSON data structure to Bencode encoding.
Convert Bencode to JSON
Convert Bencode data to JSON data.
Convert JSON to BSON
Convert a JSON data structure to binary BSON data.
Convert BSON to JSON
Convert binary JSON data structure (BSON) to JSON.
Convert JSON to a LaTeX Table
Generate a LaTeX table from a JSON object.
Truncate JSON
Loop over JSON structure and truncate all values.
Convert JSON to Data URI
Convert a JSON data structure to a data URL.
Convert JSON to a PHP Array
Create a PHP data structure from a JSON data structure.
Convert a PHP array to JSON
Create a JSON data structure from a PHP data structure.
Compare Two JSON Files
Diff JSON files and show differences visually.