Convert JSON to TSV
Turn a JSON list of records into tab-separated values with a header row. It pastes cleanly into spreadsheets, and your data stays in your browser.
- Free, no strings
- Works on your own device
- Pastes into spreadsheets
- Formula guard option
- Runs on your device. Files are never uploaded.
- Free and unlimited. No sign-up, no watermark.
JSON to TSV in three steps
No account, no email, no waiting for an upload.
- STEP 01
Start with your JSON
Use a list of objects, or an object that wraps one list.
- STEP 02
Choose the nesting and safety options
Decide how nested values are handled and whether to guard against spreadsheet formulas.
- STEP 03
Copy the TSV
Paste it straight into a spreadsheet, or download the .tsv file.
What JSON to TSV does, and what it doesn't
We'd rather tell you up front than surprise you after the download.
What you get
- Tab-separated, header firstEvery key found in any record becomes a column, then one row per record.
- Easy to pasteSpreadsheets split tab-separated text into cells automatically when you paste.
- Nested valuesFlatten nesting into dotted columns, keep lists as JSON text, or keep all nested values as text.
- Formula guardOptionally escape cells that start with =, +, - or @.
- Careful quotingValues that contain tabs, quotes or line breaks are quoted so the columns stay aligned.
Good to know
- Tabs inside valuesA value that contains a tab is quoted, which not every tool unquotes. Check the result in your target.
- Spreadsheet auto-changesExcel and Sheets may reformat long numbers and dates on paste. Format the columns as text first if that matters.
- Prefer commas?Use JSON to CSV for comma-separated output.
Your data never leave your device
The tool runs inside your browser instead of on our servers, so there is nothing to upload, store or delete afterwards.
Typical online tool upload
Your file travels over the internet, sits on someone else's computer for a while, and you wait for the upload and the download.
Mediaextractr no upload
The tool loads into your browser once, then works on your file locally. Nothing is sent, so nothing can leak.
When people use JSON to TSV
Paste API data into a sheet
Copy, paste into Google Sheets, and start filtering.
Prepare a bulk import
Many tools accept tab-separated files.
Use in the command line
TSV works well with cut, awk and similar tools.
Share data with non-developers
Give them something they can open without code.
Mediaextractr vs typical upload tools
| MediaextractrPrivate | Typical upload tools | |
|---|---|---|
| Your file is uploaded | Never | Yes |
| Sign-up needed | No | Often, after a few files |
| Daily file limit | None | Often 1–2 free files |
| Watermark | Never | Sometimes |
| Wait for upload & download | No | Yes |
| Speed on very large files | Depends on your device | Depends on their servers |
Why TSV instead of CSV
Tab characters rarely appear inside real data, while commas appear all the time in names and addresses. That makes TSV easier to parse with simple tools and safer to paste into spreadsheets.
Both formats describe the same table. CSV is more widely accepted by import wizards, TSV by copy and paste.
Getting a clean paste
Spreadsheets sometimes surprise you, so a few precautions help:
- Turn on the formula guard if the data includes text from users.
- Check the first rows before you paste over existing data.
- Reverse the conversion with TSV to JSON.
- Convert tab to comma with CSV to TSV and its relatives, or use JSON to Excel for a real workbook.
Pasting into Excel or Sheets
Click the first cell where the data should start, then paste. Cells fill to the right and downward. Long numeric IDs may display in scientific notation: select the column and set its format to text before you paste. Google Sheets generally keeps leading zeros if the column is already formatted as plain text.
Questions, answered
How do I convert JSON to TSV?
Paste a JSON list of records and copy the tab-separated result.
Does converting to TSV upload my records?
No. The tab-separated text is produced by script in this tab, so the data never leaves your device.
Can I paste the result into Excel or Google Sheets?
Yes. Tab-separated text is split into cells automatically.
How are nested values handled?
By default, nested keys become dotted column names. You can also keep them as JSON text.
Why would I turn on the formula guard?
Cells starting with =, +, - or @ can be run as formulas when a spreadsheet opens the file. The guard prefixes them so they stay plain text.
Can I paste the result into a spreadsheet app on my phone?
Yes. Copy the text, then paste it into a cell in the Sheets or Excel app.