If this sounds like your week
The download opens as gibberish, or every field crammed into one column.
Accented names show up as "é", a European export packs each row into a single cell, and IDs that started with zeros arrive stripped. The file is fine — your tool just guessed the wrong delimiter or the wrong character encoding when it opened it.
Where tooling usually breaks
Excel guesses, guesses wrong, and mangles your data on the way in.
Double-click a semicolon-delimited or UTF-16 file and Excel often misreads it, splits nothing, or "helpfully" converts long order numbers to scientific notation and drops leading zeros. By the time you notice, the corruption is baked into your edits.