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.
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
- File → Import → Upload, and choose Semicolon as the separator type.
- File → Download → Comma-separated values (.csv). Sheets always writes commas and UTF-8.
LibreOffice Calc
- Open the file and tick Semicolon as the separator.
- File → Save As → Text CSV, tick "Edit filter settings" and choose , as the field delimiter.
Windows (affects every program)
- Control Panel → Region → Additional settings → List separator: change ; to ,.
Before and after
Name;Price;Description
Wool beanie;24,90;Warm, soft hatName,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 fileThe 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.