Pupils and admissions

Import pupils from a spreadsheet or pasted list

Preview a class list, save a draft and enrol only the rows you have checked.

3 min readReviewed 27 October 2026

Before you begin

An activated school and a target class.
Permission to create pupils; an Excel or CSV file, spreadsheet rows, or a list of names.

On this page

Step 1. Open the pupil import action from the student workflow. Choose the target class.
Step 2. Upload Excel or CSV, paste spreadsheet rows with headers, or paste one full name per line.
Step 3. Use up to 100 pupils per batch and a file smaller than 1 MB.
Step 4. Preview the rows. Check how full names were split into first name, other names and last name.
Step 5. For an existing class, set the class start date in the current academic year, then review any individual exceptions.

Column	How to use it
First name / Last name	Required for ready rows when using separate name columns.
Name	An alternative full-name column; do not combine it with separate name columns.
Date of birth / Gender	Use accurate known values and review the preview.
Class start date	When the pupil began this class; blank uses today.
School admission date	When they joined the school; blank remains unknown.
Guardian details	Review names, phone, email and relationship before enrolment.

Step 1. Review every row and expand the pupil or guardian details where needed.
Step 2. Fix the validation messages before marking a row ready.
Step 3. Save incomplete work as a named draft if you need to return later.
Step 4. Reopen the saved draft for the same school and class. If another person changed it, reload the current draft before saving again.

Step 1. Review the ready-row count and selected class before starting enrolment.
Step 2. Follow the per-row results. Rows already enrolled remain marked as saved.
Step 3. If the connection is interrupted, reopen or reload the saved draft and check the roll before retrying uncertain rows.
Step 4. Confirm the final pupil count and sample guardian details in Students.

Still need help? Open Support in School Mann or email Warmkeys.