Importing Students in Bulk

29 views

Save time by uploading your entire student list at once using an Excel or CSV file.

Why Use Bulk Import?

If your school already has a student list in Microsoft Excel or a similar spreadsheet, you can upload it directly into SkoolWisely instead of adding students one by one. This saves significant time, especially at the start of a new academic session.

Step 1: Download the Template

SkoolWisely requires your student data in a specific format. Always start with the official template:

Go to Student Management → Import Students.
Click "Download Template".
Open the downloaded file in Microsoft Excel or Google Sheets.

Do not change the column headers in the template. Only fill in the rows below the headers.

Step 2: Fill in the Template

The template contains the following columns:

Column	Description	Required?
First Name	Student's first name	Yes
Last Name	Student's last name	Yes
Admission Number	Your school's unique ID for the student	Yes
Class	Must match a class name already in SkoolWisely	Yes
Gender	Male or Female	Yes
Date of Birth	Format: DD/MM/YYYY	No
Guardian Name	Parent or guardian's full name	No
Guardian Phone	Phone number for SMS notifications	No
Guardian Email	Email for invoice and reminder delivery	No

Step 3: Upload the File

Save your completed spreadsheet as .xlsx or .csv.
Go back to Student Management → Import Students.
Click "Choose File" and select your spreadsheet.
Click "Upload & Import".

Step 4: Review the Import Results

SkoolWisely will process your file and show a summary of the import:

Successfully imported — students added correctly.
Errors — rows that could not be imported, with reasons (e.g., duplicate admission number, unknown class name).

Fix any errors in your spreadsheet and re-upload only the rows that failed.

Tip: Before a full import, test with 5–10 rows first to make sure your file is formatted correctly.

Was this page helpful?

Last updated: July 25, 2026