CSV Extra Rows or Shifted Columns
Unescaped delimiters or malformed quotes break row structure.
LIKELY CAUSE
Why it happens
Inspect rows containing commas/semicolons inside text and verify quoting.
SAFE FIX
What to do
Use a real CSV parser rather than splitting on commas.
Debug in this order
- Reproduce the problem on the smallest sample that still fails.
- Inspect the exact keys, types, ranges or markup involved instead of only the displayed value.
- Fix the root cause, then rerun the original case and one known-good case.
- Document the rule if the same problem can return in recurring work.
Do not hide an unexplained data error with a cosmetic workaround. Make the input and matching logic predictable first.