How to Preserve Umlauts and Special Characters in Excel CSV Files with WPS Office
Question details
The user needs to prevent umlauts such as Ü and ö and other Unicode special characters from becoming corrupted when CSV files are saved or opened in Excel-compatible applications.

- Product
- WPS Office Spreadsheets
- Device & OS
- Windows
- Scenario
- The user is exporting or opening CSV files that contain names with umlauts and accented characters and wants them to remain readable without manual correction.
- Observed behavior
- Characters such as Ü and ö become corrupted when a CSV export is opened in Excel.
Open the file in WPS Office Spreadsheets and make a note of the columns or cells that currently show corrupted characters, so you can quickly verify them after re-saving or importing with UTF-8.
Save the CSV with UTF-8 Encoding in WPS Office Spreadsheets
Use this method when exporting data from WPS Office Spreadsheets and you need Excel or other applications to read umlauts and special characters correctly.
UTF-8 CSV preserves Unicode characters. Avoid the default CSV option when the file contains Ü, ö, Ä, ß, or accented characters.
Open the workbook in WPS Office Spreadsheets, click the Menu button in the upper-left corner, and choose Save As.
In the Save As dialog, choose CSV UTF-8 (Comma delimited) (*.csv) from the file type dropdown, or choose CSV and set the encoding to UTF-8 if prompted.
Select the destination folder, click Save, then reopen the file in another spreadsheet application to confirm the special characters remain intact.

Import a CSV File with UTF-8 Encoding in WPS Office Spreadsheets
Use this method when a CSV file opens with corrupted characters and you need to specify UTF-8 during import.
Keep CSV Special Characters Intact with WPS Office Spreadsheets
WPS Office Spreadsheets lets you save and import CSV files with UTF-8 encoding, so umlauts, accents, and other special characters remain readable when shared with Microsoft Excel and other spreadsheet applications.
- 1. Open the CSV-capable workbook: Launch WPS Office Spreadsheets, click Menu > Open, and select the file that contains special characters.
- 2. Re-save using CSV UTF-8: Click Menu > Save As, choose CSV UTF-8 (Comma delimited) (*.csv) as the file type, and save the file.
- 3. Set UTF-8 during import: If characters are already corrupted on import, click Data > From Text/CSV, select the CSV, and set File Origin or Encoding to UTF-8.
- 4. Verify the result: Reopen the saved or imported file and confirm that umlauts and special characters display correctly.

Frequently Asked Questions
Why do umlauts and special characters turn into gibberish in CSV files?
CSV files are plain text, and spreadsheet applications may interpret them with the wrong character encoding. Saving the file as CSV UTF-8 or selecting UTF-8 during import preserves Unicode characters.
Does WPS Office support UTF-8 CSV export?
Yes. In WPS Office Spreadsheets, use Menu > Save As and choose CSV UTF-8 (Comma delimited) (*.csv), or select CSV and set the encoding to UTF-8 if the option is shown.
Can I fix a CSV that already shows corrupted characters?
If the original data is intact, re-import the CSV using Data > From Text/CSV and set the file origin or encoding to UTF-8. If the file was already saved with corrupted characters, restore it from a UTF-8 source or re-enter the affected names.
What is the difference between CSV and CSV UTF-8?
CSV UTF-8 stores text with Unicode encoding, so special characters remain readable. Standard CSV may use the system code page and can corrupt umlauts, accents, and other non-ASCII characters.
Will CSV UTF-8 files open correctly in Microsoft Excel?
Yes. Recent versions of Microsoft Excel support CSV UTF-8. For older versions, use Excel's Data > From Text/CSV import tool and select UTF-8 as the file origin.




