Data Import & Export

How to Fix CSV Data Opening in One Excel Column

John WilsonJohn Wilson Nov 4, 2026 872 views

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.

How to Fix CSV Data Opening in One Excel 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.
Before you start

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.

Solution 1Recommended

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.

1
Select the Data Column

Click on the letter of the column (usually Column A) that contains all of your combined CSV data.

2
Open Text to Columns

Navigate to the 'Data' tab on the ribbon and click on 'Text to Columns' in the Data Tools group.

3
Choose Delimited Option

In the Text Import Wizard, select the 'Delimited' radio button and click 'Next'.

4
Select the Delimiter

Check the box for 'Comma' (or whichever character separates your data, such as Semicolon) and click 'Finish'.

Use the Text to Columns Feature
Quick Formatting: Your data should immediately split into separate columns based on the comma delimiter you specified.
Seamless CSV Import

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. 1. Open WPS Spreadsheet: Launch WPS Office and open a blank spreadsheet.
  2. 2. Import Your File: Navigate to the Data tab, click on 'Import Data', and select your CSV file from your computer.
  3. 3. Confirm the Delimiter: The built-in File Conversion dialog will automatically pop up. Confirm the delimiter (like Comma) is selected.
  4. 4. View Separated Data: Click 'Finish' to instantly insert and view your cleanly separated data.
Smart detection of commas, tabs, and custom delimiters.Fully compatible with Microsoft Excel file formats (.xlsx, .csv).Free, lightweight, and fast spreadsheet processing.Familiar user interface requiring zero learning curve.
microsoft office alternative - wps office

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.