How to Fix Symbols Turning into Question Marks in Excel CSV Files
Question details
The user needs to prevent special characters and symbols from turning into question marks when saving or opening a CSV file.

- Product
- Excel
- Device & OS
- not provided
- Scenario
- Saving, opening, or importing a CSV file containing non-ASCII symbols or special characters.
- Observed behavior
- Special characters are incorrectly displayed and replaced with question marks due to an unsupported character encoding format.
Ensure you have a backup copy of your original spreadsheet before converting file encodings, to prevent any irreversible loss of data.
Save and Import the CSV File Using UTF-8 Encoding in Excel
Explicitly save and import your CSV files using UTF-8 encoding within Excel to ensure all special characters are preserved correctly.
CSV files are plain-text files that default to your system's regional encoding, which may not support complex symbols. By changing the export and import processes to rely on UTF-8, you ensure universal character support.
Open your original workbook in Excel, navigate to File > Save As, and select 'CSV UTF-8 (Comma delimited) (*.csv)' as the file format before saving.
Do not double-click the CSV file to open it. Instead, open a new blank workbook in Excel and select Data > From Text/CSV in the top ribbon.
Locate the CSV file you just saved, select it, and click 'Import'.
In the preview window that appears, change the File Origin dropdown to '65001: Unicode (UTF-8)'. Verify the characters display correctly in the preview, then click 'Load'.

Convert File Encoding Using Notepad++
If you already have a broken CSV file and need to repair or inspect its encoding outside of Excel, use a dedicated text editor like Notepad++.
Handle CSV Encodings Seamlessly with WPS Spreadsheet
WPS Office offers intuitive tools for managing CSV files, ensuring special characters are preserved without complex workarounds. It detects text encodings quickly and gives you full control right when you open the document.
- 1. Launch WPS Spreadsheet: Open WPS Office and start a new blank spreadsheet.
- 2. Open Your CSV: Go to Menu > Open, navigate to your computer's folders, and select your CSV file.
- 3. Choose Encoding Instantly: WPS Spreadsheet will immediately prompt the File Conversion window. Select 'UTF-8' from the encoding list to fix the characters.
- 4. Confirm and Load: Review the data in the preview pane. Once all special characters are visible and correct, click OK to load the file.

Frequently Asked Questions
Why do my CSV files show question marks instead of special characters?
CSV files are plain-text formats. If your computer's default text encoding (like ANSI) does not support the special non-ASCII symbols contained in the file, it replaces the unrecognized symbols with question marks to prevent file corruption.
Can I force Excel to default to opening CSV files in UTF-8?
By default, double-clicking a CSV file opens it using the Windows system regional encoding. To ensure it loads strictly as UTF-8, you must avoid double-clicking the file and instead use Excel's 'Data > From Text/CSV' import feature.
Will converting a file to UTF-8 damage normal text?
No. UTF-8 encoding is fully backward-compatible with standard ASCII text. Your standard English letters and numbers will remain perfectly intact, while special characters and international symbols will gain proper support.




