File Format & Compatibility

How to Fix CSV Opening as One Column Instead of Comma-Separated

Steven ParkerSteven Parker Oct 28, 2026 876 views

Question details

The user is experiencing an issue where a CSV file exported from a spreadsheet program displays all data grouped into a single column when opened in text editors, Word, or database tools, rather than being correctly separated by commas.

How to Fix CSV Opening as One Column Instead of Comma-Separated
Product
Spreadsheet Software
Device & OS
Windows
Scenario
Exporting or importing CSV files for plain-text viewing, database upload, or cross-application data transfers.
Observed behavior
The CSV data is squashed into a single column instead of being parsed into individual, comma-separated fields.
Before you start

Before changing any system settings, open your CSV file in a plain-text editor like Notepad to verify whether commas actually exist between your data fields or if another character (like a semicolon) was used.

Solution 1Recommended

Modify Windows Regional List Separator Settings

Use this solution to ensure that your operating system tells spreadsheet programs to use a comma as the default delimiter for CSV files, which is especially useful if your regional format defaults to a semicolon.

In many regions, Windows sets the default list separator to a semicolon because the comma is reserved as a decimal mark. This causes Excel and other tools to export CSVs using semicolons instead of commas.

1
Open Windows Control Panel

Press the Windows key, type 'Control Panel', and press Enter.

2
Access Region Settings

Click on 'Clock and Region', and then select 'Region'.

3
Open Additional Settings

In the Region dialog box under the Formats tab, click the 'Additional settings...' button at the bottom.

4
Change the List Separator

Locate the 'List separator' field and change its value to a standard comma (,). Click Apply, then OK.

5
Re-export the CSV

Close and reopen your spreadsheet program, then save your file as a CSV again. It should now use commas correctly.

Modify Windows Regional List Separator Settings
System-Wide Change: Modifying this setting ensures that all future CSV files generated by programs relying on Windows system settings will be perfectly comma-separated.
Efficient CSV Processing

Easily Manage and Export CSV Files with WPS Spreadsheet

WPS Office provides robust tools for importing, viewing, and exporting CSV files without delimiter errors. You can precisely control your data separators using the built-in Text to Columns feature and save files with perfect comma-separated compatibility.

  1. 1. Open WPS Spreadsheet: Launch WPS Office and open your CSV or Excel file.
  2. 2. Import or Split Data: If data is in one column, select it, go to the 'Data' tab, and click 'Text to Columns'.
  3. 3. Choose Your Delimiter: Select 'Delimited', choose 'Comma' as your separator, and click Finish.
  4. 4. Export as Standard CSV: Go to Menu > Save As, and choose 'CSV (Comma delimited)' to securely save the correctly formatted file.
Accurate CSV import wizard for defining custom delimiters upon openingSeamless format compatibility with Microsoft Excel (.xlsx, .xls, .csv)Built-in 'Text to Columns' tool to split single-column data quicklyFree, lightweight, and fast alternative to heavy spreadsheet programs
microsoft office alternative - wps office

Frequently Asked Questions

Why does my CSV file use semicolons instead of commas?

In certain regions (such as many European countries), the operating system uses a comma as the decimal symbol. To avoid confusing numbers with delimiters, Windows defaults the list separator to a semicolon, causing spreadsheet software to export CSVs with semicolons.

How do I fix a CSV that opens as one long string of text in Notepad?

If it appears as one string without line breaks, the file may have been saved with incorrect line ending formats (e.g., Mac legacy formats). You can fix this by opening the file in a spreadsheet program or advanced text editor like Notepad++ and re-saving it with standard Windows CR LF line endings.

Will changing Windows regional settings affect other programs?

Yes. Changing the 'List separator' in the Windows Control Panel is a system-wide setting. It will affect how any installed application that relies on regional settings exports and interprets lists.

Is there a way to force Excel or WPS to use commas without changing system settings?

While saving directly as a CSV generally defers to system settings, you can bypass this by writing an export macro (VBA script) that manually inserts commas, or you can use the 'Save As' feature in a dedicated database or text manipulation tool.