Why UTF-8 BOM bites
Excel-exported UTF-8 CSV often starts with an invisible BOM.
That can turn your first header into something like `\uFEFFid`, breaking key lookups and validation.
Delimiters and quoting
Commas inside fields require quoting; embedded quotes must be doubled.
Semicolon-separated CSV is common in some locales—column shifts usually mean a delimiter mismatch.
Workflow
Convert CSV → JSON locally to inspect structure before integrating.
When exporting JSON → CSV, keep a stable column order to make diffs meaningful.