Delimiter converter
Convert between CSV, TSV, and other delimited formats.
Common Use Cases:
- • Convert CSV to TSV (tab-separated)
- • Change delimiter from comma to semicolon
- • Add or remove quotes around fields
- • Clean up messy data with mixed delimiters
- • Add line numbers or column headers
Features:
- • Real-time conversion as you type
- • Support for custom delimiters
- • Automatic quote escaping
- • Whitespace trimming and cleanup
- • Download as CSV file
A practical guide to Delimiter converter
Delimiter Converter changes tabular text among comma, tab, semicolon, pipe, or custom separators while respecting quoted fields. Input parsing and output quoting determine whether rows remain intact.
Example: change CSV to tab-separated import data
Parse the comma-delimited source, inspect fields containing commas or quotes, choose tabs, and verify row and column counts.
Task-specific steps
- 1
Paste or upload the source and choose its actual separator instead of guessing from the file extension.
- 2
Preview parsed rows, paying special attention to quoted delimiters, embedded newlines, empty values, and headers.
- 3
Choose the destination separator, convert, and compare row and column counts before importing the result.
Options that affect the result
- Source and destination separators can be comma, tab, semicolon, pipe, or a custom character.
- CSV-compatible quoting protects fields that contain delimiters, quote marks, or line breaks.
Limitations to know first
- Malformed quoting or inconsistent row widths can make the intended table ambiguous.
- Delimiter conversion changes syntax only; it does not infer data types, formulas, locale decimals, or character encoding.
Questions specific to this task
Why did one row split into several rows?
An embedded newline may not be quoted correctly, or the parser may be using the wrong source delimiter.
When should semicolon-separated data be used?
It is common where commas serve as decimal separators, but the receiving application must be configured for semicolons.