Data Import & Export

Import a UTF-8 CSV File in WPS Office Spreadsheets Without Garbled Characters

Olivia MillerOlivia Miller Nov 13, 2026 870 views

Question details

The user needs to import a UTF-8 CSV file containing Japanese, Chinese, or other non-English characters into a spreadsheet application without character corruption.

How to Import a UTF-8 CSV File into WPS Office Spreadsheets Without Garbled Characters
Product
WPS Office Spreadsheets
Device & OS
Windows and macOS
Scenario
The user has a UTF-8 CSV file with Japanese, Chinese, or other multilingual content and needs to open it correctly in a spreadsheet.
Observed behavior
Non-English characters appear garbled when the CSV is opened directly because the wrong encoding is applied.
Before you start

Check that the CSV file is actually saved as UTF-8 and note which delimiter it uses, such as a comma, semicolon, or tab, before starting the import.

Solution 1Recommended

Import a UTF-8 CSV File Using the WPS Spreadsheets Text Import Wizard

Use this method when Japanese, Chinese, Korean, or accented Latin characters appear garbled and you need to explicitly select Unicode UTF-8 encoding.

The Text Import wizard in WPS Office Spreadsheets gives you manual control over file encoding, delimiter, and header detection, preventing the operating system's default non-Unicode encoding from being applied.

1
Open the Data import tool

Open WPS Office Spreadsheets, create a blank workbook, then click the Data tab and choose Import Data > From Text.

2
Select the UTF-8 CSV file

Browse to and select the CSV file, then click Open to launch the Text Import wizard.

3
Set Unicode UTF-8 encoding

In the wizard, choose Delimited, then set File origin or Encoding to Unicode (UTF-8) or 65001.

4
Choose delimiter and header option

Select the delimiter that matches the file, usually Comma, check or uncheck My data has headers as needed, then click Finish.

5
Load the data

Choose the destination cell or use a new sheet, then click OK to load the CSV data without garbled characters.

Import a UTF-8 CSV File Using the WPS Spreadsheets Text Import Wizard
CSV imported successfully: Characters should now display correctly because WPS interpreted the file as UTF-8 instead of the system default encoding.
WPS Spreadsheets

Import UTF-8 CSVs in WPS Office Spreadsheets Without Garbled Characters

WPS Office Spreadsheets includes a Text Import wizard that lets you select UTF-8 encoding explicitly, so Japanese, Chinese, and other multilingual data is preserved when you open CSV files.

  1. 1. Download and install WPS Office: Go to the official WPS Office website, download the free installer for your device, and complete the installation.
  2. 2. Open WPS Spreadsheets: Launch WPS Office and click Spreadsheets to create a new workbook.
  3. 3. Open the Text Import wizard: Click Data > Import Data > From Text and select your UTF-8 CSV file.
  4. 4. Select Unicode UTF-8: Set the file origin or encoding to Unicode (UTF-8) or 65001 and confirm the delimiter.
  5. 5. Load the data: Finish the wizard and load the data into a new sheet to view all characters correctly.
Free spreadsheet tool with UTF-8 CSV import controlsFull compatibility with Microsoft Excel .xlsx, .xls, and .csv filesFamiliar Office-style ribbon UI for easy migrationPreserves Japanese, Chinese, and other non-English characters correctlyLightweight and available on Windows, macOS, Linux, Android, and iOS
microsoft office alternative - wps office

Frequently Asked Questions

Why do I see garbled characters when I open a UTF-8 CSV in Excel or WPS Office?

The application is likely using the system's default non-Unicode encoding. Use the Text Import wizard and set encoding to Unicode (UTF-8) or 65001 so Japanese, Chinese, and other characters are read correctly.

Where can I choose UTF-8 encoding in WPS Spreadsheets?

Go to Data > Import Data > From Text, select the CSV file, choose Delimited, and set File origin or Encoding to Unicode (UTF-8) or 65001 before finishing.

Does WPS Office support opening Excel CSV files?

Yes. WPS Office Spreadsheets is compatible with Excel .xlsx, .xls, and .csv files and includes a dedicated CSV import tool for UTF-8 encoding.

What is the difference between UTF-8 and UTF-8 with BOM?

UTF-8 with BOM adds an invisible marker that helps some applications auto-detect encoding. WPS Office lets you select UTF-8 manually, so files without a BOM can still be imported correctly.

Does this UTF-8 CSV import method work on Mac?

Yes. The same Data > Import Data > From Text workflow is available in WPS Office for Mac. If you use Microsoft Excel for Mac, use its equivalent text import command and select UTF-8.