Use bulk import to add many students at once from a spreadsheet. Open this page on a laptop or desktop — it is blocked on mobile.
Go to People → Students and click Import.
Step 1 — Download the template
Click Download template. Open the file in Excel or Google Sheets. It has the correct column headers and example rows.
The columns are:
| Column | Required |
|---|---|
| student_id | No — leave blank for new students |
| first_name | Yes |
| middle_name | No |
| last_name | Yes |
| dob | Yes — format YYYY-MM-DD |
| sex | Yes — M, F, other, or unspecified |
| class_name | Yes — must exactly match a class name in your school |
| guardian_1_email | No |
| guardian_1_relationship | No |
| guardian_2_email | No |
| guardian_2_relationship | No |
Up to 500 students per upload.
Step 2 — Upload your file
Save the filled template and drag it onto the upload area, or click to browse. Accepted formats: .xlsx, .xls, .csv. Maximum file size 10 MB.
Schola parses the file and moves to the preview.
Step 3 — Review and fix
The preview shows every row with any errors highlighted. You can:
- Edit cells directly in the table to fix mistakes.
- Delete any row you want to skip.
- Click Start over to go back and upload a different file.
Every row must be valid before you can import — fix or delete any row with an error. The count at the top shows how many are ready and how many need attention, and the import button stays disabled until none remain.
Step 4 — Commit
When every row is valid, click Import N students. Schola creates the accounts in batches and shows a per-row outcome — created or failed.
Each new student gets a generated Student ID and a system password. After import, go to each student's profile to see and reset their credentials, or use the single-add flow if you need to set a specific password.
Guardians listed in the file are linked automatically if an account with that email already exists, or invited if not.