CSV Opens Wrong in Excel? Here's How to Fix It

Data & Developers · Jul 5, 2026 · 7 views

You double-click a CSV, and Excel dumps everything into column A, mangles your accented characters, or turns "1-5" into a date. These are classic CSV-in-Excel problems — and every one has a fix. Here's how to open a CSV correctly in Excel.

Fix 1: Everything lands in one column

Excel guessed the wrong delimiter based on your regional settings. Instead of double-clicking, use Data → From Text/CSV and pick the comma delimiter, or simply convert the file to a proper workbook first with the CSV to Excel converter, which locks the columns in.

Fix 2: Accented or non-English characters look broken

This is an encoding mismatch — the CSV is UTF-8 but Excel opened it as ANSI. Import via Data → From Text/CSV and choose UTF-8 encoding, or convert to .xlsx where encoding isn't an issue.

Fix 3: Numbers turn into dates or lose leading zeros

Excel auto-formats "3-5" as a date and strips the "0" from "007". Import the column as Text during the From-Text wizard, or convert to .xlsx first so values are preserved.

The simplest fix: convert first

Most of these problems disappear if you convert the CSV to a real Excel file before opening it. Use CSV to Excel — it splits columns correctly and sidesteps the delimiter and encoding guessing entirely.