TSV to JSON Converter
Copy cells from a spreadsheet, paste them here, and get a JSON array — the clipboard format is already tab-separated.
Your data stays on your device
Input — TSV
- characters
- 0
- lines
- 0
- size
- 0 B
Output — JSON
- characters
- 0
- lines
- 0
- size
- 0 B
Options
Off by default: it would turn the identifier 007 into the number 7.
About this tool
When you copy a range of cells, every major spreadsheet application puts tab-separated text on the clipboard. That means you can go from a selection in Sheets to structured JSON without exporting a file at all.
The first row becomes the object keys by default. Optional type inference converts numeric and boolean-looking cells, and empty cells can become empty strings, nulls, or be omitted entirely.
How to use this tool
- Select a range in your spreadsheet and copy it.
- Paste directly into the input panel — the clipboard content is already tab-separated.
- Choose header handling and whether to infer types.
- Press Convert and copy the JSON array.
Key features
- Direct paste from Excel, Google Sheets, Numbers and LibreOffice
- First row as keys, or generated column names
- Optional number and boolean inference
- Configurable handling of empty cells: empty string, null, or omitted
- CRLF and LF line endings both accepted
- Row and column counts reported after conversion
Example
Input — TSV
name score
Ada 91
Grace 97Output — JSON
[
{ "name": "Ada", "score": "91" },
{ "name": "Grace", "score": "97" }
]Good to know
- Cell formatting, formulas and merged cells do not survive the clipboard; you get the displayed values only.
- Cells containing newlines break the row structure, since TSV has no quoting mechanism.
- Type inference is heuristic and off by default to protect identifiers with leading zeros.
Frequently asked questions
Why does pasting from a spreadsheet just work?
Because the clipboard payload for a cell range is tab-separated text. No export, no file, no import dialog.
What if my data has no header row?
Turn off header handling and columns are named column1, column2 and so on.
How are empty trailing columns treated?
They are preserved as empty values so every object keeps the same key set, which is usually what downstream code expects.
Can I convert only some columns?
Select only those columns in the spreadsheet before copying. The tool converts exactly what you paste.
Your data stays on your device
Your data is processed locally in your browser and is not uploaded to our server. This page keeps working after you go offline, because there is nothing to send.