Data tools

CSV Delimiter Converter

Convert parsed CSV among comma, semicolon, tab, pipe, and custom delimiters.

Processed locally in your browser. Your input is not uploaded to our server.

Enter or load CSV data to begin.

How to use Convert CSV Delimiter

  1. Paste delimited records or choose a local CSV, TSV, or text file.
  2. Confirm the input delimiter and select a different output separator plus quote and file options.
  3. Inspect fields containing punctuation, then download the converted data.

Supported behavior

CSV Delimiter Converter changes the separator of parsed records rather than replacing punctuation blindly. Input can be auto-detected or declared as comma, semicolon, tab, pipe, or one custom character; output offers the same explicit choices. Quoted fields are parsed first, so a comma inside a quoted value remains data. When the new delimiter appears inside a field, correct quoting and quote escaping are added automatically. Minimal or all-field quoting, LF or CRLF, UTF-8 BOM, value trimming, header preservation, and spreadsheet formula-injection protection are configurable. Input and output delimiters cannot be identical unless another output option also changes, preventing a no-op disguised as conversion. Pasted text and local .csv, .tsv, or .txt files remain entirely in your browser and are never uploaded. Auto-detection can be uncertain on small samples, and trimming or formula protection intentionally changes cell serialization, so confirm the preview before downloading.

  • Delimiter auto-detection may be unreliable for a one-row or highly irregular sample.
  • A custom delimiter must be exactly one character and cannot represent a multi-character token.

Examples

                name,note
Ada,"red, green"

Result: name|note Ada|red, green

                id;city
1;Paris
2;Lima

Result: id,city 1,Paris 2,Lima

Common use cases

  • Convert a comma export to semicolons for a regional importer.
  • Produce tab-separated data for pasting into a spreadsheet.
  • Change line endings and add a BOM while retaining the same logical records.

Frequently asked questions

Are commas inside quoted text replaced?

No. Fields are parsed first, so punctuation within a quoted value remains part of that value.

Can input and output separators match?

Only when another output setting changes; otherwise the tool rejects an ineffective conversion.

When is a field quoted?

Minimal mode quotes when CSV rules require it, while All fields quotes every value.

Can I create TSV output?

Yes. Choose Tab as the output delimiter.