Solutions to Garbled Characters in Exported Tables

Content

 

When using the "Export/Import Product" feature in [Products], SHOPLINE uses a CSV format file that can store a large amount of data to save product information. However, some current Excel versions are not compatible with CSV files, and garbled characters may appear when opening a CSV file. You can use WPS (Windows, macOS) or Numbers (macOS) to open the CSV file instead. In addition, you can refer to the following methods to solve the problem according to the actual scenario.

If you need to know the Excel version you are using, you can check the version number through Microsoft's official guidelines.

 

A. Permanent solution - Modify the Windows system encoding format to UTF-8 (for Windows 10 only)

1. Click the Start icon and select Settings.

 

2. Go to Time & Language.

 

3. Select Language from the left menu.

 

4. Click Administrative Language Settings.

 

5. In the pop-up window, click Change system locale.

 

6. Check the box for "Beta: Use Unicode UTF-8 for worldwide language support", then click OK.

 

7. After completing the above settings, restart the computer to solve the problem of garbled characters when exporting tables.

 

B. Use Notepad to modify the encoding format of the CSV file (Windows only)

1. Right-click the downloaded CSV file and select "Open this file with Notepad". 

 

2. Select [File] > [Save As].

 

3. In the encoding format, select UTF-8 format, do not modify the file format suffix, keep it as ".csv".

 

4. Open the original file with Excel.

 

C. Use Excel365, Excel2016, and later versions

i. Excel 365 (the latest version)

Step 1

Open the downloaded csv file in Excel, select [Data] > [From Text/CSV].

 

Step 2

After selecting the downloaded file in the local folder, click Import.

 

Step 3

Select the following options in the pop-up window:

  • File origin: 65001:Unicode(UTF-8)
  • Delimiter: Comma
  • Click Load to get an ungarbled Excel document for editing.

 

ii. Excel 2013 or older versions

Step 1

Open the downloaded csv file in Excel, select [Data] > [From Text].

 

Step 2

After selecting the downloaded file in the local folder, click Import.

 

Step 3

In the pop-up window, select the following options:

  • Select Delimited
  • File Origin: 65001:Unicode(UTF-8)
  • Click Next.

 

 Step 4

In the pop-up window, select the following options:

  • Uncheck "Tab". 
  • Check Comma.
  • Click Next.

 

Step 5

Select Text under "Column data format", then click Finish to obtain an ungarbled Excel file for editing.

 

Have more questions? Submit a request

Comments