CSV Import: Quotes around fields with commas do not work

I have text fields in my CSV file that contain commas and I have surrounded those fields with double quotes as the documentation says. The plugin is still seeing the commas as delimiters and I get the message "Your file is incorrectly formatted. Please select a valid CSV file."

I can successfully import the file if I remove the commas from the text fields. Also, the quotes get imported if I add them fields.

I tried with this example to double check that I wasn't missing something obvious.

name, age, gender, quote, tags, url
"John", "27", "Male", "Gee, I really like Will's plugin.", "smart, human, Georgia" , "http://www.myysspace.com/pic.gif"

Is invalid while,

name, age, gender, quote, tags, url
"John", "27", "Male", "Gee I really like Will's plugin.", "smart human Georgia" , "http://www.myysspace.com/pic.gif"

works but the values are: "John" "27" etc.. instead of John and 27.

The spaces you have after your commas in your example are the problem. The CSV format expects that you will have only a comma in between fields.

Something like

name,age,gender,quote,tags,url
"John","27","Male","Gee, I really like Will's plugin.","smart, human, Georgia","http://www.myysspace.com/pic.gif"

should work for you.

Ah, thanks. It was a combination of either spaces or " in some of the fields. I appreciate the quick response.