School CSV File Fixer: what to check
This page prioritizes header and row structure checks for school imports. It does not certify compatibility with a particular school management system.
Start with your school system’s template
Export or download the required import template from the receiving system. Keep its column order and exact required header names. Student, attendance, enrollment, and grade files can have different schemas even within the same school platform.
CommaMend can detect a blank or repeated heading, uneven records, quote errors, and possible encoding problems. It does not validate enrollment rules, grade ranges, mandatory fields for a specific provider, or whether a student identifier exists in your system.
Preserve identifiers and protect student records
Student ID 00018 remains text with its leading zeros. Dates and class codes are not automatically reformatted. When a class name contains an unquoted comma, choose the fields that belong together and check the preview against the import template.
Local file processing means the selected CSV is not sent to a server. Prefer selecting a file from your device for sensitive school records. A CSV URL import contacts the source directly. Use only files you are authorized to handle and follow your school’s data handling policy.
Review duplicates in context
Two identical student rows may be an accidental copy, but repeated attendance or assessment events may be legitimate. Review the context before removing a record. After correcting structural errors, test the import with the receiving system’s preview and keep the original export as a backup. The sample below contains fictional data only.
Try a real CSV example
| StudentID | FirstName | LastName | Class | GuardianEmail | |
|---|---|---|---|---|---|
| 00017 | Ada | Patel | Year5A | guardian@example.com | |
| 00018 | Sam | Chen | Year5 | GroupB | guardian2@example.com |
The sample’s second student record has an extra field in the class name. If the intended class is “Year5,GroupB”, combine columns 4 and 5 and keep StudentID 00018 unchanged.
Download the example CSVSelect the example in the tool above. Your file is processed locally, and changes require your approval.