You should see RFC4180, aka "[Common Format and MIME Type for Comma-Separated Values (CSV) Files](https://tools.ietf.org/html/rfc4180)", and perhaps this [Wikipedia article on comma-separated values](https://en.wikipedia.org/wiki/Comma-separated_values). Your fields which have embedded doublequote characters do not belong in legitimate CSV. You will need to either get your data into a known format (such as CSV is known to SQLite) or write an importer or translator for your special format. The SQLite extension for CSV does not provide options for eliminating the special meaning of doublequote.