Why Your CSV Opens in One Column in Excel (and How to Fix It)

You double-click a CSV file and instead of a neat table, Excel shows every row squeezed into column A: id,name,city,total in one cell, then 1,Amina,Fes,120 in the next. Nothing is wrong with the data. Excel simply split the file on a different character than the one the file uses.

Why it happens: the list separator

CSV has no built-in way to declare its delimiter. When you open a CSV by double-clicking it, Excel does not inspect the file; it splits each line on the list separator defined in your operating system's regional settings.

• In the United States, the United Kingdom and many other regions, the decimal mark is a dot, so the list separator is a comma.
• In France, Morocco, Germany, Spain, Italy, Brazil and much of Europe, the decimal mark is a comma (12,5), so the list separator is a semicolon.

The problem appears whenever the two sides disagree. A comma-separated export from a web app opened on a French-configured PC lands in one column, and a semicolon file saved by a European colleague does the same on an American PC. The same mismatch explains why Save As → CSV in Excel produces semicolons on some computers and commas on others.

Fix 1: Import the file instead of double-clicking it

Importing lets you tell Excel which delimiter to use, and it is the fix that works on any computer without changing settings.

1. Open a blank workbook in Excel.
2. Go to Data → From Text/CSV and select the file.
3. In the preview window, set Delimiter to Comma, Semicolon or Tab until the columns look right.
4. Check File Origin: choose 65001: Unicode (UTF-8) if accented or Arabic characters look wrong.
5. Click Load — or Transform Data if you need to set column types, for example to keep leading zeros.

In older versions of Excel, the same option is under Data → From Text (the Text Import Wizard), where you pick Delimited and then the separator.

Fix 2: Split the column you already have

If the file is already open with everything in column A, select column A, go to Data → Text to Columns, choose Delimited, tick the correct delimiter and click Finish. This is quick for a one-off file, but be careful: fields that contain the delimiter inside quotes are handled correctly, while line breaks inside quoted fields are not, because Excel has already split those rows apart.

Fix 3: Convert the file to the delimiter Excel expects

If you send files to people with different regional settings, the most robust solution is to give each of them a file that matches their Excel — or skip CSV entirely and send an .xlsx workbook, which has no delimiter problem at all.

• To produce a semicolon CSV, paste or upload the file in the converter and set Options → CSV output to Semicolon.
• To produce a real Excel file, use CSV to Excel. The delimiter is detected automatically and the workbook opens correctly everywhere.

Fix 4: The sep= line (use with care)

Excel recognises a special first line that declares the separator:

First line of the CSV file

sep=,
id,name,city,total
1,Amina,Fes,120

With that line, Excel splits the file on commas regardless of regional settings. It is an Excel-only convention, though: databases, Python, Google Sheets and most other tools treat sep=, as a data row, and in some Excel versions it interferes with UTF-8 detection. Use it only for files that will exclusively be opened in Excel.

Changing the system list separator

On Windows you can change the list separator itself under Control Panel → Region → Additional settings → List separator. This affects every program on the computer and changes how Excel saves CSV files too, so it is rarely the best choice on a shared or work computer. Prefer importing (Fix 1) or converting the file (Fix 3).

How to avoid the problem when you create CSV files

• Know who will open the file. For a European Excel audience, a semicolon file is friendlier; for software, APIs and databases, use commas.
• Always quote fields that contain the delimiter, a quote or a line break — any proper CSV library or converter does this for you.
• Write UTF-8 with a byte-order mark if the file will be opened in Excel; otherwise accented characters may break (see fixing garbled characters in CSV files).
• If formatting and types matter, send .xlsx instead of CSV.

Summary

A CSV in one column is a delimiter mismatch between the file and Excel's regional list separator. Import the file with Data → From Text/CSV and choose the delimiter, convert it to the separator your audience uses, or send an Excel workbook instead.

Frequently asked questions

More guides

• How to Keep Leading Zeros (and Long Numbers) When Opening CSV in Excel
• Fix Garbled Characters (é, è, ????) in CSV Files Opened in Excel
• How to Flatten Nested JSON into a CSV Table
• JSON Lines (JSONL) Explained: Format, Uses and Common Errors