You might a CSV file in Microsoft Excel and are see incorrect, or garbled characters, such a é, ü, Å, etc. If the file is imported to ShopBase, the titles and descriptions will display as follows:



This could be because the CSV file is UTF-8-encoded. Many platforms uses UTF-8 because it is the de-facto standard for information exchange in modern applications. However, Excel does not automatically use UTF-8 when opening CSV files. This issue often happens in Excel for Mac

To resolve this issue, please do the following method to open and edit a CSV file:

On a Macbook:
After opening Excel, click File > New Workbook in Excel.


Click Data tab. Click From Text option. Select the CSV you file want to import.


Excel will display Text Import Wizard.


In step-1 of this wizard:
Select Delimited radio button.
In File origin field - select Unicode (UTF-8).


Click Next > button.

In step-2 of this wizard:
Select "Comma" checkbox.
Click "Finish" button.


In the dialog window that appears - click "OK" button.


Note:
If you encounter this issue on a Windows device, you can try the similar method
You can use Excel (for Windows) of import the file to Google Spreadsheet to edit instead of Excel for Mac
If you export the file and import it without editing, you will not get this issue.
Was this article helpful?
Cancel
Thank you!