How to Convert JSON to TSV
Sometimes the fastest way to get JSON into a spreadsheet is tab-separated values — paste it into Excel or Google Sheets and it lands in neat columns instantly, no import dialog needed. This converter makes that TSV for you. It reads your JSON array of objects, unions the keys across every record so different fields still line up, and writes one tab-separated row per object with the keys as an optional header. Tabs and line breaks inside values are replaced with spaces so columns never shift, and nested objects are kept as compact JSON. Everything runs in your browser, so nothing is uploaded.
Paste your JSON
Paste an array of objects or load the sample; it's parsed locally with nothing uploaded.
Choose the header
Include the keys as a header row, or output data rows only.
Copy or download
Grab the TSV with one tap or save it as a .tsv file — or paste straight into a sheet.
JSON vs TSV — What's the Difference?
JSON — JavaScript Object Notation
A structured, hierarchical format built from objects and arrays with real data types. It's the standard for APIs and config because it maps onto programming data structures, but it isn't something a spreadsheet reads directly.
TSV — tab-separated values
A flat, plain-text grid where tabs separate columns. Because tabs rarely appear inside data, values can contain commas and spaces without quoting, and the format pastes perfectly into spreadsheets. Converting JSON to TSV flattens your records into a table you can drop straight into Excel.
Common Use Cases
API into a spreadsheet
Turn a JSON response into TSV and paste it straight into Excel or Google Sheets.
Quick analysis
Move JSON records into a sheet to sort, filter and chart them in seconds.
Data exports
Produce tab-delimited files for tools that prefer TSV over CSV.
Handling messy text
Use TSV when your values contain commas that would complicate CSV.
Bulk editing
Flatten JSON to a grid, edit in a spreadsheet, then convert back.
Reporting
Drop JSON results into a sheet-based report or dashboard.
Migrations
Move JSON data into systems that ingest tab-separated files.
Quick inspection
See a JSON array as an aligned table to understand its shape.
Tips & Best Practices
Use an array of objects
Each object becomes a row and each key a column — the cleanest input for a table.
Paste directly into sheets
TSV pastes into Excel and Google Sheets with perfect columns — no import step needed.
Keep the header on
A header row of keys makes the resulting sheet self-documenting.
Flatten nested data first
Deeply nested values are shown as JSON text; flatten them beforehand for separate columns.
Prefer TSV for comma-heavy text
If your values contain many commas, TSV avoids the quoting that CSV would need.
Troubleshooting
It says expected an array of objects
The tool needs a JSON object or an array of objects. A bare array of numbers or strings has no columns to build from.
A cell shows JSON text
That value was a nested object or array, kept as compact JSON so nothing is lost. Flatten it first for separate columns.
Some cells are empty
Those records didn't have that key. Columns are unioned across all objects, so missing values appear as empty cells.
Columns shift when pasted
A value likely contained a tab or newline. The tool replaces those with spaces automatically; if you edited the output, remove any raw tabs.
Frequently Asked Questions
How do I convert JSON to TSV for free?
Paste your JSON array of objects above and tab-separated values appear instantly. Copy it or download a .tsv file — free, no signup.
What JSON shape does it expect?
An array of objects works best, where each object is a row. A single object is treated as one row too.
What if my objects have different keys?
Every key across all objects becomes a column, and any record missing a key gets an empty cell, keeping the table aligned.
Can I paste the result into Excel?
Yes. Tab-separated values paste directly into Excel, Google Sheets and Numbers with each value in its own column.
Can I omit the header row?
Yes. Turn off the header option to output only the data rows.
How are nested objects handled?
Nested objects and arrays are kept as compact JSON inside the cell so no information is lost.
What about tabs or newlines inside values?
They're replaced with spaces so they can't create extra columns or rows and break the alignment.
Why choose TSV over CSV?
TSV avoids quoting issues when values contain commas, and it pastes into spreadsheets without an import dialog.
Do object keys become the header?
Yes, when the header option is on the unioned keys form the first row.
Is my data sent to a server?
No. Everything happens inside your browser, so your data never leaves your device.
Can I download the result?
Yes. Save the output as a .tsv file, or copy it straight to your clipboard.
How large a dataset can it handle?
It comfortably converts arrays with many thousands of records, all in your browser.
Does it preserve empty values?
Yes. Empty or missing values become empty cells so your columns stay aligned.
Does it work on phones?
Yes, in any modern browser on Windows, Mac, Android or iPhone with nothing to install.
Is this converter really free?
Completely free, forever — no account, no ads and no premium wall.
100% free · No signup · Processed in your browser · Data never sent
Last updated: August 2026 · FlipMyFormat JSON to TSV Converter
Written and maintained by the FlipMyFormat team · Runs entirely in your browser