Home › Guides › CSV opens in one column

CSV opens in one column in Excel? How to fix it

When every row lands in column A with commas or semicolons still in the text, Excel guessed the wrong separator. The data is fine; Excel just needs to be told how to split it.

Updated October 2026

Why it happens

When you double-click a CSV, Excel splits it using your computer's list separator. In the US and UK that is a comma. In much of Europe and Latin America, where the comma is the decimal mark, it is a semicolon. A comma-separated file opened on a semicolon computer (or the other way round) ends up in one column.

Fix 1: import it with the right separator

This works on any computer and doesn't change the file.

1. Open a blank workbook in Excel.
2. Go to Data › From Text/CSV (on a Mac: File › Import › CSV file).
3. Pick the file. In the preview, set Delimiter to Comma or Semicolon until the columns look right.
4. Set File Origin to 65001: Unicode (UTF-8) if accents look wrong, then click Load.

Importing also lets you mark ID or zip-code columns as Text, so leading zeros survive.

Fix 2: the sep= trick

Add a first line to the file that says sep=, (or sep=;) and save it. Excel reads that line as an instruction and splits the file correctly when you double-click it. Other programs will see it as an extra row, so only use it for files meant for Excel.

Fix 3: save it with the separator Excel expects

If you are making the CSV yourself, choose the separator of the computer that will open it. In our converter, set Separator to Semicolon for Excel in most of Europe, and Encoding to UTF-8 with BOM so accents show correctly when the file is double-clicked.

Fix 4: change the Windows list separator

In Windows, open Control Panel › Region › Additional settings and set List separator to a comma. This changes how Excel reads and writes every CSV on that computer, and can affect formulas in other programs, so only do it if you work with comma files every day.

Open the converter