Do quoted tabs stay in the cell?

Yes. TSV is parsed as CSV with a tab delimiter, so quoted tabs do not split columns.

Can I paste from Excel or Sheets?

Yes. Copy cells and paste into TSV to CSV or TSV to JSON.

Is JSON to TSV on this page?

No. Convert JSON to CSV in CSV to JSON, then CSV to TSV here. Or use Excel to JSON for workbooks.

Why is BOM always on for TSV to CSV?

So Excel on Windows opens the file. There is no checkbox on that tab. CSV to TSV defaults BOM off.

How large can a TSV or CSV upload be?

15MB for an uploaded file. Pasted text is not capped the same way.

TSV ⇄ CSV

Loading tool…

About TSV ⇄ CSV

TSV to CSV: paste or upload .tsv/.txt. Tab is the delimiter. Output is comma CSV with Windows newlines. UTF-8 BOM is always on (no checkbox). Preview 20 rows. Download CSV and Copy. Quoted tabs stay inside the cell.

CSV to TSV: upload or paste CSV. CSV delimiter is Auto-detect, Comma, Semicolon, or Pipe (no Tab option on that control). BOM on TSV out defaults off, with no checkbox. Download TSV and Copy.

TSV to JSON: same TSV upload or paste. First row is header and Pretty JSON are checkboxes. Shape is always an array of objects, and types are inferred (those last two are not extra controls). Download JSON and Copy. There is no JSON to TSV direction. Use CSV to JSON then CSV to TSV, or Excel to JSON for workbooks.

How to use TSV ⇄ CSV

1Paste TSV or CSV, or drop a file. .tsv, .txt, or .csv. Copy-paste from Sheets works on the TSV tabs.
2Pick a tab. TSV to CSV, CSV to TSV, or TSV to JSON.
3Preview the table. First 20 rows on CSV and TSV tabs.
4Download CSV, Download TSV, or Download JSON. Copy is on every tab.

TSV to CSV

Copy cells in Excel or Google Sheets and paste. That clipboard text is tab-separated. BOM on the download helps Excel on Windows.

CSV to TSV

Auto-detect uses the same CSV parser as the other converters. If your CSV is already tab-separated, use TSV to CSV instead of CSV to TSV.

TSV to JSON

Always an array of objects with inferred types. Pretty JSON is a checkbox. First row is header defaults on. TSV to JSON has no array-of-arrays shape.

Limits and privacy

TSV to CSV, CSV to TSV, and TSV to JSON all run in your browser. Each upload is 15MB. Paste from Sheets is not size-capped. Files are not uploaded. No account.

FAQs

Do quoted tabs stay in the cell?: Yes. TSV is parsed as CSV with a tab delimiter, so quoted tabs do not split columns.
Can I paste from Excel or Sheets?: Yes. Copy cells and paste into TSV to CSV or TSV to JSON.
Is JSON to TSV on this page?: No. Convert JSON to CSV in CSV to JSON, then CSV to TSV here. Or use Excel to JSON for workbooks.
Why is BOM always on for TSV to CSV?: So Excel on Windows opens the file. There is no checkbox on that tab. CSV to TSV defaults BOM off.
How large can a TSV or CSV upload be?: 15MB for an uploaded file. Pasted text is not capped the same way.