Skip to main content
Tool Factory

Structured Data

CSV Separator Changer

Change a CSV delimiter, such as semicolon to comma, in your browser. Parses quoted cells line by line and can quote every output field.

Tool workspace

Your input stays in this browser.

Add the required input to continue.

Needs input

You can run the tool again after any change.

Input format

Output format

Your result appears here

Change a CSV delimiter, such as semicolon to comma, in your browser. Parses quoted cells line by line and can quote every output field.

This tool runs open-source code from OmniTools (MIT License). See open-source credits.

The parser reads each line separately, removes CSV quoting, and joins cells with the selected separator.

The result contains the converted rows. Remove empty lines drops blank rows; Comment prefix removes matching comment lines.

  • Convert semicolon CSV from a European-locale spreadsheet export to comma CSV.

Sources: RFC 4180: CSV fields and quoting

Choose separators without breaking quoted cells

  1. Set Input separator and Output separator.
  2. For tab output, paste a real tab character.
  3. Enable Quote every output field when a cell contains the new separator.
  • Quoted fields cannot span lines.
  • The parser trims surrounding cell spaces.
  • Quote every output field does not escape quotes inside cells. Use another converter when cells contain quotes.

A comma inside a quoted field

Input: item,note pen,"blue, fine" ink,refill

Settings: Input separator: , and Output separator: ; (the defaults)

Result: item;note pen;blue, fine ink;refill

The output drops the quotes around blue, fine. Its comma is plain text once semicolons separate fields.