CSV opens in one column in Excel — how to split it correctly

Why Excel puts all your CSV data in column A (common with Dutch/European settings) and how to fix it without losing data.

The message you see
CSV opent in één kolom in Excel
Fastest fix

Upload the file and see exactly which rows cause the problem. Free, and the file stays in your browser.

Fix my one-column CSV →

Why this happens

How to fix it

  1. 1In Excel use Data → From Text/CSV and choose the correct delimiter.
  2. 2Set columns with IDs, postcodes or phone numbers to Text so leading zeros stay.
  3. 3Or convert the CSV to a real .xlsx file once, so it always opens correctly.

Related guides

Still stuck? Ask SheetFix Support