Why Excel Does Not Detect UTF-8 Encoding in CSV Files
Question details
The user wants to understand why Excel does not detect a CSV file as UTF-8 and how to import it correctly.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Opening or importing a CSV file containing UTF-8 text into Excel.
- Observed behavior
- Excel may guess the wrong encoding or delimiter, causing characters or columns to display incorrectly.
Open the CSV in a text editor and check whether the characters display correctly. Note whether the fields are separated by commas, semicolons, tabs, or another delimiter.
Import the CSV with UTF-8 and the correct delimiter
Use Excel's import controls when opening the CSV directly produces incorrect characters or columns.
CSV files do not consistently identify their encoding or separator. Excel may have to infer both, so automatic detection is not always correct.
In Excel, open the Data tab, select From Text/CSV, and choose the CSV file.
In the import preview, set File Origin to 65001: Unicode (UTF-8), if it is not already selected.
Choose the delimiter that matches the file, such as Comma or Semicolon, and check that the preview shows the expected characters and columns.
Select Load to import the previewed data into the workbook. If a column needs a specific data type, choose Transform Data first and set the type before loading.

Check the CSV encoding and add a UTF-8 BOM
Use a text editor to investigate the file and, if appropriate, save a UTF-8 copy with a byte-order mark that can help Excel recognize the encoding.
Open CSV Files with WPS Spreadsheet
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface. Open CSV files and work with Microsoft Excel formats for an easier transition between office suites.

Frequently Asked Questions
Why do accented characters look garbled in Excel?
Excel may have interpreted the CSV using a different encoding. Try Data > From Text/CSV and select 65001: Unicode (UTF-8) under File Origin, then check the preview.
Why does all my CSV data appear in one column?
Excel may have chosen the wrong delimiter. Import the file through Data > From Text/CSV and select the separator used in the file, such as a comma or semicolon.
Does a UTF-8 CSV need a BOM?
UTF-8 does not require a byte-order mark, but a BOM can help Excel recognize the encoding when opening a CSV directly. You can also explicitly select UTF-8 in the import dialog.
How can I keep leading zeros when importing a CSV?
In the Data > From Text/CSV preview, choose Transform Data and set the affected column's data type to Text before loading it into Excel.




