How to Fix CSV Data Opening in One Excel Column
Question details
The user needs to correctly open CSV files in Excel so that data is separated into multiple columns instead of being grouped into a single column.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Importing or opening CSV files into a spreadsheet application to view and analyze structured data.
- Observed behavior
- All data from the CSV file is placed into the first column instead of being separated into distinct columns, despite regional settings using a comma delimiter.
Ensure your CSV file is not corrupted by opening it in a plain text editor like Notepad to verify that the data is genuinely separated by commas or another distinct delimiter.
Use the Text to Columns Feature
This is the quickest manual method to split data that has already been placed into a single column using a specific delimiter.
Because CSV files do not store complex formatting information, Excel relies on your system locale. If the data combines into one column upon opening, you can manually force Excel to parse the delimiters.
Click on the letter of the column (usually Column A) that contains all of your combined CSV data.
Navigate to the 'Data' tab on the ribbon and click on 'Text to Columns' in the Data Tools group.
In the Text Import Wizard, select the 'Delimited' radio button and click 'Next'.
Check the box for 'Comma' (or whichever character separates your data, such as Semicolon) and click 'Finish'.

Import Data Using Power Query
Ideal for recurring files, Power Query allows you to automate the import, cleaning, and transformation of your CSV data without relying on default locale settings.
Open via Text Editor Workaround
A quick workaround if Excel's direct import features are failing or grayed out.
Easily Import and Format CSV Data with WPS Office
WPS Spreadsheet provides a highly intuitive text import engine that automatically detects formatting delimiters. This ensures your CSV files open correctly in separate columns instantly, saving you from manual adjustments.
- 1. Open WPS Spreadsheet: Launch WPS Office and open a blank spreadsheet.
- 2. Import Your File: Navigate to the Data tab, click on 'Import Data', and select your CSV file from your computer.
- 3. Confirm the Delimiter: The built-in File Conversion dialog will automatically pop up. Confirm the delimiter (like Comma) is selected.
- 4. View Separated Data: Click 'Finish' to instantly insert and view your cleanly separated data.

Frequently Asked Questions
Why does Excel suddenly put all my CSV data into one column?
This usually happens when the CSV file's delimiter (like a comma) doesn't match the 'list separator' defined in your operating system's regional locale settings, causing the application to fail in recognizing where columns begin and end.
Can I change the default delimiter used for CSV files on my computer?
Yes. The default delimiter relies on your OS Regional Settings. In Windows, open the Control Panel, go to Region > Additional settings, and change the 'List separator' character to match your preferred CSV format.
Is there a way to force a CSV file to open correctly without changing system settings?
Absolutely. You can use the Power Query feature (Data > From Text/CSV) to specify the exact delimiter during the file import process, which overrides your system's default list separator for that specific file.




