⇄

JSON to TSV Converter

Convert JSON data to TSV (Tab-Separated Values) format

File Converters

Tip: Paste an array of objects or a single object. TSV uses tabs instead of commas for separation.

Runs in your browser

Input JSON

Convert JSON to TSV in your browser

Paste JSON, open a .json file or drop it on the input window, and the tab-separated table appears as you type. Each object becomes a line, each key a column, and the first line is the header. Copy the result or download it as a .tsv file.

TSV is the shortest way from JSON to a spreadsheet: copy the output, click the first cell in Excel or Google Sheets and paste. Every value lands in its own cell, with no import dialog.

JSON to TSV example

Real output for two user records. Nested keys turn into dot-path columns, and the missing second tag leaves the last cell empty:

users.json

[
  {"id": 101, "name": "Ivo Marsh", "address": {"city": "Lisbon", "zip": "1100-148"}, "tags": ["admin", "beta"]},
  {"id": 102, "name": "Lena Fisk", "address": {"city": "Oslo", "zip": "0150"}, "tags": ["beta"]}
]

users.tsv

id	name	address.city	address.zip	tags.0	tags.1
101	Ivo Marsh	Lisbon	1100-148	admin	beta
102	Lena Fisk	Oslo	0150	beta

Columns from nested keys

Done for you

Nested objects become columns like address.city, and array items columns like tags.0
The header collects the keys of all objects, so a key that appears only in the last object still gets a column
An object whose only key holds an array, such as {"users": [...]}, is read as that list of rows
null and empty objects or arrays become empty cells

Not done

Make one line per item of a nested array: the items go side by side in numbered columns
Let you pick or reorder columns: every key is a column, in the order it first appears
Keep JSON types: true and 42 become plain text in the TSV

Tabs, commas and quoted cells

Only a tab separates two cells, so commas in names, addresses or prices are written as they are, with no quotes. That is why TSV pastes cleanly into a sheet when the same data as CSV would need an import step.

A value that holds a tab, a double quote or a line break is put in double quotes, and a quote inside it is written twice. Spreadsheets read such a cell back as one value.

Need the JSON back?

The TSV to JSON converter turns copied spreadsheet rows back into an array of objects.

JSON to TSV questions

Paste the JSON here, click Copy on the TSV output and paste into the first cell of an empty sheet. The columns and rows fill in by themselves.

Yes. A single object becomes one line under the header. An array of plain values, such as a list of names, becomes one column called value.

They contain a tab, a double quote or a line break. Without the quotes the cell would split into two columns or two rows.

The JSON to CSV converter builds the same columns and writes them comma-separated.

No. Converting runs in your browser, and an opened file is read there too.