How to Fix Excel Putting All CSV Data in One Column
Question details
The user needs to understand why an exported CSV file opens with all the data crowded into the first column in Excel and how to properly separate it into individual columns.

- Product
- Microsoft Excel
- Device & OS
- Windows
- Scenario
- Opening an exported CSV file directly in spreadsheet software.
- Observed behavior
- All comma-separated or delimited data appears squeezed into the first column (Column A) instead of spreading across individual columns as intended.
Determine the exact delimiter character (such as a comma, semicolon, or tab) used in your CSV file by opening it briefly in a plain text editor like Notepad.
Declare the Separator Directly in the CSV File
Manually specifying the delimiter at the very top of the CSV file forces Excel to read the columns correctly, regardless of your computer's regional settings.
Excel relies on your Windows regional settings to determine the default list separator. If your system expects a comma but the CSV uses a semicolon, the data won't split. Adding a separator declaration overrides this behavior.
Right-click your CSV file, select 'Open with', and choose Notepad or another plain text editor.
Look at the data to see which character is used to separate the values (for example, a comma ',' or a semicolon ';').
Press Enter to create a new first line at the very top of the document. Type 'sep=' followed immediately by your delimiter character (e.g., 'sep=,' or 'sep=;').
Save the file in your text editor and close it. Double-click the CSV file to reopen it in Excel, and the data will automatically divide into the correct columns.

Use the Text to Columns Feature
Utilize Excel's built-in data separation tool to manually split the combined data into individual columns without editing the raw text file.
Adjust Windows Regional Settings
Modify your system's default list separator to match the delimiter commonly used in your CSV exports so future files open automatically.
Open CSV Files Flawlessly with WPS Spreadsheet
WPS Spreadsheet features an intuitive CSV import wizard that automatically detects or allows you to choose your exact delimiter before the file even opens. This completely eliminates the 'all data in one column' issue caused by regional setting mismatches.
- 1. Open the CSV file: Launch WPS Spreadsheet, click 'Menu', select 'Open', and browse for your CSV file.
- 2. Use the import wizard: When the 'Text Import Wizard' dialog pops up, confirm that the 'Delimited' option is selected.
- 3. Choose your delimiter: Select the specific delimiter used in your file (such as Comma, Space, or Semicolon) from the provided options.
- 4. Complete the import: Check the live preview in the window below to confirm the separation looks correct, then click 'Finish'.

Frequently Asked Questions
Why did my CSV file suddenly start opening in one column?
This usually happens if your computer's regional settings (specifically the list separator) were updated, or if you received a CSV file exported from a different system that uses an alternate default delimiter, such as a semicolon instead of a comma.
What exactly is a CSV delimiter?
A delimiter is a specific character—most commonly a comma, semicolon, or tab—used to separate individual data fields or columns within a plain text file. 'CSV' stands for Comma-Separated Values, but other delimiters are frequently used depending on regional settings.
Can I make Excel default to opening CSVs correctly without changing my Windows system settings?
Yes. By manually adding a specific declaration line like 'sep=,' at the very top of your CSV file using a basic text editor, Excel will override Windows regional settings and use the declared delimiter to properly separate the data into columns.
Does saving the separated data as an XLSX file fix the issue permanently?
Yes. If you first separate the text into columns correctly and then 'Save As' an Excel Workbook (.xlsx), the data structure becomes fixed. The document will remain perfectly formatted in distinct columns the next time you open it, regardless of regional settings.




