Public extracts usually fail in pagination or scope. A quieter killer: the file is “correct” in Python and wrong the moment a buyer opens it. Before you hand off a public-source CSV, run these five checks: UTF-8 with an explicit BOM when Excel is in the loop — macOS Numbers / pandas often hide ...
Source: [Dev.to](https://dev.to/kzahiri/your-public-csv-looks-fine-until-excel-opens-it-charset-bom-and-timezone-traps-3p15)