Getting started
Import learners from Excel
Which columns the learner spreadsheet needs, what is optional, and how parents are linked.
Updated 16 November 2026
You can add a whole school of learners at once from a spreadsheet. Open Learners and choose Import, export and more → Import learners, or use step 1 of Bring Your Data. Download the template first.
Required columns
- Admission Number. Leave it blank if your school has admission numbers generated automatically.
- First Name
- Last Name
- Class. It must match a class that already exists, written the same way, for example "Grade 1 Blue".
Optional columns
- Middle Name, Date of Birth, Gender, Email, Phone
- NEMIS Number, Assessment Number, Assessment Year
- Former School details
- KEMIS fields
Linking parents
Add Parent Name and Parent Phone on the learner's row and EduPro links the parent. Parent Email is optional. If a parent with that phone or email is already in EduPro, the learner is linked to them, so brothers and sisters share one parent.
Name and phone are needed together. If a row has only one of them, the learner is still imported, without a parent, and you get a warning for that row.
Create your classes before importing. The most common import error is a class name in the file that doesn't match a class in EduPro, such as "Grade 1B" when the class is "Grade 1 Blue".
File types
.xlsx, .xls and .csv all work. If something is refused, see Import errors and how to fix them.