Guides

How to Open a CSV in Excel Correctly

Double-click a CSV and Excel mangles it: one column, é instead of é, zeros gone. Here is what goes wrong, and three ways to open it properly.

By Diego Callegari · Updated October 2026 · 4 min read

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

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

  1. Open an empty workbook and go to Data → From Text/CSV, and choose the file.
  2. Set File origin to 65001: Unicode (UTF-8) and pick the right Delimiter.
  3. Click Transform Data, select ID, phone and postcode columns, and set their type to Text.
  4. 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.