How to Open CSV Files in Excel (Without Breaking Data)

Why Double-Clicking a CSV Often Fails

When you double-click a CSV, Excel opens it using your system's default encoding (e.g. Windows-1252 on Windows) and assumes comma as delimiter. If the file is UTF-8 or uses semicolons, you get:

• Broken special characters (e.g. ü instead of ü, é instead of é)
• Everything in one column when the delimiter is semicolon or tab
• Dates interpreted wrong (e.g. 03/04/2024 as March 4 or April 3 depending on locale)
• Long numbers or IDs converted to scientific notation or truncated

For a full list of CSV pitfalls, see 10 Common CSV Errors and How to Fix Them. Below we focus on the correct way to open CSV in Excel.

Method 1: Use the Data Import Wizard

The most reliable approach is to import the CSV instead of opening it with a double-click.

1. In Excel: Data → Get Data → From File → From Text/CSV (in Excel 365 / 2021). In older Excel: Data → From Text/CSV.
2. Select your CSV file and click Import.
3. In the preview dialog: choose the correct File Origin (e.g. 65001: Unicode (UTF-8) for UTF-8).
4. Set Delimiter to Comma, Semicolon, or Tab as needed. The preview should show columns correctly.
5. For date columns: you can leave as text first, then format after import to avoid wrong conversions.
6. Click Load (or Transform Data if you want to clean in Power Query first).

If your CSV is already clean and UTF-8, you can also use our CSV to Excel converter to produce a proper .xlsx file, then open that in Excel without import issues.

Encoding: UTF-8 vs Windows-1252

UTF-8 supports all characters (accented letters, emoji, etc.) and is the standard for the web and most exports. Windows-1252 (or ISO-8859-1) is common in older European systems. If you see é instead of é, the file is likely UTF-8 opened as Windows-1252.

In the Excel import wizard, set File Origin to 65001: Unicode (UTF-8) when your CSV is saved as UTF-8. If the file was exported from a European system without UTF-8, try Windows (1252) or ISO-8859-1. To fix encoding before opening, use our CSV cleaner to normalize to UTF-8.

Dates and Numbers as Text

Excel may auto-convert dates (e.g. 01/12/2024) to a date serial or swap day/month. To avoid that, in the import wizard you can set specific columns to Text, then after import use Text to Columns or formulas to convert only where needed. For consistent date handling across systems, store dates as YYYY-MM-DD (ISO) in the CSV; our date formatter can normalize existing files.

Leading zeros (e.g. in IDs or postal codes) are stripped when Excel treats the column as number. Import those columns as Text in the wizard to preserve zeros.

Semicolon (;) or Tab Delimiters

In many European locales the list separator is semicolon, so CSV files use ; instead of ,. In the import wizard, set Delimiter to Semicolon. For tab-separated files (TSV), choose Tab. The preview panel shows whether columns split correctly.

Troubleshooting

• All data in one column: Wrong delimiter. Use the import wizard and select the correct delimiter (comma, semicolon, or tab).
• Strange characters (ü, é): Wrong encoding. Re-import with File Origin = UTF-8 (65001), or clean the file to UTF-8 first.
• Dates or numbers wrong: Import problematic columns as Text, then format or convert in Excel as needed.

For more error patterns and fixes, see 10 Common CSV Errors and How to Fix Them.