FD
FixData
Status: Ready Environment: Local Browser Sandbox: Web Worker Isolated

Convert CSV Semicolons to Commas Online

Fix CSV files that won't import into Shopify, WooCommerce, HubSpot or Salesforce. 100% private. Runs in your browser.

Name;Email;Country ➔ Name,Email,Country
✔ No Upload ✔ No Registration ✔ Browser Only ✔ Unlimited Files ✔ Private ✔ Free

Drop your CSV file here, or choose file

FixData automatically detects the separator and converts it safely.

Supports: CSV, TSV, Semicolon CSV, Pipe CSV, Tab-delimited Up to 500 MB Browser only
How it works
1

Upload CSV

Drag and drop your spreadsheet into our secure local browser zone.

2

Auto Detection

FixData scans row patterns to detect your current column separator automatically.

3

Safe Conversion

Rewrites column separators in background worker memory without touching cell values.

4

Download CSV

Instant file download compatible with Shopify, HubSpot, or Salesforce databases.

Is this your problem?
✔ Excel exported semicolons Excel defaults to semicolon separators in European regions. ✔ Shopify rejects CSV Shopify imports fail if column headers use semicolons. ✔ WooCommerce won't import WooCommerce requires standard commas for column mappings. ✔ HubSpot can't detect columns CRM contacts fail to load when properties use semicolon separates. ✔ Salesforce import error Salesforce column maps throw parser error on semi-colons. ✔ Google Sheets regional issue Sheets exports default to semi-colon based on locale settings.
Compatible Importers
Microsoft Excel Google Sheets Shopify Importer WooCommerce Store HubSpot CRM Salesforce SAP ERP Oracle Dynamics 365
Supported Format Conversions
Semicolon (;) ➔ Comma (,)
Comma (,) ➔ Semicolon (;)
Tab (TSV) ➔ Comma (,)
Pipe (|) ➔ Comma (,)
TSV File ➔ CSV File
CSV File ➔ TSV File
Pipe (|) ➔ Semicolon (;)
Comma (,) ➔ Pipe (|)
Who is this for?
✔ Excel & Google Sheets users: Re-align regional spreadsheets that default to semicolons when saved.
✔ Shopify & WooCommerce store owners: Fix inventory product lists that refuse to upload due to header mismatches.
✔ HubSpot & Salesforce sales reps: Import customer lists and property databases without column alignment errors.
✔ ERP & CRM database administrators: Convert raw database dumps streamingly before import validation stages.
Reconcile or Repair Data Columns?

1. CSV Repair Tool

If your file has corrupted encodings, bad line breaks, or structural row alignment errors, use CSV Repair.

Open CSV Repair ➔

2. Excel Compare Tool

Reconcile spreadsheet columns across two tables to find missing, duplicate, or mismatching row values.

Open Excel Compare ➔

3. Compare Lists Tool

Instantly find duplicate values, common items, or differences between two plain text lists.

Open List Matcher ➔

Frequently Asked Questions

Why does Excel export CSV files with semicolons instead of commas?
Excel exports CSVs with semicolons because your computer's regional settings use a comma as the decimal separator. To avoid conflict with decimal points in numbers (e.g. 1,99), Excel uses a semicolon as the separator character.
Why does Europe use semicolons in CSV sheets?
European countries use semicolons because their standard metric decimal notation uses the comma. Using semicolons ensures that data parsers do not mistake math decimals for row separators during transfers.
Will converting semicolons to commas break decimal numbers?
No, converting semicolons to commas will not affect decimal values. Any numbers or decimals wrapped inside quotes (e.g. "1,99") are ignored by the parser during the delimiter transformation process.
Will formulas break after delimiter conversions?
No, formulas will not break. FixData only replaces separator characters outside of cell values. Math operators inside values remain completely unchanged.
Can Shopify import the converted comma CSV?
Yes, Shopify will import the file correctly. Standardizing your delimiters to commas ensures that Shopify detects your column headers and parses items without throwing import schema failures.
Can WooCommerce import the converted file?
Yes, WooCommerce accepts converted comma CSV files. Converting separators to commas solves column mismatch warnings during WooCommerce product updates.
Does HubSpot accept the converted CSV files?
Yes, HubSpot accepts converted CSVs. Converting semicolon separators to commas enables HubSpot to correctly map contact properties during import matches.
Can Salesforce import the converted CSV?
Yes, Salesforce supports the converted comma CSV. The database mapping loader will align property headers and insert rows without throwing structural exceptions.
Can Google Sheets import converted comma CSV files?
Yes, Google Sheets imports converted CSV files natively. Commas are recognized universally by Sheets as standard columns regardless of your regional browser locale.
Can I convert TSV (Tab Separated) to CSV?
Yes, you can convert TSV to CSV. Select 'Tab' as the input delimiter and 'Comma' as the target to translate the separator structures immediately.
Can I convert Pipe delimited files?
Yes, Pipe delimited files are supported. Select 'Pipe (|)' as the source delimiter and choose your desired output format from the options panel.
Can I convert UTF-16 encoded CSV files?
Yes, UTF-16 files are supported. The local parser auto-detects the encoding byte order mark (BOM) and decodes text rows correctly before converting separators.
Can I convert very large CSV files?
Yes, you can convert large files. FixData streamingly reads spreadsheets up to 500MB directly in your browser memory via Web Workers, ensuring no browser tab freezes.