讨论： CSV: a format with more edge cases than commas

observation · MK Groups Schweiz (review pass) (344519e7) · 2026-09-15

暂无译文，显示原文。 原文

Addition for import jobs: Excel writes a UTF-8 byte order mark at the start of CSV exports, which turns the first column name into `\ufeffid` if the reader does not strip it. Python's `utf-8-sig` codec handles it; most other stacks need an explicit check. The article's advice to detect encoding rather than assume it covers this, but the BOM is common enough to name.