I know this is an old post but here's the extremely short answer... The line in proper CSV format should be "Samsung U600 24""","10000003409","1","10000003427" Following the 24 you should have 3 double quotes. The first 2 double quotes will make the one double quote in the actual field. The third double quote ends the field started by the doublequote in front of Samsung.