CSV Opens in One Column? Fix the Delimiter

What the error actually means

If every row appears in column A, the data is usually intact. Excel or another spreadsheet app has interpreted the whole line as one value because the file delimiter does not match the delimiter expected by your regional settings or import dialog.

Likely causes

• The file uses semicolons while the spreadsheet expects commas.
• The file is tab-delimited but has a .csv extension.
• Excel opened the file directly instead of using its text-import workflow.
• The delimiter also appears inside values and those values were not quoted correctly.

A safe repair workflow

1. 1Open the file in the delimiter changer and inspect the detected separator.
2. 2Choose the delimiter required by the destination application. A comma is common; some European Excel installations expect a semicolon.
3. 3Convert the file, download the result, and import it through the spreadsheet application’s data-import command.
4. 4Confirm the preview shows separate fields before completing the import.

How to verify the result

A file that downloads successfully is not automatically a correct file. Check the result at both the structural and business-data levels:

• The header occupies multiple columns.
• Quoted values containing commas remain in one cell.
• The row count matches the source file.
• Accented characters still display correctly.