Format

Convert CSV delimiters between commas, semicolons, tabs, and pipes

Switch spreadsheet delimiters between commas, semicolons, tabs, and pipes seamlessly.

🛡️ Your rows never leave your browser.
Why Onfyt: Converts European semicolon CSVs to standard comma files while safeguarding embedded text punctuation with RFC 4180 parsing.

Interactive Sample Data

idnamepriceregion
1Solar Panel450.00Nairobi
2Inverter220.50Mombasa

How this tool works

Different software tools and international regions demand different tabular delimiters. Standard US and UK spreadsheets employ commas (,) to separate columns, while European versions of Excel (such as French, German, and Italian localizations) require semicolons (;) because the comma serves as the decimal separator (e.g. 19,99 €). Switching delimiters is not a simple find-and-replace operation. If a record contains text with existing commas (such as 'Otieno, Peter' or company addresses), replacing commas with semicolons without parsing quotes will corrupt text strings. A dedicated converter parses the RFC 4180 quotes, extracts the raw cell values, and re-serializes the data using the target delimiter, wrapping cells in quotes only when they contain the new separator. DataFix allows you to convert between commas, semicolons, horizontal tabs (TSV), and vertical pipes (|) with instant preview in your browser. Data interchange pipelines frequently encounter format mismatches when ingesting comma-separated values into applications that mandate semicolon, pipe, tab, or caret delimiters. In European locales, for instance, commas represent decimal separators (such as 12,50 €), prompting database dumps and spreadsheet applications like Excel to default to semicolon delimiters to avert numeric truncation. Changing delimiters requires strict compliance with RFC 4180 escaping rules: any field that contains the new delimiter must be wrapped in double quotes, while existing quoted fields must retain their quote escapes. DataFix parses each cell as an isolated token, verifies quoting boundaries across embedded line breaks, and serializes the matrix using your selected delimiter without breaking internal numerical punctuation or multi-line address blocks.

Things that usually go wrong

  • Values that contain the new delimiter will be wrapped in quotes automatically — this is correct CSV behaviour.
  • If you choose the same delimiter as the source, the output is identical to the input.

Edge cases we tested

🧪 Cells containing the new target delimiter

Wrapped automatically in quotation marks to prevent column splitting.

🧪 Mixed delimiters in messy exports

Detects primary delimiter across first 10 rows and normalizes to selected separator.

🧪 European decimal numbers with commas ('19,50')

Preserved as single cell values when converting between semicolon and comma formats.

Frequently Asked Questions

Why would I need to change the delimiter?

Different systems export different delimiters. European Excel exports use semicolons; many databases expect pipes or tabs.

Are quoted fields handled correctly?

Yes. Fields that contain the delimiter are re-quoted in the output.

Related tools

Format

JSON Formatter

Beautify and indent unformatted JSON strings into clean, human-readable structured trees.

Open Tool →
Format

JSON Minifier

Compress structured JSON files into single-line minified strings to reduce payload size.

Open Tool →
Format

Add a Header Row to CSV

Insert column headers to raw CSV files that lack a top header row.

Open Tool →