CSV opens in one column in Excel: how to fix it

When all your data ends up in column A, Excel is expecting a different delimiter than the one the file uses. The fix is to convert the file to the delimiter your Excel wants.

Open CSVFix

How to fix it

  1. Drop your CSV file on CSVFix. The preview shows whether the columns split correctly.
  2. Note the detected delimiter in the summary line.
  3. Set Output delimiter to the one your Excel expects, usually semicolon or comma, and tick UTF-8 BOM if the file has accents.
  4. Click Download CSV and open it in Excel.

Why it happens

Excel uses the list separator from your operating system’s regional settings to split a CSV. If the file was created with a different delimiter, for example by a program in another country, Excel finds none of its separators and puts each line in a single cell. You can also use Data, then From Text/CSV, in Excel and choose the delimiter manually.

Questions

Which delimiter does my Excel expect?

Try semicolon first if your regional settings use a decimal comma, otherwise comma. If the result is still one column, try the other one.

Can I change the setting in Excel instead?

Yes, through your system’s regional settings, but changing the file is simpler and does not affect other programs.

Will my data change?

No. Only the delimiter between columns is changed.

Ready to clean your file?

Clean your CSV now

More CSV guides