How to Open UTF-8 CSV Files Correctly in Excel Using a BOM
Question details
The user needs to open UTF-8 encoded CSV files in Excel without special or accented characters displaying incorrectly.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Opening a CSV file containing accented or country-specific characters directly in Excel.
- Observed behavior
- Excel fails to recognize the UTF-8 encoding automatically, resulting in incorrectly displayed characters. It requires a Byte Order Mark (BOM) or explicit import settings to render the text properly.
Before modifying the encoding of your CSV file or adding hexadecimal characters to the content stream, verify the original file's source encoding to ensure no existing special characters are overwritten or lost.
Use the Data Import Feature to Select UTF-8 Explicitly
This is the safest method for standard users to open a UTF-8 CSV file without modifying the file's raw byte contents.
By default, double-clicking a CSV file prompts Excel to use your system's ANSI encoding. Instead of opening the file directly, you can use Excel's built-in import wizard to force the application to read the file as UTF-8.
Launch Excel and open a new, blank workbook.
Go to the 'Data' tab on the ribbon and click on 'From Text/CSV' (or 'From Text' in older versions).
Browse to the location of your UTF-8 CSV file, select it, and click 'Import'.
In the preview window that appears, look for the 'File Origin' dropdown menu. Select '65001: Unicode (UTF-8)' from the list.
Verify that your accented characters look correct in the preview window, then click 'Load' to bring the data safely into your spreadsheet.
Save the CSV as UTF-8 with BOM via a Text Editor
Use a simple text editor like Notepad to resave the file with a Byte Order Mark, allowing Excel to recognize it instantly upon double-clicking.
Programmatically Add the UTF-8 BOM to the File Contents
For users or developers exporting CSV files from code, manually injecting the UTF-8 BOM bytes at the start of the file ensures Microsoft applications read it correctly.
Open UTF-8 CSV Files Flawlessly with WPS Spreadsheet
WPS Spreadsheet offers a highly intuitive Text Import Wizard that automatically detects file encoding or lets you explicitly choose UTF-8, ensuring accented characters and foreign text are never lost or corrupted.
- 1. Open WPS Spreadsheet: Launch WPS Office and open the WPS Spreadsheet application.
- 2. Open Your CSV File: Go to Menu > Open, navigate to your computer's storage, and select the UTF-8 CSV file.
- 3. Configure the Text Import Wizard: The Text Import Wizard will immediately appear. Under the 'File Encoding' dropdown menu, select 'UTF-8'.
- 4. Finish the Import: Confirm your column delimiters (such as commas) and click 'Finish' to successfully view your data with all special characters intact.
Frequently Asked Questions
What is a BOM and why does Excel need it?
A BOM (Byte Order Mark) is a special marker consisting of three bytes placed at the very beginning of a text file to indicate its encoding. Excel relies on the UTF-8 BOM to recognize that a CSV file uses UTF-8. Without it, Excel defaults to the system's ANSI regional encoding, causing special characters to corrupt.
Does the BOM go in the filename or the file contents?
The BOM must be added to the beginning of the file contents, not in the filename. It is a sequence of hidden bytes (Hexadecimal EF BB BF) that resides within the actual file data to instruct software on how to read the text.
Can I force Excel to default to UTF-8 for CSVs without a BOM?
When double-clicking a CSV to open it, Excel natively defaults to the system regional settings unless a BOM is detected. To force Excel to use UTF-8 without adding a BOM, you cannot simply double-click the file; you must use the 'Data > From Text/CSV' import tool inside a blank workbook.
Will a UTF-8 BOM cause problems in other programs?
While Microsoft applications like Excel use the BOM effectively, certain older text editors, programming languages, or UNIX/Linux-based tools may not recognize the BOM properly. In those cases, the BOM might display as odd characters (such as ) at the beginning of the first cell.
