Different applications export delimited files with different separators. Excel on European systems often uses semicolons, MySQL exports use commas, and many Unix tools prefer tabs. This tool re-parses your file with the original delimiter and re-serialises it with the new one, properly handling quoted fields. Runs entirely in your browser.
CSV Delimiter Changer switches the separator in pasted delimited text. Delimited text files use a separator character between fields - commas in CSV, tabs in TSV, and semicolons in many European Excel exports. This change csv separator utility parses the input with the source delimiter and serialises it with the target delimiter. Quoting is applied automatically where needed in the output, rather than preserving the input's exact quote formatting.
Excel exports in European locales often use semicolons because commas serve as decimal separators, causing issues when importing into other systems. This data formatter online tool handles semicolon to comma csv conversion, while also offering custom separator fields. Check the converted text against the requirements of the application that will import it.
RFC 4180 defines the standard CSV format: fields may be enclosed in double quotes; if a field contains the delimiter, a newline, or a double quote, it must be quoted; a double quote inside a quoted field is escaped by doubling it ("" represents one ").
Excel uses a "list separator" from Windows regional settings as its CSV delimiter (often a semicolon in European locales). A comma-delimited CSV opened directly in Excel may appear as one column. Use this tool to convert to your locale's expected delimiter, or use Excel's Text Import Wizard.
Use a single-character source delimiter. The parser compares one character at a time, so multi-character input separators such as |~| are not supported. The custom fields do not validate this restriction; review the output before using it.
Input values containing the source delimiter need double quotes so they can be read as one field. The tool automatically quotes output fields containing the target delimiter, a double quote, or a line break, and doubles embedded quotes. There is no add-all or remove-all quoting option. Malformed input is not validated or repaired; review the output before using it.
See also CSV Column Tools and CSV to JSON to further process your files after using this CSV Delimiter Changer.