Use the free TSV to JSON Converter below: your data never leaves your browser — all work happens on your device, and nothing is uploaded to any server.
Why TSV Exists, and Why You Need JSON From It
TSV, or tab-separated values, is the quiet sibling of CSV. It rarely gets chosen on purpose: it arrives when you copy cells from a spreadsheet and paste them somewhere, because spreadsheets put a tab between columns and a newline between rows. It also arrives from database exports, log files, and older tools that prefer tabs because tab characters almost never appear inside real data, unlike commas, which appear in names, addresses, and numbers all the time.
JSON is what web applications and APIs consume. So the path from a copied table to a working web page often runs through TSV to JSON: copy the table, paste it here, get JSON, paste it into your code or send it to an API. This tool does that conversion in your browser, with nothing uploaded and no sign-up.
How to Use the Converter
Paste TSV into the input box. The easiest way to get TSV is to select cells in a spreadsheet and copy them: the clipboard already contains tabs and newlines in exactly the format this tool reads. Leave the header option checked if the first row holds column names, and the output becomes a list of objects, one per row. Uncheck it for a plain list of lists. Choose an indent of two or four spaces, press Convert to JSON, and copy or download the result.
Try the sample to see the shape. Three people, three columns, and the output is a tidy JSON array where each person is an object with name, age, and city. That shape drops straight into JavaScript, Python, or any API that accepts a list of records.
How Tabs, Rows, and Missing Values Are Handled
Each line becomes one row, and each tab splits one field from the next. Empty fields are kept as empty strings, so a row with a missing middle value still lines up with the header: the key exists, with an empty value, rather than shifting every later value one column left. That matters, because a shifted column is the classic silent data corruption in table conversions, and it produces wrong results that look plausible.
Rows with fewer fields than the header get empty strings for the missing keys. Rows with more fields keep their extra values in list mode, and in header mode the extras beyond the header width are dropped, because an object cannot have a key with no name. Windows line endings are normalised, so files copied from different systems behave the same. Trailing blank lines are ignored, so a trailing newline does not create an empty final record.
TSV Versus CSV: Which Should You Use
TSV wins when your data contains commas, which is common: city names like “New York, NY”, numbers like “1,000”, and ordinary sentences all break naive CSV handling. Tabs almost never appear inside a value, so TSV rarely needs quoting rules, and the format stays simple. CSV wins when you need to share files with people, because more tools advertise CSV support and more people recognise the extension. For a quick copy from a spreadsheet into a web app, TSV is the path of least resistance, and this tool exists for exactly that moment.
One caution: pasting from some applications converts tabs to spaces. If the output comes out as a single column, your paste lost the tabs. Copy again directly from the spreadsheet, or check that the input shows real tab separation before converting.
Frequently Asked Questions
Can I paste directly from Excel or Google Sheets? Yes. Select the cells, copy, and paste here. The clipboard TSV format is exactly what this tool reads.
Why are all my values strings? TSV has no types: everything is text. JSON output keeps values as strings, and your application can convert ages and prices to numbers where needed.
Is my data uploaded? No. The conversion runs in your browser. Your table never leaves your device.
Copy a table, paste it above, and get clean JSON back in seconds.