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

Convert TSV to JSON

Copy cells from a spreadsheet, paste them here and get a JSON array of records using the header row for keys. Everything runs in your browser, so your data stays private.

  • No account needed
  • Nothing uploaded
  • Paste straight from Excel
  • Typed numbers and booleans
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: TSV → OUT: JSON
How was TSV to JSON?
How it works

TSV to JSON in three steps

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

  1. STEP 01

    Paste or open your TSV

    Copy cells in Excel or Google Sheets and paste. Or open a .tsv, .tab, .csv or .txt file.

  2. STEP 02

    Set the options

    Say if the first row is a header, whether numbers and true/false become real values, and whether empty cells become null.

  3. STEP 03

    Copy or download the JSON

    You get an array of objects, indented the way you choose.

What you get

What TSV to JSON does, and what it doesn't

We'd rather tell you up front than surprise you after the download.

What you get

  • Straight from a spreadsheetCells copied from Excel, Numbers or Sheets arrive tab-separated, which this tool reads directly.
  • Typed values42 and true can become a number and a boolean. Values with leading zeros, such as 007, stay text.
  • Null for empty cellsKeep blanks as empty strings or turn them into null.
  • Nested objects from dotted headersHeaders like address.city can be rebuilt into nested JSON.
  • Tidy headersBlank headers become column_3, and repeated ones become name_2, so no value is overwritten.

Good to know

  • Tabs onlyCommas are not treated as separators here. For comma-separated data use CSV to JSON.
  • Unclosed quotesA quote that never closes is reported with its row. Check the data in the CSV viewer.
  • Dates stay textDate strings are not converted. They remain strings in the JSON.
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 TSV to JSON

Turn a sheet into app data

Copy a table of values and get JSON for a front end.

Create test fixtures

Build JSON from a spreadsheet of cases.

Prepare a NoSQL import

Convert rows to documents.

Share data with developers

Paste a table, send the JSON.

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 paste works so well

When you copy a range of cells, spreadsheets put tab-separated text on the clipboard: tabs between columns, line breaks between rows. That is TSV. Because tabs rarely appear inside real values, parsing is reliable.

The first row becomes the JSON keys. Each following row becomes one object.

Getting the types you want

Spreadsheets show formatted values: a date cell might paste as 3/1/2024 and a percentage as 15%. The tool sees only the text. Plan for that:

  • Keep typed values on for plain numbers and booleans.
  • Format date columns as ISO text (2024-03-01) before copying.
  • Leave IDs and zip codes as text so leading zeros survive.
  • Use the nesting option with headers like user.name.
  • Go the other way with JSON to TSV.

A realistic example: TSV to JSON

Copy three columns named id, name and active, with a few rows. Pasting gives an array of objects where id is a number, name is text and active is a boolean if the cells contain true or false. Add a header such as address.city and switch on nesting to build nested objects.

FAQ

Questions, answered

How do I convert tab-separated data to JSON?

Paste it, check the header setting, and copy the JSON.

Can I paste cells from Excel or Google Sheets?

Yes. Copied cells are tab-separated, which is exactly what this tool expects.

Is a copied spreadsheet range uploaded when I convert it?

No. The pasted cells are parsed by script in your browser tab and are not sent anywhere.

Why did my postal code stay as text?

Leading zeros are significant in codes, so such values stay text. 007 and 02134 come through unchanged.

Can blank cells be written as null?

Yes. The empty-cells option writes null instead of an empty string, which suits databases and APIs that treat them differently.

Does copy and paste from a spreadsheet work on mobile?

Often yes. Copy a range in the Sheets or Excel app, then paste into this page in a mobile browser.