You open a CSV file in Excel and see garbled text, question marks, or strange symbols instead of letters. This happens because Excel is using the wrong character encoding to interpret the file. This article explains why encoding mismatches occur and provides step-by-step methods to open your CSV files correctly.
Key Takeaways: Fixing CSV Encoding in Excel
- Data > Get Data > From Text/CSV: Lets you manually select the correct file encoding before loading the data into a worksheet.
- File > Open > All Files > Encoding dropdown: Uses the legacy import wizard to specify encoding like UTF-8 or Windows-1252 during the file open process.
- Save As UTF-8 with BOM in a text editor: Creates a CSV file with a byte-order mark that Excel can detect automatically to prevent garbled characters.
Why Excel Shows Garbled Text from CSV Files
A CSV file is a plain text file. Character encoding is the set of rules that maps the binary data in the file to readable characters. Common encodings include UTF-8, Windows-1252, and ISO-8859-1. Excel tries to guess the encoding when you double-click a CSV file, but it often defaults to your system’s regional setting, which is frequently Windows-1252 for English systems.
If your CSV file was saved with UTF-8 encoding, which supports international characters, Excel’s guess can be wrong. The program will interpret the bytes using the wrong map, resulting in garbled text. The problem is most common with files containing special characters like accented letters, currency symbols, or text in non-Latin scripts.
Steps to Import a CSV with Correct Encoding
The most reliable method uses Excel’s Power Query tool, which gives you full control over the file encoding before the data appears in your sheet.
- Go to the Data tab
Open a blank Excel workbook. Click on the Data tab in the ribbon. - Click Get Data, then From Text/CSV
In the Get & Transform Data group, click Get Data. Hover over From File and select From Text/CSV from the menu. - Select your CSV file
Navigate to and select the problematic CSV file in the file picker dialog, then click Import. - Choose the correct File Origin
A preview window opens. At the top, click the dropdown for File Origin. A list of encodings appears. Try UTF-8 first. The preview should update to show correct text. - Load the data
If the preview looks correct, click the Load button. The data will be imported into a new worksheet with the proper encoding applied.
Using the Legacy Text Import Wizard
If the Get Data method is unavailable, you can use the older import path. This method requires the Text Import Wizard to be enabled.
- Open Excel and go to File > Open
Do not double-click the CSV file. Start Excel first and go to the File menu, then select Open. - Select All Files and find your CSV
In the Open dialog, next to the file name field, change the file type from All Excel Files to All Files. Browse to and select your CSV file. - Start the Text Import Wizard
Click the Open button. This should launch the Text Import Wizard. If it does not, you need to enable it in File > Options > Data under Show legacy data import wizards. - Set the File Origin
In Step 1 of the wizard, find the File origin dropdown. Select the correct encoding, such as 65001: Unicode (UTF-8). The data preview should change. - Complete the wizard
Click Next, ensure Delimited is selected, click Next again, check the Comma delimiter, then click Finish to import the data.
If the Correct Encoding is Not Listed or Doesn’t Work
Excel Shows Gibberish Even After Selecting UTF-8
The file might be saved in a different UTF format or a specific code page. Try UTF-8 with BOM or Unicode (UTF-16) in the File Origin dropdown. If those fail, the file may be corrupted. Open it in a simple text editor like Notepad. If it looks correct there, use the editor’s Save As function to save a new copy with UTF-8 encoding, then try importing that new file into Excel.
The Text Import Wizard Does Not Appear
The wizard is disabled by default in newer Excel versions. To enable it, go to File > Options > Data. In the Show legacy data import wizards section, check the box for From Text (Legacy). Click OK. The File > Open method will now trigger the wizard for CSV files.
Data is Imported as One Column
This means the delimiter was not recognized. In the Text Import Wizard’s second step, ensure the correct delimiter is checked. For CSV files, it is usually a comma, but sometimes files use semicolons or tabs. The data preview will show vertical lines separating columns when the correct delimiter is selected.
Prevention vs. Correction: Key Differences
| Item | Preventive Method | Corrective Method |
|---|---|---|
| Primary Action | Save source file as UTF-8 with BOM | Use Get Data or Import Wizard in Excel |
| Best For | Users creating or exporting CSV files | Users receiving or opening existing files |
| Tool Required | Text editor like Notepad++ or VS Code | Excel’s built-in data import features |
| Reliability | High, ensures automatic detection works | High, but requires manual selection each time |
| Time Investment | One-time setup during file creation | Required every time a mis-encoded file is opened |
You can now open CSV files with international characters without seeing garbled text. Use the Data > Get Data method for the most control over the import process. For a permanent solution, ask the file creator to save CSVs with UTF-8 encoding including a byte-order mark. An advanced tip is to create a Power Query connection to a CSV folder, setting the encoding once; all future files added to that folder will import automatically with the correct settings.