TSV to JSON Converter
Copy cells from Excel or Google Sheets, paste them here, and get JSON instantly. The first row becomes the keys.
Runs in your browser — your code is never uploaded. Tip: drop a file on the input box, or press Ctrl + Enter.
How to Convert TSV to JSON
Spreadsheet cells to JSON in three steps.
Copy Your Cells
Select the cells in Excel or Google Sheets (with the header row) and copy them.
Paste Here
Paste into the left box, or upload a .tsv file. JSON appears instantly.
Copy or Download
Copy the JSON or download data.json.
Paste from
Excel & Google Sheets
Keys
From the header row
Types
Numbers & booleans
Privacy
Runs in your browser
Works on
Phone & computer
Price
100% free
TSV to JSON Example
Copied spreadsheet cells and the JSON you get.
| Spreadsheet (TSV) | JSON |
|---|---|
id⇥name1⇥Asha | [{"id": 1, "name": "Asha"}] |
TRUE / true | true (lowercase true/false only) |
00123 | "00123" — kept as text |
| Blank cell | "" (empty text) |
| Header unticked | Array of arrays with every row |
What Can You Use It For?
Popular ways people use TSV to JSON Converter.
Sheets to Apps
Move product lists, prices or menus from a sheet into your app.
Translations
Turn a translation sheet into JSON language files.
Test Data
Create JSON fixtures from a spreadsheet.
Bulk Uploads
Prepare data for APIs and CMS imports.
Tips for the Best Result
- Include the header row when you copy so the keys are named correctly.
- Use Array of arrays if you only need the raw grid.
- For comma-separated files, use CSV to JSON.
- Going back to a sheet? Use JSON to TSV.
Frequently Asked Questions
Quick answers about TSV to JSON Converter.
Tab-separated values: a plain-text table where a tab separates columns. When you copy cells from Excel or Google Sheets, you get TSV.
Select the cells in Excel (with the header row), copy, and paste them here. The JSON is created instantly.
Yes, when First row is header is ticked. Empty or duplicate headers are renamed automatically.
Yes, plain numbers become JSON numbers and true/false become booleans. Values with leading zeros stay text.
Yes, if the cell is wrapped in quotes — which Excel and Google Sheets do automatically when you copy.
Yes. Choose Array of arrays under Output.
No. Everything runs in your web browser, so your code and data never leave your device.
Yes — 100% free, with no sign-up and no limits.
Related Free Tools
Ready to Use TSV to JSON Converter?
Scroll up and get your result in seconds. 100% free, no sign-up needed.
Start Now