Shopify CSV imports usually fail due to structural format errors: semicolon separators instead of commas, missing headers, incorrect UTF-8 encoding, missing BOM (Byte Order Mark), or unclosed quotation marks. You can fix these issues instantly by converting semicolons to commas or repairing the CSV using a local-first browser tool like FixData.

Table of Contents

1. Why Shopify Rejects CSV Files
2. Top 15 Shopify CSV Import Problems and Resolutions
3. FixData Repair Decision Matrix
4. Step-by-Step Conversion Matrix
5. Frequently Asked Questions
6. Related Local Data Tools

Why Shopify Rejects CSV Files

Shopify’s CSV parser is database-driven and highly strict. Unlike Excel or Google Sheets, which dynamically guess columns, Shopify maps each column name directly to database fields (like Handle, Title, or SKU). If a single line contains an extra semicolon, an unclosed double quote, or is saved in a non-UTF-8 encoding format, the Shopify parser fails to match columns and rejects the entire upload to prevent database corruption.

Top 15 Shopify CSV Import Problems and Resolutions

1. Delimiter Collision (Semicolon instead of Comma)

• Symptom: Shopify displays "Illegal quoting on line 1" or "Missing required headers".
• Why it happens: European editions of Excel save CSVs with semicolons (;) instead of commas (,) because commas are used as decimal separators in those regions.
• How to detect: Open the CSV in a text editor (like Notepad++). If columns are separated by semicolons (Handle;Title;Body), Shopify cannot read them.
• Manual fix: Open the file in a text editor, find and replace all semicolons with commas. Warning: This will corrupt decimals or text strings that contain commas.
• Automatic fix: Upload the file to the CSV Delimiter Converter. FixData will stream-rewrite semicolons to commas in memory while protecting commas inside quotes.
• Business impact: Delays product catalog launches, leading to lost sales during promotion cycles.

2. Incorrect Encoding (Non-UTF-8 / Windows-1252)

• Symptom: Shopify displays "Invalid UTF-8 encoding" or accented characters render as “.
• Why it happens: Legacy systems or Western Windows Excel setups export files in ANSI or Windows-1252 encoding.
• How to detect: Accented letters (like ä, é, ö) look garbled or display black question marks.
• Manual fix: Open the file in Notepad, click “Save As”, select “UTF-8” in the encoding dropdown, and save.
• Automatic fix: Upload the file to CSV Repair. FixData automatically decodes Windows-1252 streams and rewrites the export in standard UTF-8.
• Business impact: Damaged brand reputation due to misspelled customer names or corrupted product descriptions on the storefront.

3. Missing Byte Order Mark (BOM) in Excel

• Symptom: Shopify uploads, but special characters (like currency symbols or umlauts) display incorrectly.
• Why it happens: Microsoft Excel requires a specific marker at the start of a UTF-8 file (called a BOM) to read accents correctly, whereas other software ignores it.
• How to detect: Accents display correctly in Google Sheets but break in Excel or Shopify.
• Manual fix: Save the file as “CSV UTF-8 (Comma delimited) (*.csv)” in Excel.
• Automatic fix: FixData inserts the standard UTF-8 BOM byte sequence (0xEF, 0xBB, 0xBF) on all exported files automatically.
• Business impact: Corrupted pricing or product variants, leading to order fulfillment errors.

4. Missing Required Headers

• Symptom: Shopify displays "Required header 'Title' is missing" or "Handle is missing".
• Why it happens: The column headers do not match Shopify’s naming conventions (e.g., using Product Name instead of Title).
• How to detect: Check the first row of your CSV. Ensure columns like Handle and Title are named exactly as required.
• Manual fix: Open the CSV in Excel, locate the incorrect header, and rename it to Shopify’s exact label.
• Automatic fix: FixData validates header columns against Shopify schemas and reports mismatched names.
• Business impact: Complete block of product updates, leading to administrative overhead.

5. Duplicate Header Names

• Symptom: Shopify displays "Duplicate column header names detected".
• Why it happens: Two columns have identical names (such as two Option1 Value headers).
• How to detect: Scan the first row of the CSV for repeating names.
• Manual fix: Rename or remove duplicate columns in Excel.
• Automatic fix: FixData highlights duplicate column indices during initial file analysis.
• Business impact: Incorrect variant assignment, leading to shipping incorrect items to customers.

6. Column Count Mismatch (Extra Delimiters)

• Symptom: Shopify displays "Wrong number of columns on line 42".
• Why it happens: A text row contains an unescaped separator, causing the parser to think there are extra columns on that row.
• How to detect: Scan the line index mentioned in the error. Look for extra separator characters.
• Manual fix: Wrap the text field containing the separator in double quotes.
• Automatic fix: FixData parses rows streamingly, auto-escapes unquoted cells containing separator characters, and normalizes column counts.
• Business impact: Broken product tables, causing variants to sync with the wrong products.

7. Unclosed Quotation Marks

• Symptom: Shopify displays "Unclosed quotes on line 12" or merges multiple rows together.
• Why it happens: A cell contains an odd number of double-quotes, causing the parser to treat all subsequent lines as part of a single text cell.
• How to detect: The CSV file sizes look normal, but lines are joined together in the preview grid.
• Manual fix: Find the row coordinate and add the missing closing double-quote.
• Automatic fix: FixData’s CSV Repair Tool scans for odd quote counts and automatically sanitizes unclosed quotes.
• Business impact: Corrupts large inventory imports, causing missing items in collections.

8. Unescaped Quotes in Text Fields

• Symptom: Shopify displays "Illegal quoting on line 8" or shifting cell columns.
• Why it happens: Quotation marks are used inside description fields (e.g. 24" Monitor) without being escaped.
• How to detect: Raw double quotes appear inside text fields without a matching outer quote wrapper.
• Manual fix: Escape internal quotes by doubling them (e.g., change 24" Monitor to ""24"" Monitor"").
• Automatic fix: FixData automatically escapes internal quotation marks during delimiter conversion.
• Business impact: Shipped items may show HTML tags or corrupted description metrics to buyers.

9. Trailing or Leading Whitespace in Headers

• Symptom: Shopify displays "Required header 'Handle' is missing" even though the column is visible.
• Why it happens: The column header has an invisible space at the start or end (e.g. "Handle " or " Title").
• How to detect: The header column name displays with an extra space when inspected in a code editor.
• Manual fix: Remove the leading or trailing spaces from header labels in Excel.
• Automatic fix: FixData trims all leading and trailing whitespace characters from column headers automatically.
• Business impact: Frustrating validation failures on columns that look correct.

10. Zero-Width Spaces and Invisible Characters

• Symptom: Shopify displays "Invalid handle" or "Validation failed".
• Why it happens: Data copied from web pages or legacy systems contains zero-width spaces (\u200B) or other invisible control characters.
• How to detect: The text looks correct, but copy-pasting the cell value into a hex editor reveals hidden byte sequences.
• Manual fix: Copy the text into a plain text editor, delete the invisible space, and re-paste.
• Automatic fix: FixData strips zero-width spaces and invisible unicode control elements from headers and handles during diagnostic sweeps.
• Business impact: Broken URL handles, resulting in 404 pages on product storefronts.

11. Regional Numeric Decimals (Comma vs Dot)

• Symptom: Shopify displays "Price must be a valid number" (e.g. 2,49).
• Why it happens: European regional formats use a comma for decimals, whereas Shopify expects a period (dot) for decimal values.
• How to detect: Prices show up as 19,99 instead of 19.99.
• Manual fix: Change your spreadsheet’s cell format settings to US locale, or run a search-replace for commas in numbers.
• Automatic fix: FixData sanitizes decimal formats, converting regional currency commas to dots while protecting CSV separators.
• Business impact: Blocks price updates, resulting in outdated or zero-dollar storefront pricing.

12. Line Ending Incompatibilities (CR vs LF)

• Symptom: Shopify displays "Line 2: Title cannot be blank" or parses the entire file as a single row.
• Why it happens: The file uses legacy Mac line endings (\r Carriage Return) instead of Windows (\r\n CRLF) or Unix (\n LF).
• How to detect: Opening the file in basic Notepad displays the entire CSV content on a single line.
• Manual fix: Open the file in Notepad++, select Edit ➔ EOL Conversion, choose Windows (CRLF) or Unix (LF), and save.
• Automatic fix: FixData normalizes all row endings to standard \n or \r\n streams during processing.
• Business impact: Upload timeouts and crashes on larger catalogs.

13. Leading Zeros Stripped (Barcodes & SKUs)

• Symptom: Shopify displays "SKU already exists" or converts barcodes to scientific notation (e.g., 5.01E+12).
• Why it happens: Excel treats numeric barcodes (like UPC or EAN) as numbers and automatically strips leading zeros or converts them to scientific notation.
• How to detect: Barcode columns look like 1.23E+11 instead of 123456789012.
• Manual fix: Format the column as text in Excel before pasting numeric barcodes, and restore missing zeros manually.
• Automatic fix: Using Excel Compare or FixData’s import parser prevents auto-conversion, preserving numeric strings as raw text tokens.
• Business impact: Broken barcode searches and fulfillment errors.

14. Null Bytes and Binary Characters

• Symptom: Shopify uploads fail with network timeout errors or corrupted characters.
• Why it happens: Database export files contain raw null bytes (\x00) or binary data.
• How to detect: The file contains blank squares or triggers unreadable character errors in text editors.
• Manual fix: Open the CSV file in Notepad++, find \x00, and replace it with empty text.
• Automatic fix: FixData’s local worker filters binary control bytes during the file streaming phase.
• Business impact: Complete sync block, requiring database administrator intervention.

15. Trailing Commas Creating Blank Columns

• Symptom: Shopify displays "Extra column headers detected" or "Import failed".
• Why it happens: Excel saves empty columns at the end of rows, leaving trailing commas at the end of lines.
• How to detect: Raw lines end with multiple commas (e.g. Product,SKU,,,,,).
• Manual fix: Delete the empty columns in Excel and export again.
• Automatic fix: FixData automatically trims empty tailing columns from both header rows and record streams.
• Business impact: Minor sync errors that block automation triggers.

FixData Repair Decision Matrix

Step-by-Step Conversion Matrix

Before upload, review the expected conversions below:

• Semicolon (;) ➔ Comma (,): European CSV files are translated to standard US formats.
• Comma (,) ➔ Semicolon (;): Standard formats are translated for European Excel versions.
• Tab (TSV) ➔ Comma (,): Tab-delimited files are converted for Shopify product sync.
• Pipe (|) ➔ Comma (,): CRM exports are formatted for standard e-commerce setups.

Frequently Asked Questions

Why does Excel export semicolon CSVs?

Excel exports semicolon CSVs because your system’s region is set to a European country where the comma is used as the decimal separator. To prevent numbers like 1,99 from splitting into separate columns, Excel changes the CSV separator to a semicolon.

Why do European regions use semicolons?

European regions use semicolons because the metric decimal system uses commas instead of periods. Using semicolons avoids formatting conflicts with decimal numbers in price and dimension columns.

Will converting semicolons to commas break decimal numbers?

No, converting semicolons to commas will not affect decimal values. FixData’s parser automatically wraps decimal prices inside double quotes, ensuring the decimal commas remain intact.

Will formulas break after delimiter conversions?

No, formulas will not break. FixData only replaces separator characters outside of cell values. Math operators inside cell equations are ignored.

Can Shopify import the converted CSV?

Yes, Shopify can import the file. Standardizing your delimiters to commas ensures that Shopify detects your column headers and imports products without schema failures.

Can WooCommerce import the converted CSV?

Yes, WooCommerce imports the converted file. The WooCommerce importer requires standard commas for column mappings, which are generated during conversion.

Does HubSpot accept converted CSVs?

Yes, HubSpot accepts converted CSVs. Commas ensure HubSpot correctly parses contacts and matches properties during import mappings.

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 the converted CSV?

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 files?

Yes, you can convert TSV files. Select ‘Tab’ as the input delimiter and ‘Comma’ as the target to translate the separator structures immediately.

Can I convert Pipe 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 CSV?

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.

Related Local Data Tools

If you need to perform additional checks on your spreadsheets, use our local-first workspaces:

• CSV Repair Tool — Clean broken quotes, trailing spaces, and unreadable characters.
• CSV Delimiter Converter — Convert European semicolons to commas.
• Excel Compare — Cross-reference inventory lists to find duplicate or missing SKU details.
• Compare Lists — Match values between raw columns side-by-side.