CSV opens with everything in one column (wrong delimiter)
Last reviewed 2026-09-19
CSV stands for comma-separated, but many files use semicolons, tabs or pipes, and Excel splits columns using a setting that depends on your regional settings. If the file's delimiter does not match, every row ends up in one column.
Messages you might see
- “All my CSV data is in column A”
- “Excel opens CSV in one column / commas or semicolons not splitting”
Why it happens
- The file uses semicolons (common in Europe) but your Excel expects commas, or the other way round.
- The file is tab- or pipe-separated but named .csv.
- A regional "list separator" setting on your computer does not match the file.
Try this first (free, no tool needed)
- In Excel use Data > From Text/CSV, choose the delimiter in the preview and load.
- Or select the column, then Data > Text to Columns and pick the delimiter.
- You can also change the Windows "List separator" in Region settings, but this affects every program.
If that didn't work
These tools run in your browser. Your file is read and repaired on your own device and is never uploaded.
CSV Delimiter Fixer
Works out whether the file is really comma-, semicolon-, tab- or pipe-separated, reports rows with the wrong number of columns and re-saves it with the delimiter you choose, quoting fields correctly.
Open CSV Delimiter FixerCommon questions
Will it change my data?
No. It only changes the separator and quoting; the values are kept exactly.
Is my file uploaded anywhere?
No. The tool runs as a program inside your own browser, so the file is read and repaired on your device and never sent to a server.