CSV / TSV
Convert delimited text with explicit quoting, record endings and file encoding.
Text and files stay in this browser; nothing is uploaded.
| Record | Column 1 | Column 2 | Column 3 |
|---|---|---|---|
| 1 | id | name | note |
| 2 | 007 | Ada | Paris, France |
| 3 | 003 | Grace | two lines |
| 4 | 010 | Lin |
Showing 4 of 4 records. Export includes every record.
1 converted; 0 failed.
4 records, 3 columns, 68 UTF-8 bytes.
Use the CSV delimiter converter when a destination expects tabs but your export uses commas. The parser reads complete fields first, so a comma inside a quoted address stays part of the address.
Change CSV delimiter settings for one pasted table or a batch of local files. CSV to TSV and TSV to CSV share the same controls; a semicolon CSV needs only a different source separator.
A global comma replacement can split an address or alter a quoted note. The CSV delimiter converter separates record structure from field content, then writes the same strings using the chosen target separator.
Files are converted independently with shared settings. Inspect each result, correct failed inputs and download successful outputs together as a ZIP. A malformed file does not become an empty success or merge into a neighboring table.
Automatic source detection considers comma, tab, semicolon and pipe. If several choices fit, select the intended separator yourself. A single-column table also needs an explicit source choice; custom separators are never guessed.
Required quoting protects separators, double quotes, empty fields and embedded newlines. No-quotes mode rejects these fields instead of deleting characters. TSV output uses CSV-style quotes, so confirm that the receiving parser supports them.
The table initially shows 50 records; reveal 50 more as needed. Copy and download include every record. Changing mode, input or settings makes old results unavailable for export until conversion completes again.
Each delimiter can be one Unicode scalar, including an emoji. Quotes, control characters, line breaks and BOM are prohibited; choose Tab through its dedicated option. Source and target can use different characters.
Choose LF, CRLF or CR between records. Newlines inside quoted fields retain their original characters. Output is UTF-8 with an optional BOM; changing record endings does not normalize cell content.
Automatic conversion starts after a short pause. Turn it off to reveal Convert and use Ctrl/Cmd+Enter for a manual run. Feedback reports successes and failures, while a selected failed file retains its error details.
Loading an example, clearing input or choosing replacement files opens a preview with character and file counts. Apply accepts it; Cancel keeps the current source. Undo restores the previous source, options and output together.
Choose comma as the source and Tab as the target, or keep automatic detection when it finds one clear separator. The CSV delimiter converter previews the parsed records so you can check quoted addresses before downloading TSV.
The output quote policy controls that. Required quoting adds quotes only where needed; all-field quoting surrounds every value. Quotes within quoted fields are doubled. No-quotes mode fails on unsafe values rather than producing ambiguous text.
Yes. Select Semicolon as the source, then choose comma, Tab or a custom target. Decimal commas inside fields remain commas; the tool changes field boundaries, not number formats.
Yes. Select Tab as the source and Comma as the target. The same strict quoted-field rules apply in both directions. A TSV reader that simply splits on tabs may not understand quoted tabs or multiline fields.
Only within the supported path: UTF-8 or BOM-marked UTF-16 input becomes UTF-8 output, optionally with a BOM. It cannot guess Windows-1252, repair already corrupted text or produce another legacy encoding.
Did a file behave differently than expected?
Try the CSV delimiter converter with a quoted value, inspect its column position and export only after the target separator and quote policy are correct.