CSV to TSV Conversion
Input
product,price,in_stock
Laptop,1200,true
Mouse,25,falseExample output
product price in_stock
Laptop 1200 true
Mouse 25 falseCSV to TSV & TSV to CSV Converter
CSV & Tables100% Client-SideReady
CSV
0 lines0 chars
0 B / 4.77 MB
Read-only
0 lines0 chars
0 B
About this tool, examples & FAQ
Convert between Comma-Separated Values (CSV) and Tab-Separated Values (TSV) seamlessly in your browser. Configure custom delimiters (comma, semicolon, pipe), protect against spreadsheet formula injection, and copy or download the results instantly.
Key facts
| Operations | CSV → TSV and TSV → CSV |
|---|---|
| Delimiters | Comma (,), Semicolon (;), Pipe (|), and Tab (\t) |
| Formula Protection | Automatic prefix escaping for =, +, -, and @ cells |
| Maximum Input | 5 MB |
| Execution Deadline | 3 s |
How to use
- Paste your CSV or TSV spreadsheet data into the input pane.
- Select your desired conversion direction: CSV → TSV or TSV → CSV.
- Configure delimiter options (comma, semicolon, or pipe for the CSV side).
- Toggle spreadsheet formula injection protection as needed.
- Click Convert (or press Ctrl/Cmd + Enter) to generate the converted tabular file.
- Copy to clipboard or download as .csv or .tsv.
Examples
TSV to CSV Conversion
Input
name department level
Dana Security Staff
Evan Cloud SeniorExample output
name,department,level
Dana,Security,Staff
Evan,Cloud,SeniorEdge cases
Embedded commas and tabs inside cell data
When cell values contain commas, quotes, or newlines, CSV enclosing quotes are maintained. When converting to TSV, quotes are minimized unless tabs or line breaks occur inside a value.
Spreadsheet formula injection prevention
Values beginning with '=', '+', '-', or '@' can execute untrusted formulas or commands when imported into spreadsheet software like Excel. Enabling formula sanitization prepends an apostrophe to neutralize execution.
European semicolon-delimited CSV files
In many European regions, spreadsheets use semicolons (;) rather than commas due to comma decimal separators. You can select semicolon as the CSV delimiter to process these files without manual find-and-replace.
How it works
- Parses tabular records into streaming rows using PapaParse.
- Normalizes quoted fields, escapes, and delimiters.
- Applies optional spreadsheet injection sanitization to cell text.
- Re-encodes all fields with the target delimiter and line endings within a client-side Web Worker.
Related workflows
JSON ↔ CSV Converter
Convert bi-directionally between JSON arrays of objects and tabular CSV/TSV data with delimiter options, header validation, and spreadsheet formula injection protection.
XML ↔ CSV Converter
Convert bi-directionally between XML lists and tabular CSV data with custom delimiters, header extraction, and spreadsheet formula injection protection.
Frequently asked questions
Why use TSV instead of CSV?
TSV files use tabs (\t) as separators, which rarely appear in raw prose or numerical data. This eliminates the need for quotation marks around commas or periods, making TSV popular in Unix pipelines, bioinformatics, and database bulk imports.
Can I open TSV files in Microsoft Excel or Google Sheets?
Yes. Excel and Google Sheets can directly open .tsv files or paste tab-separated text directly across multiple cells and rows.
Is my spreadsheet data sent to any remote server?
No. All parsing and conversion runs strictly in your local browser sandbox via Web Workers. No data is stored, logged, or transmitted.
References
- IANA MIME Media Types: text/tab-separated-values — Official IANA MIME specification for TSV files
- RFC 4180 — Common Format and MIME Type for CSV — CSV standard for delimiters, quoting, and record termination