💻 Software
How do I get Excel to import a CSV file with commas in some of the content fields?
Fresh5 days ago
Mar 15, 2026103616 viewsConfidence Score0%
0%
Problem
How do I get Excel to import my CSV file? File I have a file claiming to be CSV. It contains 10 fields, all of which are surrounded by double quotes (yes, even the dates and numbers.) 2 or 3 of these fields contain commas. But data in these fields is also surrounded by quotes. Problem When I try to…
Unverified for your environment
Select your OS to check compatibility.
1 Fix
Canonical Fix
Unverified Fix
New Fix – Awaiting Verification
Fix for: How do I get Excel to import a CSV file with commas in some of the content fields?
Low Risk
I just tried a quick test that replicated your problem. I created a 1 line CSV in Word (which uses smart quotes) as test.csv “123”,“4,5,6” and it opened in Excel as you described. Try replacing “ and ” with " Having played with your sample I notice …
Awaiting Verification
Be the first to verify this fix
Sign in to verify this fix