Fix Commas in Excel CSV Files When Saving as a Workbook
Question details
The user needs to separate comma-delimited CSV data into Excel columns and save it as a workbook.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Opening a comma-separated CSV file and converting it to an Excel workbook.
- Observed behavior
- Commas remain visible between fields, potentially because Excel expects a different delimiter.
Open the CSV in a text editor to check which character separates the fields. Note whether special characters appear correctly so you can choose the appropriate encoding during import.
Import the CSV with the correct delimiter and save as XLSX
Use Excel's text import controls when CSV fields appear together with commas in one column.
In Excel, open a blank workbook and select Data > From Text/CSV. Choose the CSV file and select Import.
In the import preview, set Delimiter to Comma and choose an encoding that displays the text correctly. Verify that the fields appear in separate columns.
Select Load to place the separated data in the workbook.
Select File > Save As, choose Excel Workbook (*.xlsx), and save the file with a new name or location.

Change the Windows regional format before opening the CSV
Try this Windows option if Excel uses a regional list separator other than a comma when opening CSV files.
Separate CSV data and save it as XLSX in WPS Spreadsheets
Use WPS Spreadsheets to open comma-separated data, check the columns, and save an Excel-compatible workbook.
- 1. Open the CSV: Launch WPS Spreadsheets and select Open to choose your CSV file.
- 2. Choose the delimiter: If an import dialog appears, select Comma as the delimiter and choose an encoding that displays the text correctly.
- 3. Check the columns: Review the opened sheet to confirm that the fields appear in separate columns rather than as comma-separated text in one column.
- 4. Save the workbook: Select File > Save As and choose the Excel Workbook (*.xlsx) format.

Frequently Asked Questions
Why does my CSV open in a single Excel column?
Excel may be expecting a different delimiter because of regional settings. Use Data > From Text/CSV and select Comma in the import preview.
Does saving as XLSX remove commas from the original CSV?
No. File > Save As creates a workbook copy; the original CSV remains plain text with its delimiters.
What if some commas remain after I import the file?
A comma may be part of the actual field content rather than a separator. Check the import preview and the original CSV before removing it.
How do I fix special characters that look wrong in Excel?
Select Data > From Text/CSV and try a different file origin or encoding in the import preview until the characters display correctly.




