Fix Missing Accented Characters in UTF-8 CSV Files in Excel
Question details
Determine why accented characters are missing from a CSV file reported to be UTF-8 and import the text correctly.

- Product
- Microsoft Excel 2010 or 2013
- Device & OS
- not provided
- Scenario
- A supplier sends a CSV file containing French accents and other special characters for use in Excel.
- Observed behavior
- Accented characters are missing or corrupted when the CSV file is opened.
Ask the supplier for a sample containing known accented characters and confirm which characters should appear. If the file is confidential, inspect it locally rather than uploading it to an online viewer.
Verify the CSV encoding and import it as UTF-8 in Excel
Use this method to check whether the source contains the expected characters and avoid Excel's automatic encoding detection.
Open a copy of the CSV in a trusted text editor or hex viewer. Compare a known accented word with the supplier's original; for example, UTF-8 encodes ç as the bytes C3 A7.
Ask the supplier to verify the export encoding if the bytes do not match the expected UTF-8 text. Request a correctly encoded UTF-8 export, preferably with a byte order mark (BOM) for older Excel compatibility.
In Excel 2010 or 2013, go to Data > From Text and select the CSV file instead of opening it directly.
In the Text Import Wizard, select UTF-8 under File origin, choose Delimited, and select the delimiter used in the file. Finish the wizard and check the accented text in the imported worksheet.

Open a UTF-8 CSV in WPS Spreadsheets
Use WPS Spreadsheets to import a verified UTF-8 CSV and check that accented characters display correctly. Import options can vary by version.
- 1. Open WPS Spreadsheets: Launch WPS Office and open Spreadsheets.
- 2. Select the CSV: Go to Data and choose the text or CSV import option available in your version, then select the file.
- 3. Set import options: If an import dialog appears, select UTF-8 as the encoding and choose the delimiter used in the CSV, then confirm the import.
- 4. Check the result: Review cells containing known accented words. If they are incorrect, verify the source encoding with the supplier before importing again.

Frequently Asked Questions
Does a UTF-8 CSV need a BOM?
No. UTF-8 files can be valid without a BOM, but a UTF-8 BOM can help older Excel versions recognize the encoding. Ask the supplier to export with a BOM if compatibility is a concern.
Why do accents look wrong when I double-click a CSV?
Excel may interpret the file using a different encoding. In Excel 2010 or 2013, use Data > From Text and select UTF-8 under File origin instead.
How can I check whether an accented character is encoded as UTF-8?
Open a copy in a trusted local hex viewer and inspect a known character. For example, ç is represented by C3 A7 in UTF-8. Compare the bytes with the expected text.
Can changing the encoding recover characters that are missing from the file?
No. If the characters were removed before export, an import setting cannot recreate them. Ask the supplier to export a new CSV from the original data.




