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
- Runs on your device. Files are never uploaded.
- Free and unlimited. No sign-up, no watermark.
TSV to JSON in three steps
No account, no email, no waiting for an upload.
- 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.
- 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.
- STEP 03
Copy or download the JSON
You get an array of objects, indented the way you choose.
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.
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 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.
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 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.
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.