CSV quote marks broke my parser. 2,000 records silently corrupted.

Got a CSV from the marketing team last week. Simple request: clean it up and import into the database. Opened it in Excel first (mistake #1). Looked fine. 2,000 rows, standard product data. SKU, name, price, quantity. Wrote a quick parser in Python. import csv with open('products.csv', 'r') as f: reader = csv.DictReader(f) for row in reader: print(row) Printed fine. Pushed to the database. Two hours later, the frontend stopped rendering prices correctly. Debugging time. Turns out the CSV had quote marks inside text fields. The product name column had entries like: "Ergonomic Desk Chair (with "ergonomic" mesh)" My parser treated that inner quote as the field terminator. Everything after "with " got truncated. So instead of "Ergonomic Desk Chair (with ergonomic mesh)" we got "Ergonomic Desk Chair (with ". The database had half product names. The frontend was trying to parse "quot; and failing. Excel had hidden this from me. It auto-escapes quotes in the display. The CSV looked clean but the