Import students from a spreadsheet

From your dashboard, go to Batch Upload in the menu. You'll see three tabs at the top: Students, Staff, and Grades. Make sure you're on the Students tab.

Click CSV Template or Excel Template at the top of the page. Both files have the same columns; pick whichever is easier for you to fill in. Open the file in Excel, Google Sheets, or any spreadsheet program.

The file already includes the column headings, in the exact order Edunile expects. Don't rename or rearrange the columns — leave them as they are, and just fill in your data underneath.

For each student, fill in one row. The most important columns are:

• student_first_name and student_last_name — the student's name as you want it to appear on report cards.
• class — the exact name of the class, e.g. JSS 1 A (must match a class you've already created).
• parent_first_name and parent_last_name — the parent or guardian's name.
• parent_phone or parent_email — at least one of these so you can reach them with bills and updates.

Other columns (gender, date of birth, admission number, etc.) are optional but worth filling in if you have them. Save the file when you're done.

Back on the Batch Upload page, click the upload area and pick the file you just saved (or drag and drop it onto the page). Edunile reads your file straight away and shows you a preview of every row.

Rows with missing or wrong information are marked in red. Common reasons a row is flagged:

• Missing first or last name.
• A class name that doesn't match any class in your account.
• A parent row with neither phone nor email filled in.

For small mistakes, you can fix them directly in the preview without re-uploading. For bigger problems, fix the spreadsheet, save it, and click Replace File to re-upload.

You can't proceed while red rows remain — Edunile won't let you import incomplete records.

When all rows look right, click Start Import. Edunile imports your students in the background — for a few hundred students, this usually takes 1–3 minutes. You can leave the page or switch tabs; we'll keep a progress bar at the top.

When the import finishes, you'll see a summary: how many students were added, how many parents were created (or matched to existing parent accounts), and any rows that failed at the last step.

Go to Students → All Students and pick one of the students you just added. Check that the class is right, the parent is linked, and the contact details look correct. If something's off, you can edit the student or the parent directly.