᠎᠎᠎          
51K

Convert TSV to JSON

World's simplest json tool
Free online TSV to JSON converter. Just load your TSV in the input field and it will automatically get converted to JSON. In the tool options, you can customize the format of the input TSV – choose whether to convert column headers into JSON object keys and disable quoting of numeric and boolean values. Additionally, you can adjust the formatting of the output JSON by indenting it with spaces or tabs, or print it minified with no indentation. Created for developers by developers from team Browserling.
announcement a new site!
We just launched a new site – Online List Tools – utilities for working with lists. Check it out!
Input TSV Format
Character used to separate columns in your TSV file.
Character used to quote values in your TSV file.
Character that marks the beginning of comment lines. Rows starting with this symbol will be ignored during conversion.
Headers and Data Types
Enable this option if the first row of your TSV file contains column names. These names will be used as keys of the JSON objects.
Exclude empty lines from being converted.
Don't quote numerical and boolean values in the output JSON.
Pretty-print JSON
Output JSON with two spaces for each level of indentation.
Output JSON with one tab for each level of indentation.
Output JSON as a single line of text for minimal size.

What is a Convert TSV to JSON?

learn more about this tool
This tool converts files in TSV (Tab Separated Values) format to JSON (JavaScript Object Notation) format. TSV is a text-based data storage format where values are separated by tabs. As tabs are almost never present in the data, the tab separator makes it very easy to parse (it's just a split via the tab symbol) and import such data into data processing applications. JSON is also a text-based data storage format but it's more widely used in programming as it supports structured data (with keys and values). It's much harder to parse as it has special syntax rules but it's equally readable by both humans and machines. Converting between these formats makes it easier to work with data in systems where JSON is the standard data format. The conversion process starts with setting the column delimiter symbol and the quotation symbol. For TSV the delimiter is usually a tab "\t" but this application also supports commas, semicolons, pipes, and other symbols. The quotation symbol is the standard double quotes (") but it can also be adjusted to single quotes or other symbols. In the options, you can also specify a comment symbol (usually "#") to identify comment lines to skip. Then, you can enable or disable the "Treat First Row as Headers" option. When enabled, TSV is converted to a JSON array with nested objects, using the headers from the first row as object keys. If headers are disabled, TSV becomes a JSON array with nested arrays, where the values of tab-separated rows become sub-arrays. The "Ignore Empty Lines" option excludes empty lines from the resulting JSON, and the "Detect Data Types" option avoids quoting numeric and boolean values. Additionally, you can pretty-print the output JSON – you can use two spaces or one tab for indentation, or disable indentation altogether to create a minified JSON file. For reverse data conversion, you can use our Convert JSON to TSV tool. Json-abulous!

Convert TSV to JSON examples

Click to use
Convert a Simple TSV to JSON
In this example, we convert a simple TSV file with three tab-separated columns into an array of JSON objects. We activate the "Treat First Row as Headers" option, which creates an array of objects. Each object has three keys corresponding to the column names found on the first row of the input TSV data.
a b c 1 2 3 4 5 6
[ { "a": "1", "b": "2", "c": "3" }, { "a": "4", "b": "5", "c": "6" } ]
Required options
These options will be used automatically if you select this example.
Character used to separate columns in your TSV file.
Character used to quote values in your TSV file.
Character that marks the beginning of comment lines. Rows starting with this symbol will be ignored during conversion.
Enable this option if the first row of your TSV file contains column names. These names will be used as keys of the JSON objects.
Exclude empty lines from being converted.
Don't quote numerical and boolean values in the output JSON.
Output JSON with one tab for each level of indentation.
Turn TSV to JSON without Headers
In the input of this example, we load a TSV with three unnamed columns, two tab-separated rows, and one comment. In the options, we specify that the comments start with the symbol "#" and, as a result, all lines starting with "#" are skipped during the conversion. In the output, we get a JSON array of two other arrays, where each subarray represents a row in the TSV.
Square Triangle Circle Cube Cone Sphere #Oval
[["Square","Triangle","Circle"],["Cube","Cone","Sphere"]]
Required options
These options will be used automatically if you select this example.
Character used to separate columns in your TSV file.
Character used to quote values in your TSV file.
Character that marks the beginning of comment lines. Rows starting with this symbol will be ignored during conversion.
Enable this option if the first row of your TSV file contains column names. These names will be used as keys of the JSON objects.
Exclude empty lines from being converted.
Don't quote numerical and boolean values in the output JSON.
Output JSON as a single line of text for minimal size.
Transform TSV to JSON with Headers
In this example, we transform TSV data with headers into a JSON array of objects and, additionally, we automatically detect JSON data types. As we're using the headers, the first row of TSV data ("item", "material", "quantity") becomes the JSON object keys, and the subsequent rows become JSON object values. As we're detecting JSON data types, the numeric values don't get quoted in the output JSON. Additionally, we skip empty lines during the conversion process.
item material quantity Hat Wool 3 Gloves Leather 5 Candle Wax 4 Vase Glass 2 Sculpture Bronze 1 Table Wood 1 Bookshelf Wood 2
[ { "item": "Hat", "material": "Wool", "quantity": 3 }, { "item": "Gloves", "material": "Leather", "quantity": 5 }, { "item": "Candle", "material": "Wax", "quantity": 4 }, { "item": "Vase", "material": "Glass", "quantity": 2 }, { "item": "Sculpture", "material": "Bronze", "quantity": 1 }, { "item": "Table", "material": "Wood", "quantity": 1 }, { "item": "Bookshelf", "material": "Wood", "quantity": 2 } ]
Required options
These options will be used automatically if you select this example.
Character used to separate columns in your TSV file.
Character used to quote values in your TSV file.
Character that marks the beginning of comment lines. Rows starting with this symbol will be ignored during conversion.
Enable this option if the first row of your TSV file contains column names. These names will be used as keys of the JSON objects.
Exclude empty lines from being converted.
Don't quote numerical and boolean values in the output JSON.
Output JSON with two spaces for each level of indentation.
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&char-delimiter=%5Ct&char-comments=%23&char-quote=%22&convert-headers=true&convert-skip-empty=false&convert-dynamic-types=false&formatting-tabs=true
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 convert JavaScript data to a JSON string.
Quickly convert a JSON string to JavaScript data.
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 markup.
Quickly convert a 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 file to a CSV file.
Quickly convert CSV data to JSON data.
Quickly convert a JSON structure to binary JSON encoding.
Quickly convert JSON to a PNG, GIF, JPG, or BMP image.
Quickly create a screenshot from JSON code.
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.
Quickly extract keys from objects in JSON data.
Quickly extract values from objects in JSON data.
Quickly reduce the nesting level of an array of arrays.
Quickly create a single-level JSON object from nested JSON objects.
Quickly rewrite JSON strings, keys, and values using escape codes.
Quickly obfuscate a JSON data structure.
Quickly remove certain information from a JSON data structure.
Quickly display detailed information about a JSON data structure.
Quickly convert a JSON file to properties file.
Quickly convert a properties file to a JSON file.
Coming soon These json tools are on the way
Find JSON Keys/Values
Find keys and/or values that interest you in a JSON file.
Convert JSON to a List
Create a text list from a JSON array or object.
Convert a List to JSON
Create a JSON array from a text list.
Convert JSON to Form Data
Generate HTTP form data from a JSON object.
Convert Form Data to JSON
Generate JSON object from HTTP form data.
Convert JSON to HTML
Create a HTML table from keys and values of a JSON object.
Convert JSON to CSON
Convert a JSON file to a CSON file.
Convert CSON to JSON
Convert a CSON file to a JSON file.
Convert JSON to TOML
Convert a JSON config to a TOML config.
Convert TOML to JSON
Convert a TOML file to a JSON file.
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 JSONL
Convert a JSON file to a JSONL file.
Convert JSONL to JSON
Convert a JSONL file to a JSON file.
Convert BSON to JSON
Convert binary JSON data structure (BSON) to JSON.
Convert JSON to UBJSON
Convert a JSON file to a universal binary JSON (UBJSON).
Convert UBJSON to JSON
Convert universal binary JSON (UBJSON) to regular JSON.
Convert JSON to Message Pack
Serialize JSON data to binary MessagePack format.
Convert Message Pack to JSON
Unserialize binary MessagePack to a JSON struct.
Convert JSON to Protobuf
Serialize JSON data to binary Protobuf format.
Convert Protobuf to JSON
Unserialize binary Protobuf to a JSON struct.
Convert JSON to a LaTeX Table
Generate a LaTeX table from a JSON object.
Convert JSON to INI
Convert a JSON data file to an INI configuration file.
Convert INI to JSON
Convert an INI configuration file to JSON data file.
Truncate JSON
Loop over JSON structure and truncate all values or keys.
Find JSON Depth
Find the nesting depth of a JSON data structure.
Convert JSON to a 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.
Sort JSON Object Keys
Lexicographically sort the order of JSON object keys.
Swap JSON Keys with Values
Exchange keys with values in a JSON file.
Create a Random JSON Array
Create a JSON array with random values.
Create a Random JSON Object
Create a JSON object with random keys and values.
Randomize a JSON Array
Randomly change the positions of array elements.
Randomize a JSON Object
Randomly change the order of key, value pairs.
Add Spacing to JSON
Add random spaces and newlines in a JSON file.
Tokenize JSON
Tokenize a JSON data structure.
Remove JSON Syntax
Remove all JSON syntax and leave just the values.
Change JSON Syntax
Change curly braces, commas, and quotes to other symbols.
Fix Quotes in JSON
Fix incorrectly quoted (usually single quote) keys and values.
Use Single Quotes in JSON
Make all keys and values in a JSON to be single-quoted.
Use Double Quotes in JSON
Make all keys and values in a JSON to be double-quoted.
Generate FakeSON
Create JSON that looks real but is fake (FakeSON).
Run jq
Execute a jq query on a JSON data structure.
Filter JSON
Filter keys and values that match a pattern.
Split a String into a JSON Array
Create a JSON array from a string.
Group a JSON Array
Create groups of JSON array items.
Merge JSON Arrays
Merge two or more JSON arrays together.
Compare JSON Arrays
Find differences in two or more JSON arrays.
Merge JSON Objects
Merge two or more JSON objects together.
Damage JSON
Introduce errors in a JSON data structure.
Fix JSON
Try to fix a damaged JSON to the best of our ability.
Create JSON Art
Convert images to valid JSON strings that look like ASCII art.
Visualize a JSON Structure
Create an abstract visualization of JSON's complexity.