JSON to TSV converter
The result appears here.
Convert
Your document never leaves the browser.
JSON to TSV, ready to paste into any spreadsheet — in your browser.
Paste JSON and get tab-separated values: the format spreadsheets read as cells when you paste, and that databases and command-line tools import without guessing.
A tab almost never appears inside real data, so TSV needs less quoting than CSV and survives a paste into Google Sheets, Excel or Numbers as a grid. It is the same table and the same cell rules as JSON to CSV, with a tab as the one delimiter.
Where CSV has a regional problem — Excel in much of Europe expects semicolons, because the comma is the decimal mark there — TSV has none. A tab means the same thing in every locale, which makes it the safer format for a file that crosses borders or for data headed into a database loader, cut, awk or a pandas read_csv with sep set to a tab.
The JSON, with commas in its values
[
{ "id": 1, "city": "London, UK" },
{ "id": 2, "city": "Helsinki, FI" }
]The TSV it gives, at the default settings
# id city
0 1 London, UK
1 2 Helsinki, FIRows with a nested array and a null
[
{ "id": 1, "city": "London", "tags": ["uk"] },
{ "id": 2, "city": null }
]The TSV it gives, at the default settings
# id city tags
0 1 London "[""uk""]"
1 2 Table
The rows are the array or object the Table view opens on, stepping into a single wrapping key.
Table
Columns are every key the rows use, in first-seen order, up to 50, with a notice when more were left out.
Table
Strings as their characters, numbers with their exact digits, nested values as compact JSON, and null or a missing key as an empty cell.
Table
A value holding a tab, a quote or a line break is quoted, so the grid keeps its shape.
Header row and Row labels work as they do for CSV, and are shared with the Table view’s Export card. The download is written with a byte-order mark and CRLF line endings; Copy gives the same text without the mark.
Press ⇄ and the TSV becomes the source, read back with the same rules as CSV to JSON: numbers that are exactly JSON numbers become numbers, true and false become booleans, and an empty cell becomes null.
The first example’s JSON, with Row labels off
id city
1 London, UK
2 Helsinki, FIThe conversion runs in your browser, in the same engine the editor uses. The document is never uploaded, never logged and never leaves your machine — there is no server to send it to. Once the page has loaded it keeps working with the connection off.
Going the other way?
TSV for pasting into a spreadsheet or feeding a tool that splits on tabs; CSV for a file someone will double-click in Excel.
Yes — press ⇄, or choose TSV under From.
Yes. Numbers are copied as written, never through a floating-point value.