File Format & Compatibility

Fix Commas in Excel CSV Files When Saving as a Workbook

Natalie TaylorNatalie Taylor Nov 20, 2026 869 views

Question details

The user needs to separate comma-delimited CSV data into Excel columns and save it as a workbook.

Fix Commas in Excel CSV Files When Saving 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.
Before you start

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.

Solution 1Recommended

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.

1
Start the import

In Excel, open a blank workbook and select Data > From Text/CSV. Choose the CSV file and select Import.

2
Check the preview

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.

3
Load the data

Select Load to place the separated data in the workbook.

4
Save as a workbook

Select File > Save As, choose Excel Workbook (*.xlsx), and save the file with a new name or location.

Import the CSV with the correct delimiter and save as XLSX
Commas that remain: Commas that are part of a field's content can remain visible. The original CSV also remains a plain-text file; saving an XLSX copy does not change it.
Open and convert 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. 1. Open the CSV: Launch WPS Spreadsheets and select Open to choose your CSV file.
  2. 2. Choose the delimiter: If an import dialog appears, select Comma as the delimiter and choose an encoding that displays the text correctly.
  3. 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. 4. Save the workbook: Select File > Save As and choose the Excel Workbook (*.xlsx) format.
Open CSV data and check that fields are separated into columnsSave spreadsheets in the Microsoft Excel XLSX formatWork with a familiar spreadsheet interfaceUse WPS Office for free
microsoft office alternative - wps office

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.