CSV Header Checker: what to check
Header issues are reviewed before other diagnostics. Repairs change the selected heading without renaming unrelated columns or moving data.
Why headers affect an import
Many importers map values by the first record’s column names. A blank heading may leave a field unmapped. A repeated heading can make it unclear which column the application should use, even if the data rows all have the same length.
For duplicate detection, CommaMend compares names after trimming their edges and ignoring letter case. A header named Email and another named email therefore produce a duplicate header error. The actual imported text stays unchanged until you approve a repair.
Use a unique name that also matches the template
A blank heading can receive a Column_3 style suggestion. A repeated heading can receive a unique numbered suffix. Those suggestions make the headings distinct, but they are not a substitute for a platform’s required schema.
If the destination expects GuardianEmail or StudentID, choose Edit Manually and enter that exact name. The editor shows the original value, supports Save and Cancel, and checks the file again after saving. Header edits can be undone.
Keep the fields under the same columns
Renaming a header does not rearrange data, strip leading zeros, or combine columns. If the values themselves are shifted, review the row length and quote diagnostics as well. Download the fixed CSV only after checking the headings against the receiving system’s import instructions.
Try a real CSV example
| Name | (empty header) | ||
|---|---|---|---|
| Ada | ada@example.com | guardian@example.com | Year5A |
The third heading repeats Email and the fourth is empty. Review both one at a time. A school template might require GuardianEmail and Class, but the tool does not assume those meanings.
Download the example CSVSelect the example in the tool above. Your file is processed locally, and changes require your approval.