Convert JSON to TSV

World's simplest json tool

Free online JSON to TSV converter. Just load your JSON in the input field and it will automatically get converted to TSV. In the tool options, you can choose whether to use JSON object keys as TSV column headers, customize the TSV field separator (tab by default) and field quoting character (double quotes by default), and optionally enable the quoting of all fields. Created for developers by developers from team Browserling.

announcement the ultimate collection of tools!

We're joining all our tools into OnlineTools.com that will offer the ultimate collection of tools. Check it out!

A link to this tool, including input, options and all chained tools.

Input JSON

Output TSV

Can't convert.

An error has occured.

Convert JSON to TSV options

Generate Headers

Generate Column Headers Convert JSON object keys or the elements of the first JSON array into TSV data headers.

TSV Field Separator

Separator The character that separates fields in the output TSV file. To use tabulation, enter the character "\t".

TSV Field Quoting

Quote Character The character used to quote fields in the output TSV file.

Wrap All Fields in Quotes Add quotes around all output TSV values.

What is a Convert JSON to TSV?

learn more about this tool

This tool converts JavaScript Object Notation (JSON) files to Tab Separated Values (TSV) files. JSON and TSV are two common data formats with different purposes. JSON is a human-readable format for exchanging data between systems and applications. It's structured as key-value pairs, similar to a dictionary, making it easy for both humans and machines to understand. TSV is a text-based format for storing tabular data, where each row of the table is represented by a line of text, and the columns are separated by tabs. It's convenient for exchanging data between programs, as it's easy to parse and import into spreadsheets and other tools. Converting JSON to TSV is helpful when data in JSON format needs to be used in a program supporting only TSV format, such as importing data from a web service into a spreadsheet for further analysis and processing. One of the key features of this tool is the option to use JSON object keys as TSV column headers, simplifying the structure of the resulting TSV file. For example, if the input JSON has an object { "name" : "Allie", "age" : 20 }, then the "name" and "age" JSON keys will be used as TSV column names. Alternatively, if the input JSON is an array, then the elements of the first JSON array will be used as TSV column names. For example, if the input JSON has an array of arrays [ [ "dog", "breed" ], [ "Pepper", "Bulldog" ] ], then the "dog" and "breed" array elements will be used as TSV column names. Additionally, in the tool options, you can specify the TSV delimiter character (by default, it's the tab character "\t"), the quote character (by default, it's the double quote character "), and optionally quote every value in the TSV file. To convert TSV back to JSON, you can use our Convert TSV to JSON tool. Json-abulous!

Convert JSON to TSV examples

Click to use

Two-Dimensional JSON Array to TSV

In this example, we transform a simple JSON array containing three sub-arrays into a TSV file. The JSON array contains data about different types of land and water transportation and each sub-array consists of two elements. As a result of the conversion, the first sub-array is turned into the TSV header row and the elements of subsequent sub-arrays are turned into tab-separated strings, forming a TSV file with two columns and three rows.

[["Land", "Water"], ["Car", "Ship"], ["Truck", "Submarine"]]

Land Water Car Ship Truck Submarine

Required options

These options will be used automatically if you select this example.

Generate Column Headers Convert JSON object keys or the elements of the first JSON array into TSV data headers.

Separator The character that separates fields in the output TSV file. To use tabulation, enter the character "\t".

Quote Character The character used to quote fields in the output TSV file.

Wrap All Fields in Quotes Add quotes around all output TSV values.

Convert JSON Objects to Quoted TSV

In this example, we convert JSON objects containing educational data about programming languages into a TSV file. As we have disabled the option to generate TSV column headers, the JSON object keys do not appear in the output TSV and only the JSON object values appear in the output TSV. Additionally, we have activated the global field quoting option, making all the values in the output TSV to be wrapped in double quotes.

[ { "lang": "Python", "difficulty": "Easy" }, { "lang": "JS", "difficulty": "Medium" }, { "lang": "HTML", "difficulty": "Easy" }, { "lang": "Ruby", "difficulty": "Medium" }, { "lang": "Java", "difficulty": "Medium" }, { "lang": "C++", "difficulty": "Hard" }, { "lang": "C", "difficulty": "Hard" } ]

"Python" "Easy" "JS" "Medium" "HTML" "Easy" "Ruby" "Medium" "Java" "Medium" "C++" "Hard" "C" "Hard"

Required options

These options will be used automatically if you select this example.

Generate Column Headers Convert JSON object keys or the elements of the first JSON array into TSV data headers.

Separator The character that separates fields in the output TSV file. To use tabulation, enter the character "\t".

Quote Character The character used to quote fields in the output TSV file.

Wrap All Fields in Quotes Add quotes around all output TSV values.

JSON Keys as TSV Headers

In this example, we convert a JSON file into a TSV file with column headers. The column headers are generated from JSON object keys – "city", "density", and "population". They are placed on the top row of the TSV file and just like the rest of TSV are separated by tabs. The headers are also known as column names and they help users to determine what the data in each TSV column represents.

[ { "city": "Berlin", "density": "4,213/km²", "population": "3645495" }, { "city": "Madrid", "density": "5,300/km²", "population": "3223408" }, { "city": "Seoul", "density": "16,000/km²", "population": "9776411" }, { "city": "Tokyo", "density": "6,363/km²", "population": "37115231" } ]

city density population Berlin 4,213/km² 3645495 Madrid 5,300/km² 3223408 Seoul 16,000/km² 9776411 Tokyo 6,363/km² 37115231

Required options

These options will be used automatically if you select this example.

Generate Column Headers Convert JSON object keys or the elements of the first JSON array into TSV data headers.

Separator The character that separates fields in the output TSV file. To use tabulation, enter the character "\t".

Quote Character The character used to quote fields in the output TSV file.

Wrap All Fields in Quotes Add quotes around all output TSV values.

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-json-to-tsv?input=%5B%5B%22Land%22%2C%20%22Water%22%5D%2C%0A%20%5B%22Car%22%2C%20%22Ship%22%5D%2C%0A%20%5B%22Truck%22%2C%20%22Submarine%22%5D%5D&convert-headers=true&char-delimiter=%5Ct&char-quote=%22&convert-quote=false

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!

Highlight JSON Syntax

Quickly color-code the syntax of a JSON file.

Prettify JSON

Quickly beautify a JSON data structure.

Minify JSON

Quickly compress a JSON file.

Stringify JSON

Quickly convert JavaScript data to a JSON string.

Unstringify JSON

Quickly convert a JSON string to JavaScript data.

Validate JSON

Quickly check JSON for errors and report them.

Escape JSON

Quickly escape special JSON characters.

Unescape JSON

Quickly unescape an escaped JSON string.

Convert JSON to XML

Quickly convert a JSON data structure to an XML file.

Convert XML to JSON

Quickly convert an XML file to a JSON data structure.

Convert JSON to YAML

Quickly convert a JSON data structure to a YAML markup.

Convert YAML to JSON

Quickly convert a YAML markup to a JSON data structure.

Convert JSON to TSV

Quickly convert a JSON file to a TSV file.

Convert TSV to JSON

Quickly convert TSV data to a JSON file.

Convert JSON to CSV

Quickly convert a JSON file to a CSV file.

Convert CSV to JSON

Quickly convert CSV data to JSON data.

Convert JSON to BSON

Quickly convert a JSON structure to binary JSON encoding.

Convert JSON to an Image

Quickly convert JSON to a PNG, GIF, JPG, or BMP image.

Convert JSON to Base64

Quickly encode JSON to base64.

Convert Base64 to JSON

Quickly decode base64 to JSON.

URL-encode JSON

Quickly convert JSON to URL-encoding.

URL-decode JSON

Quickly convert URL-escaped JSON back to JSON.

Convert JSON to Plain Text

Quickly convert JSON data to plain text.

Edit and View JSON

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

Extract all values or keys from a JSON object as a flat list.

Extract JSON Keys

Extract all keys from all key-value JSON pairs.

Extract JSON Values

Extract all values from all key-value JSON pairs.

Find JSON Keys/Values

Find keys and/or values that interest you in a JSON file.

Obfuscate JSON

Obfuscate a JSON data structure.

Censor JSON Data

Remove certain information from a JSON data structure.

Hide JSON Strings

Rewrite JSON strings using escape codes and make it hard to read.

Convert JSON to a Screenshot

Create a screenshot from JSON code.

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 Properties

Convert a JSON file to properties file.

Convert Properties to JSON

Convert properties data to JSON data.

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 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 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.

Feedback we'd love to hear from you!

Created with love by

51K

@browserling

Online json tools was created by Browserling — world's first cloud-based cross-browser testing service. Our mission at Browserling is to make make browsers do wonders and to make developers' lives easier. That's why we created this collection of online json utilities. Unlike many other tools websites, we made our tools free, without ads, and with a very simple user interface. Our online json 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 JSONLING to get a discount at Browserling.

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.

By using Online Json 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.