Data and JSON tools Free · No sign-up · No upload

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
Your data
  • Runs on your device. Files are never uploaded.
  • Free and unlimited. No sign-up, no watermark.
Private: processed in your browserNo upload waitIN: JSON → OUT: TSV
How was JSON to TSV?
How it works

JSON to TSV in three steps

No account, no email, no waiting for an upload.

  1. STEP 01

    Start with your JSON

    Use a list of objects, or an object that wraps one list.

  2. STEP 02

    Choose the nesting and safety options

    Decide how nested values are handled and whether to guard against spreadsheet formulas.

  3. STEP 03

    Copy the TSV

    Paste it straight into a spreadsheet, or download the .tsv file.

What you get

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.
Private by design

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 device→Their server→Your device

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

Your device does all the work

The tool loads into your browser once, then works on your file locally. Nothing is sent, so nothing can leak.

Made for real work

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.

Compare

Mediaextractr vs typical upload tools

MediaextractrPrivateTypical upload tools
Your file is uploadedNeverYes
Sign-up neededNoOften, after a few files
Daily file limitNoneOften 1–2 free files
WatermarkNeverSometimes
Wait for upload & downloadNoYes
Speed on very large filesDepends on your deviceDepends 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.

FAQ

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.