How to Fix CSV Opening as One Column Instead of Comma-Separated
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.

- 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 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.
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.
Press the Windows key, type 'Control Panel', and press Enter.
Click on 'Clock and Region', and then select 'Region'.
In the Region dialog box under the Formats tab, click the 'Additional settings...' button at the bottom.
Locate the 'List separator' field and change its value to a standard comma (,). Click Apply, then OK.
Close and reopen your spreadsheet program, then save your file as a CSV again. It should now use commas correctly.

Specify the Delimiter During Import
Use this method when importing a CSV into a database tool (like Navicat or SQL Server) or another spreadsheet program without altering your Windows settings.
Use the Text to Columns Feature to Separate Data
If you have already opened the CSV in a spreadsheet program and the data is crammed into one column, you can split it manually without reopening the file.
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. Open WPS Spreadsheet: Launch WPS Office and open your CSV or Excel file.
- 2. Import or Split Data: If data is in one column, select it, go to the 'Data' tab, and click 'Text to Columns'.
- 3. Choose Your Delimiter: Select 'Delimited', choose 'Comma' as your separator, and click Finish.
- 4. Export as Standard CSV: Go to Menu > Save As, and choose 'CSV (Comma delimited)' to securely save the correctly formatted file.

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.




