Choose a CSV or Excel file (.xlsx or .xls). For an Excel workbook, the first worksheet containing data is used. The file remains in this browser until you preview and confirm it.
A full register matches pupils by UPN first. When a UPN is unavailable, an exact name is used only when it is unique in both lists, preserving existing loans and history. Ambiguous names must be corrected in the source file. Pupils absent from the file become possible leavers.
2Check the columns
Recognised MIS headings are mapped automatically. Missing optional fields remain ignored; choose a column manually when required. Positional order is used only when the file has no heading row.
Library fields
Your MIS columns
Example
required
✓ Mapped
New
Updates
Unchanged
Errors
Possible leavers
3Review before applying
possible leavers found. Review the highlighted records before applying this full-register import.
Class/Form review ()
Only new classes and MIS names matched to a differently formatted library class are shown here.
MIS Class/Form Name
Year group
Result
Library class used
Error rows are shown first and highlighted in red. Open the original file, correct it, save it, then choose the corrected file above.
borrower matched by name only. The name was unique in both lists, but these matches should be reviewed because a UPN was unavailable.
Possible leavers ()
These active pupils were not matched to the full register. Applying the import adds them to the saved Class progression plan with destination Leavers. Their original class, loans and reservations remain unchanged until that plan is reviewed and finally applied.