Articles on: Trouble Shooting
This article is also available in:

CSV import in Excel with garbled characters

If you are using a Mac device, you might open a CSV file in Microsoft Excel and see incorrect or garbled characters, such as é, ü, Å, 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 use 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 follow the instructions below to open and edit a CSV file.

Step by step Tutorial

In Excel, go to File > New Workbook.

Go to Data tab, click on From Text. 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 the 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.

If you encounter this issue on a Windows device, you can try the similar method.
You can use Excel (for Windows) or import the file to Google Spreadsheet to edit it instead of Excel for Mac.
If you export the file and import it without editing, you will not get this issue.

Troubleshooting - I can't import products by CSV file
Understand the CSV file and how to create a product CSV file
Import products to ShopBase by CSV file

Updated on: 13/09/2022

Was this article helpful?

Share your feedback


Thank you!