Data Import & Export

Fix Excel CSV Import Splitting Commas Inside Quoted Text

Olivia MillerOlivia Miller Nov 14, 2026 868 views

Question details

Import a CSV file into Excel without splitting commas contained in quoted fields.

Fix Excel CSV Import Splitting Commas Inside Quoted Text
Product
Microsoft Excel
Device & OS
not provided
Scenario
Opening or importing a CSV file that contains commas within quoted text values.
Observed behavior
Excel may split quoted values into extra columns or display quotation marks as literal text, particularly when the source file is malformed.
Before you start

Open the CSV in a plain-text editor and identify the delimiter, quotation marks, and encoding used in affected rows. Create a small sample with personal information removed so you can compare the raw text with Excel's import preview.

Solution 1Recommended

Check and correct the CSV structure

Use a sanitized sample to find malformed fields before importing the full file.

1
Inspect affected rows

Open the CSV in a plain-text editor and compare a row that imports correctly with one that splits into extra columns. Check for missing or inconsistent double quotation marks, commas, and line breaks.

2
Correct quoted fields

Ensure a field containing a comma is enclosed in double quotes, such as "Smith, Jane". Represent a literal double quote inside a quoted field with two double quotes, such as "She said ""Hello""".

3
Check the encoding

Use the text editor's encoding or Save As options to identify the file encoding. If you save a corrected sample as UTF-8, select UTF-8 during import when Excel offers an encoding choice.

4
Test the sample

In Excel, choose Data > From Text/CSV, select the sanitized sample, and check the preview. Confirm that quoted commas remain in their fields and that each row has the expected columns before loading.

Check and correct the CSV structure
Check the source export: If many rows are malformed, correct the export settings or source data and generate a new CSV rather than editing each row manually.
Import CSV data with WPS

Open and check CSV data in WPS Spreadsheets

Use WPS Spreadsheets to open a CSV sample, review how its fields are separated, and save the checked data in a spreadsheet format.

  1. 1. Open the CSV sample: In WPS Spreadsheets, select Open and choose the sanitized CSV sample.
  2. 2. Review import settings: If a text import wizard appears, select the correct encoding and comma delimiter. Choose a double-quote text qualifier if that option is available.
  3. 3. Check the columns: Review the imported rows in the worksheet. If quoted values are split, inspect and correct the source CSV in a plain-text editor, then reopen the sample.
  4. 4. Save the result: Once the columns are correct, use File > Save As to save the worksheet as an XLSX file or another supported format.
Preview imported columns and check values containing commasOpen and save Microsoft Excel XLSX filesEdit CSV data in a familiar spreadsheet interface
microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel split a comma inside a quoted CSV value?

The field may have missing or inconsistent quotes, or the import settings may not match the file. Inspect the raw row in a text editor, then use Data > From Text/CSV to check the delimiter and preview.

How should a CSV field contain a literal double quote?

Inside a quoted field, use two double quotes for each literal double quote. For example, "She said ""Hello""" represents the value She said "Hello".

Where can I set the text qualifier in Excel?

If available, use Data > Get Data > Legacy Wizards > From Text (Legacy). In the Text Import Wizard, select Delimited and set Text qualifier to the double quotation mark.

Can an encoding setting fix every CSV import problem?

No. Selecting the correct encoding can fix misread characters, but missing quotes or inconsistent delimiters must be corrected in the source file. Check both the encoding and the affected raw rows.