File Format & Compatibility

How to Fix Symbols Turning into Question Marks in Excel CSV Files

Kushani NimanthikaKushani Nimanthika Nov 11, 2026 869 views

Question details

The user needs to prevent special characters and symbols from turning into question marks when saving or opening a CSV file.

How to Fix Symbols Turning into Question Marks in Excel CSV Files
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.
Before you start

Ensure you have a backup copy of your original spreadsheet before converting file encodings, to prevent any irreversible loss of data.

Solution 1Recommended

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.

1
Save as CSV UTF-8

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.

2
Use the Import Tool

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.

3
Select the CSV File

Locate the CSV file you just saved, select it, and click 'Import'.

4
Set File Origin to UTF-8

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'.

Save and Import the CSV File Using UTF-8 Encoding in Excel
Proper Data Formatting: Using the Data import wizard forces Excel to recognize the UTF-8 encoding, preventing any unwanted symbol modifications.
Easy CSV Management

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. 1. Launch WPS Spreadsheet: Open WPS Office and start a new blank spreadsheet.
  2. 2. Open Your CSV: Go to Menu > Open, navigate to your computer's folders, and select your CSV file.
  3. 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. 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.
Fully compatible with Microsoft Excel CSV and XLSX formats.Automatically prompts an easy-to-use Text Import wizard when opening CSVs.Lightweight, free, and designed with a highly familiar user interface.
microsoft office alternative - wps office

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.