Fix Excel CSV Import Splitting Commas Inside Quoted Text
Question details
Import a CSV file into Excel without splitting commas contained in quoted fields.

- 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.
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.
Check and correct the CSV structure
Use a sanitized sample to find malformed fields before importing the full file.
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.
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""".
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.
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.

Import with the correct delimiter and text qualifier
Use Excel's import settings when the CSV structure is valid but the default import does not recognize it correctly.
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. Open the CSV sample: In WPS Spreadsheets, select Open and choose the sanitized CSV sample.
- 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. 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. Save the result: Once the columns are correct, use File > Save As to save the worksheet as an XLSX file or another supported format.

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.




