TSV to CSV
TSV to CSV treats tabs as field delimiters with the same custom quote-state parser, then quotes output cells when they contain a comma, double quote, or line break. It doubles embedded quotes. Input quoting rules are not a universal TSV standard, literal tabs inside a field cannot be distinguished without a dialect, and malformed quote states are not rigorously diagnosed.
Runs locally — files stay on your deviceWhen are output CSV cells quoted?
When they contain a comma, quote, or line break.
CSV serialization protects its delimiter and record characters
A CSV field containing special characters is surrounded with double quotes and internal double quotes are doubled.
How it works
Input is parsed with tab as delimiter; every cell passes through the CSV escaper and rows are joined with commas.
Key concepts
Output quoting
Commas and line breaks are protected.
Input dialect uncertainty
TSV producers vary in how they represent embedded tabs.
When to use it
- Convert a simple tab-delimited table.
- Create pasteable RFC-4180-style CSV.
- Protect commas introduced inside TSV cells.
When not to use it
- Do not expect spreadsheet formula neutralization.
- Do not assume arbitrary TSV quoting conventions.
- Do not expect type inference.
Worked examples
Simple
- Input
a⇥b\n1⇥2- Expected output
a,b\n1,2
Tabs become commas.
Comma cell
- Input
a,b⇥c- Expected output
"a,b",c
Comma-containing value is quoted.
Quote
- Input
a"b⇥c- Expected output
"a""b",c
Double quote is doubled.
Common mistakes
Opening hostile formulas
CSV escaping does not neutralize formulas. Correction: Apply destination-specific formula policy.
Assuming types
Everything remains text. Correction: Import with a schema.
Ignoring malformed input
Parser diagnostics are limited. Correction: Validate production data with a robust library.
Best practices
- Define the TSV input dialect.
- Inspect rows and column counts.
- Sanitize for the destination spreadsheet.
Related operations and differences
CSV to TSV
Choose CSV to TSV when you need to convert comma-separated data to tab-separated data.; use TSV to CSV specifically for tsv to csv.
CSV to JSON
Choose CSV to JSON when you need to convert a header-based CSV table to JSON.; use TSV to CSV specifically for tsv to csv.
JSON to CSV
Choose JSON to CSV when you need to convert an array of JSON objects to CSV.; use TSV to CSV specifically for tsv to csv.
CSV Column Remover
Choose CSV Column Remover when you need to remove one CSV column by header name.; use TSV to CSV specifically for tsv to csv.
CSV Formatter
Choose CSV Formatter when you need to normalize CSV quoting and row structure.; use TSV to CSV specifically for tsv to csv.
CSV Transposer
Choose CSV Transposer when you need to swap rows and columns in CSV data.; use TSV to CSV specifically for tsv to csv.
Limitations and privacy
- Tab input and comma output only.
- No strict dialect validation, schema/types, BOM/encoding controls, formula defense, streaming, file download, or row-width audit.
The pasted data is parsed and transformed locally in this browser.
Frequently asked questions
Are commas quoted?
Yes, when they occur in a cell.
Are quotes doubled?
Yes.
Are tabs inside data supported?
Not unambiguously.
Are numbers converted?
No.