How to Fix Excel Changing CSV Files for Shopify Upload Errors
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.

- 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 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.
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.
Right-click your original CSV file, select 'Open with', and choose 'Notepad' (Windows) or 'TextEdit' (Mac).
Check the data to ensure that values are separated by commas (,) and not semicolons (;).
Ensure text fields containing commas are wrapped in standard double quotes. Compare this file with any file resaved by Excel to spot unwanted modifications.
If you make minor corrections, save the file directly within the text editor (using UTF-8 encoding) without reopening it in a spreadsheet.

Adjust Windows Regional Settings for Excel Delimiters
Changing your system's regional settings forces Excel to use commas instead of semicolons when saving CSV files.
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. Open WPS Spreadsheet: Launch WPS Office on your computer and open WPS Spreadsheet.
- 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. Select Delimiter: Choose 'Delimited' in the wizard and specifically check the 'Comma' box to ensure columns are separated correctly for Shopify.
- 4. Save as CSV: After safely editing your data, go to Menu > Save As, choose 'CSV (Comma delimited) (*.csv)', and save the file.

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.




