CSV field notes
Fix the source of the CSV problem.
Practical guides to inconsistent CSV columns, quoting rules, UTF-8 encoding, and reviewing a file before importing it into another application.
CSV structure
Fix inconsistent CSV column counts
Trace a shifted row back to an extra delimiter, a missing field, or a quote.
Read guide →File compatibilityChoose the right CSV encoding
Understand UTF-8, BOM markers, Windows-1252, and what auto-detection can miss.
Read guide →CSV syntaxHandle commas, quotes, and newlines
Read the difference between a delimiter and the same character inside a field.
Read guide →Start with a file, then use the guide that matches the issue.
The CSV validator reports parsing issues. The guides explain why they happen and how to correct the source without silently discarding information.