Importing CSV into Excel with commas in quoted fields
Fresh3 days ago
Mar 15, 202633568 viewsConfidence Score0%
0%
Problem
I have a CSV file that contains a text field that can have commas in it. When importing it into Excel, it's picking up these commas as field separators. I have the field in quotes, and I've tried double quotes as well. Is there any way I can import this as is or should I convert it to another delim…
Unverified for your environment
Select your OS to check compatibility.
1 Fix
Canonical Fix
Unverified Fix
New Fix – Awaiting Verification
Fix for: Importing CSV into Excel with commas in quoted fields
Low Risk
Make sure there a no spaces between your separated values and wrap each field in quotes: Will import into 2 cells - the first having and the second having
Awaiting Verification
Be the first to verify this fix
Sign in to verify this fix