CSV Opens in One Column in Excel? Fix the Delimiter

First, identify the actual separator

Open the original file in a plain-text editor and look at a typical row, not only the header. id,name,city is comma-delimited; id;name;city uses semicolons. Tabs may be harder to see, so move the cursor through a row or inspect the file with an editor that displays whitespace. The extension .csv does not guarantee that every file uses a comma.

Be careful with quoted values. In 17,"London, UK",active, the comma inside the quoted city belongs to one field. A simple find-and-replace on commas will damage the data. A proper CSV import recognizes the quote rules while splitting rows into columns.

Best fix: reimport the original CSV

1. In a blank Excel workbook, choose Data > From Text/CSV and select the original file.
2. Set the delimiter to the separator you found. If letters look corrupted, also change the file origin or encoding until the preview is readable.
3. Check a row with a quoted delimiter and a row near the end of the file. For IDs with leading zeros or long numbers, choose text handling before loading.
4. Load the table and save as .xlsx if you need to keep it as an Excel workbook.

The import preview is the point to catch wrong column boundaries before Excel writes them into cells. See Microsoft's CSV import instructions for the controls available in Excel. Our full CSV import guide also covers encoding, dates, and identifiers.

Already have rows in column A? Use Text to Columns

If you cannot reimport, select the affected column, open Data > Text to Columns, choose Delimited, and check only the separator the file actually uses. Review the preview and destination before finishing. Make room for the output columns first: splitting into occupied cells can overwrite neighboring data. If exact identifiers matter, set their destination column type to text where the wizard allows it.

This option is for text that is already in cells. It cannot reliably undo values Excel changed when the CSV was first opened. For example, if 00054 has already become 54, splitting the column does not restore those zeros. Start from the untouched CSV instead. Microsoft documents the Text to Columns wizard and its separator and destination settings.

Check the delimiter before downloading an XLSX

The CSV to Excel converter shows a parsed table before you download. If its preview also shows one column, change the delimiter there and confirm that a quoted comma stays inside its field. The tool writes all CSV fields to a real .xlsx workbook as text, which can help preserve codes and long identifiers. Its ten-row initial preview can expand to 100 rows; the exported workbook still contains all parsed rows.

If changing the delimiter does not help, check whether the file is truly delimited text and whether its encoding is correct. A file mislabeled .csv might be fixed-width text or an Excel workbook. In that case, use the tool or import option that matches the actual file format. Before sharing the result, compare the header, a middle row, and a row with a quoted separator against the original text.