File Format & Compatibility

How to Preserve Umlauts and Special Characters in Excel CSV Files with WPS Office

Camila MilosovichCamila Milosovich Nov 13, 2026 869 views

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.

How to Preserve Umlauts and Special Characters in Excel CSV Files with WPS Office
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.
Before you start

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.

Solution 1Recommended

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.

1
Open Save As

Open the workbook in WPS Office Spreadsheets, click the Menu button in the upper-left corner, and choose Save As.

2
Select CSV UTF-8 format

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.

3
Save and verify

Select the destination folder, click Save, then reopen the file in another spreadsheet application to confirm the special characters remain intact.

Save the CSV with UTF-8 Encoding in WPS Office Spreadsheets
WPS Office Spreadsheets solution

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. 1. Open the CSV-capable workbook: Launch WPS Office Spreadsheets, click Menu > Open, and select the file that contains special characters.
  2. 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. 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. 4. Verify the result: Reopen the saved or imported file and confirm that umlauts and special characters display correctly.
Preserves Unicode text such as Ü, ö, Ä, and accented characters in CSV files.Opens and saves .xlsx, .xls, and .csv files with Microsoft Excel compatibility.Free and lightweight Office suite with a familiar spreadsheet interface.CSV import tools let you set UTF-8 encoding to repair corrupted text.
microsoft office alternative - wps office

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.