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 ExcelFastest fix
Upload the file and see exactly which rows cause the problem. Free, and the file stays in your browser.
Why this happens
- The file uses commas, but your regional settings expect semicolons (common in NL/BE/DE).
- The file was exported from Exact Online, Moneybird or a webshop with a different separator.
- Double-clicking the file lets Excel guess instead of asking.
How to fix it
- 1In Excel use Data → From Text/CSV and choose the correct delimiter.
- 2Set columns with IDs, postcodes or phone numbers to Text so leading zeros stay.
- 3Or convert the CSV to a real .xlsx file once, so it always opens correctly.
Related guides
CSV
Strange characters like é or ’ in your CSV — how to fix the encoding
CSVCSV error: “Expected N fields, saw M” / rows have the wrong number of columns
HubSpotHubSpot import error: “Make sure each column with data has a header”
Still stuck? Ask SheetFix Support