A value such as "Smith, Jane" contains the delimiter and must be quoted. European exports often use semicolons because the comma is the decimal separator. Let a real CSV parser handle quotes; splitting lines on commas breaks rows.
- Lesson: Import everything as text first
Related: Character encoding, Locale