Your public CSV looks fine until Excel opens it — charset, BOM, and timezone traps

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 the problem; Windows Excel silently mangling café /... Weiterlesen: Your public CSV looks fine until Excel opens it — charset, BOM, and t…