Quick answer
The quickest fix: drop the CSV into CSV to Excel and open the .xlsx it gives you — columns split, accents intact, leading zeros kept. In Excel itself, don't double-click: use Data → From Text/CSV, set File origin: 65001 (UTF-8) and the right delimiter, and import ID columns as Text.
What goes wrong — and why
- Everything in column A: Excel uses your regional list separator. In most of Europe that's a semicolon, so a comma CSV isn't split (and the other way round).
- é instead of é: the file is UTF-8, but Excel opens it in an older Windows encoding when there is no "byte order mark".
- Leading zeros gone: 0612345678 and postcode 01234 are turned into numbers.
- 1.23457E+18: long IDs and card numbers become scientific notation, and digits after the 15th are lost.
- Dates swapped: 03/04 can become 3 April or 4 March depending on your settings.
Option 1: convert it to .xlsx first (easiest)
An .xlsx file stores columns, text and numbers explicitly, so Excel can't guess wrong.
Convert CSV to Excel → Detects the separator, keeps zeros and accents, adds a header with filters.Option 2: import it in Excel
- Open an empty workbook and go to Data → From Text/CSV, and choose the file.
- Set File origin to 65001: Unicode (UTF-8) and pick the right Delimiter.
- Click Transform Data, select ID, phone and postcode columns, and set their type to Text.
- Close & Load.
Option 3: Google Sheets or Numbers
Google Sheets (File → Import) and Apple Numbers detect UTF-8 and the separator well; you can then download the sheet as .xlsx.
Making a CSV for someone who uses Excel
Exporting from Excel to CSV for another program? Use Excel to CSV: it writes UTF-8 with a byte-order mark, lets you choose comma or semicolon, and writes dates as 2026-10-25 so no program misreads them.
Frequently asked questions
Why does Excel put my CSV in one column?
The separator in the file doesn’t match your regional settings (comma vs semicolon). Import via Data → From Text/CSV, or convert to .xlsx.
How do I keep leading zeros when opening a CSV?
Import the column as Text in Excel, or convert the CSV to .xlsx with CSV to Excel, which keeps them.
Why do accents look like é in Excel?
The CSV is UTF-8 without a byte-order mark. Set File origin to UTF-8 when importing, or convert to .xlsx.