Data Import & Export

Why Excel Does Not Detect UTF-8 Encoding in CSV Files

Khadija KhanKhadija Khan Nov 14, 2026 868 views

Question details

The user wants to understand why Excel does not detect a CSV file as UTF-8 and how to import it correctly.

Why Excel Does Not Detect UTF-8 Encoding in CSV Files
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.
Before you start

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.

Solution 1Recommended

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.

1
Start the import

In Excel, open the Data tab, select From Text/CSV, and choose the CSV file.

2
Choose UTF-8

In the import preview, set File Origin to 65001: Unicode (UTF-8), if it is not already selected.

3
Set the delimiter

Choose the delimiter that matches the file, such as Comma or Semicolon, and check that the preview shows the expected characters and columns.

4
Load the data

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.

Import the CSV with UTF-8 and the correct delimiter
Free Microsoft Office alternative

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.

Open CSV data in WPS SpreadsheetCompatible with Microsoft Excel XLS and XLSX formatsFamiliar spreadsheet interface for users moving from ExcelFree and lightweight office suite
microsoft office alternative - wps office

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.