Data Import & Export

How to Fix Excel Changing CSV Files for Shopify Upload Errors

Jason MillerJason Miller Oct 20, 2026 868 views

Question details

The user is experiencing Shopify upload errors because Microsoft Excel automatically alters CSV formatting, such as delimiters and encoding, when opening and saving the file.

How to Fix Excel Changing CSV Files and Resolving Shopify Upload Errors
Product
Microsoft Excel, Shopify
Device & OS
not provided
Scenario
Opening, editing, and saving Shopify CSV export or import files using a spreadsheet application.
Observed behavior
Excel changes commas to semicolons, alters quoted fields, encoding, and line endings upon saving, which causes Shopify to reject the file.
Before you start

Before troubleshooting, make a copy of your original, unedited Shopify CSV file to ensure you do not lose the raw data if your spreadsheet software has already overwritten the formatting.

Solution 1Recommended

Inspect and Fix the CSV File in a Text Editor

Using a plain-text editor prevents the automatic formatting changes applied by spreadsheet software and lets you verify the raw CSV structure.

Spreadsheet applications often reinterpret values, delimiters, quoting, and line endings based on regional settings. Opening the file in a plain-text editor reveals the raw data as Shopify will read it.

1
Open with Notepad

Right-click your original CSV file, select 'Open with', and choose 'Notepad' (Windows) or 'TextEdit' (Mac).

2
Verify the delimiters

Check the data to ensure that values are separated by commas (,) and not semicolons (;).

3
Check quotation marks and line endings

Ensure text fields containing commas are wrapped in standard double quotes. Compare this file with any file resaved by Excel to spot unwanted modifications.

4
Save changes

If you make minor corrections, save the file directly within the text editor (using UTF-8 encoding) without reopening it in a spreadsheet.

Inspect and Fix the CSV File in a Text Editor
Protect Privacy: If you are sharing your CSV file in a ZIP archive for support troubleshooting, ensure all private customer data is removed or protected first.
Edit CSVs Safely with WPS Office

Use WPS Spreadsheet to Safely Edit Shopify CSV Files

WPS Spreadsheet provides a dedicated text import wizard, allowing you to explicitly choose your delimiters (like commas) and encoding (like UTF-8) so your Shopify CSV files remain perfectly formatted without unwanted automatic changes.

  1. 1. Open WPS Spreadsheet: Launch WPS Office on your computer and open WPS Spreadsheet.
  2. 2. Import CSV Data: Go to the 'Data' tab and click on 'Import Data', or simply open the CSV file to trigger the Text Import Wizard.
  3. 3. Select Delimiter: Choose 'Delimited' in the wizard and specifically check the 'Comma' box to ensure columns are separated correctly for Shopify.
  4. 4. Save as CSV: After safely editing your data, go to Menu > Save As, choose 'CSV (Comma delimited) (*.csv)', and save the file.
Accurate Text Import Wizard to explicitly control CSV delimiters100% compatible with Microsoft Excel file formatsPreserves the original UTF-8 encoding required by ShopifyFree and lightweight alternative to heavy spreadsheet applications
QA img-9

Frequently Asked Questions

Why does Excel change my CSV commas to semicolons?

Excel relies on your computer's Windows Regional Settings. In many regions (like Europe) where the comma is used as a decimal mark, the operating system uses a semicolon as the default list separator, causing Excel to save CSVs with semicolons.

How can I safely view the raw data of a CSV file?

The safest way to view a CSV file without altering its formatting, delimiters, or data types is to open it in a plain-text editor like Windows Notepad, Notepad++, or Apple TextEdit.

What encoding does Shopify require for CSV files?

Shopify requires CSV files to be saved with UTF-8 encoding. If your spreadsheet software saves the file in a different encoding format, special characters may become corrupted and cause upload errors.