Convert JSON to TSV Online

Convert JSON arrays to tab-separated values — paste directly into Google Sheets, Excel, or any spreadsheet without importing a CSV.

JSON → TSV

Free JSON to TSV converter. Convert JSON arrays to tab-separated values for direct paste into spreadsheets. Handles nested objects and inconsistent keys. Works in your browser.

100% local — no uploads

Input · JSONUpload file

Output will appear here

How to use the JSON → TSV

Paste or upload your JSON data
Paste text directly into the input box, drag and drop a file onto it, or click "Upload file" to browse. Conversion starts instantly on paste — no button click required.
Configure options (optional)
Open the Options panel to customise delimiter, headers, nested-object flattening, and more. Use the Field Selector to pick exactly which columns appear in the output.
Copy or download your TSV
Click Copy to grab the result, or Download to save the file. Everything runs locally in your browser — no data ever leaves your device.

Frequently Asked Questions

Is my data safe?: Yes. Every conversion runs entirely inside your browser. No data is ever transmitted to a server. The tool works offline once loaded.
What is the maximum file size?: There is no hard limit. Files under 1 MB convert instantly. Files 1–10 MB show a progress indicator. Files over 10 MB prompt a warning and run in a background thread to keep the browser responsive.
Why does my JSON fail to parse?: Common causes are trailing commas, single-quoted strings, unquoted keys, or missing closing brackets. The converter auto-repairs many of these and tells you exactly what it changed.
Can I convert multiple files at once?: The tool handles one file at a time. For bulk conversion, consider the csvjson CLI or API.

Related Converters

How it works

Step 1

Tab delimiter eliminates quoting complexity

CSV requires quoting any field that contains a comma. TSV uses tabs, which almost never appear in real data — so fields rarely need quoting. The output is cleaner and pastes into spreadsheets without misalignment.

Step 2

Direct paste into any spreadsheet

Copy the TSV output and paste it into Google Sheets, Excel, or Numbers. The application splits on tabs automatically and fills cells correctly — no import wizard, no delimiter dialog.

Step 3

Inconsistent JSON keys are handled

If different records have different fields, the converter collects the union of all keys and fills missing cells with empty strings — so every row has the same column count.

Example

API response pasted directly into a Google Sheet for analysis

Input

[
  { "user": "alice", "plan": "pro", "mrr": 49 },
  { "user": "bob",   "plan": "free", "mrr": 0 },
  { "user": "carol", "plan": "pro", "mrr": 49 }
]

Output

user	plan	mrr
alice	pro	49
bob	free	0
carol	pro	49

Copy the output and paste into cell A1 of any spreadsheet. Columns split automatically on the tab characters.

Edge cases, handled

Fields containing tabs

If a JSON string value contains a literal tab character, it is replaced with a space in the TSV output to prevent column misalignment.

Nested objects

Nested objects are serialized as JSON strings in the cell value. Flatten the JSON first if you need nested fields as separate columns.

Frequently asked questions

When should I use TSV instead of CSV?

Use TSV when you're pasting data directly into a spreadsheet — it's the format most spreadsheet apps use for clipboard paste. Use CSV when you're writing to a file that will be imported via a data pipeline, database importer, or pandas, where comma is the universal default.

Why does my spreadsheet show everything in one column when I paste CSV?

Spreadsheets split pasted text on tabs by default, not commas. If you paste CSV, the commas stay in the cell and everything lands in column A. TSV pastes correctly without any import dialog.

Can I open a TSV file in Excel?

Yes. Rename it with a .tsv or .txt extension and Excel opens an import wizard that detects tab delimiters automatically. Or use the Data > From Text/CSV import to specify the delimiter explicitly.

What's the difference between TSV and a tab-delimited CSV?

Functionally identical. TSV is just the common name for a file where the delimiter is a tab character. Some tools call it 'tab-delimited CSV', others call it TSV. The format is the same.