Import a UTF-8 CSV File in WPS Office Spreadsheets Without Garbled Characters
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.

- 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.
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.
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.
Open WPS Office Spreadsheets, create a blank workbook, then click the Data tab and choose Import Data > From Text.
Browse to and select the CSV file, then click Open to launch the Text Import wizard.
In the wizard, choose Delimited, then set File origin or Encoding to Unicode (UTF-8) or 65001.
Select the delimiter that matches the file, usually Comma, check or uncheck My data has headers as needed, then click Finish.
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 in Microsoft Excel Using Get Data
Use this method if you are working in Microsoft Excel on Windows and prefer Excel's built-in Get Data tool.
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. Download and install WPS Office: Go to the official WPS Office website, download the free installer for your device, and complete the installation.
- 2. Open WPS Spreadsheets: Launch WPS Office and click Spreadsheets to create a new workbook.
- 3. Open the Text Import wizard: Click Data > Import Data > From Text and select your UTF-8 CSV file.
- 4. Select Unicode UTF-8: Set the file origin or encoding to Unicode (UTF-8) or 65001 and confirm the delimiter.
- 5. Load the data: Finish the wizard and load the data into a new sheet to view all characters correctly.

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.




