Convert a semicolon CSV to a comma CSV

Excel uses your Windows list separator when it saves a CSV, and in much of Europe that's a semicolon. Drop the file below and download it with commas: the tool quotes values that contain a comma, removes Excel's sep=; line and, if you want, converts decimal commas too.

Wording and rules verified on

Fixed in your browser – your file never leaves your device.

Files over 50 rows: 1 credit each ($0.75–$1 depending on pack), no subscription · See prices

Several files? Select or drop them together to fix them all at once.

No file handy? Try a broken sample

Sample files with typical import errors, loaded in your browser. Fixing and downloading them is free.

Why it happens

CSV has no single standard separator. Excel takes it from the Windows regional settings: where the decimal separator is a comma (Germany, Poland, Czechia, France, the Netherlands and many others), the list separator is a semicolon, so Excel's "CSV" is really semicolon-separated.

Importers that expect commas, such as Shopify, WooCommerce and most web apps, then read each row as one long column. Replacing every ; with , doesn't work either: commas inside values ("Warm, soft hat" or 24,90) turn into extra columns.

How to fix it manually

Google Sheets

  1. File → Import → Upload, and choose Semicolon as the separator type.
  2. File → Download → Comma-separated values (.csv). Sheets always writes commas and UTF-8.

LibreOffice Calc

  1. Open the file and tick Semicolon as the separator.
  2. File → Save As → Text CSV, tick "Edit filter settings" and choose , as the field delimiter.

Windows (affects every program)

  1. Control Panel → Region → Additional settings → List separator: change ; to ,.

Before and after

Before
Name;Price;Description
Wool beanie;24,90;Warm, soft hat
After
Name,Price,Description
Wool beanie,24.90,"Warm, soft hat"

The description contains a comma, so it gets quotes. The price becomes 24.90 only if you switch on number conversion.

Fix it automatically

  • Detects the separator: semicolon, tab or |.
  • Writes commas and puts quotes around values that contain one.
  • Removes Excel's sep=; line.
  • Converts decimal commas (24,90 → 24.90) on request. It's off by default, because some importers want them.
  • Saves as UTF-8, with a BOM if the file will be opened in Excel.

Checking and the preview are free. Downloads are free up to 50 rows; a larger file costs 1 credit.

Choose a file

The file is read and repaired inside your browser. Nothing is uploaded: only the row count and the platform are ever sent to us, so supplier prices and customer data stay private.

Frequently asked questions

Can I convert the other way, from commas to semicolons?

Yes. Choose ; as the separator under Download. That's what Excel in a European locale opens correctly with a double-click.

Why not just use Find & Replace?

Because commas already inside values become new columns, and every row after the first one with a comma in the text is shifted. A converter has to parse the file first and quote those values.

Is my file uploaded anywhere?

No. The file is read, checked and fixed in your browser. For a paid download only the row count, the platform and a fingerprint of the file (SHA-256) are sent, so you aren't charged twice for the same file.

How much does it cost?

Checking a file and previewing the fixes is free. Downloading the fixed file is free up to 50 rows. A larger file costs 1 credit, and for 24 hours you can download the same file again in another format or encoding at no extra cost. No subscription needed; agencies that fix files every month can choose Pro: 300 files a month for $19.