How to Import Staff & Teacher Data in Bulk
Import all your teaching and non-teaching staff records at once using Excel or CSV files.
How to Import Staff & Teacher Data in Bulk
TL;DR: Download the staff template, fill in employee details, upload, and EduSuite OS creates all staff profiles with role assignments automatically.
Prerequisites
- Admin or Super Admin access
- Staff data in a spreadsheet
- Roles already configured (default roles work for most schools)
Step 1: Download the Staff Template
- Navigate to Staff → Import Staff.
- Click Download Template.
- The template includes fields for both teaching and non-teaching staff.
Template Columns
| Column | Required | Example |
|---|---|---|
| First Name | ✅ Yes | Priya |
| Last Name | ✅ Yes | Mehta |
| ✅ Yes | priya.mehta@school.edu | |
| Phone | ✅ Yes | 9876543210 |
| Role | ✅ Yes | Teacher |
| Department | Optional | Science |
| Designation | Optional | Senior Teacher |
| Date of Joining | Optional | 2020-08-01 |
| Employee ID | Optional | EMP001 |
| Qualification | Optional | M.Sc., B.Ed. |
| Subject | Optional | Physics |
| Class Assignment | Optional | 10-A, 10-B, 11-A |
Step 2: Prepare Your Data
Role Values
Use one of these exact values in the Role column:
Super AdminAdminTeacherAccountantReceptionistLibrarianTransport ManagerSupport Staff
Class Assignment Format
For teachers, list class-section assignments separated by commas:
10-A, 10-B, 11-A
This automatically links the teacher to those classes for attendance, grades, and messaging.
Tips
- Use
YYYY-MM-DDfor all dates - Email addresses must be unique per staff member
- Phone numbers should include country code without +
Step 3: Upload & Review
- Go to Staff → Import Staff.
- Upload your prepared file.
- Review the preview table for errors.
- Fix any red-flagged rows and re-upload if needed.
- Click Import Staff to proceed.
Step 4: Automatic Invitations
After import, EduSuite OS can automatically:
- Send login credentials to each staff member via email.
- Assign them to their respective dashboards based on role.
- Link teachers to their assigned classes.
Toggle "Send Welcome Email" during import to activate this.
Step 5: Verify & Customize
- Go to Staff → All Staff to review imported profiles.
- Click individual profiles to add:
- Profile photo
- Additional qualifications
- Bank details (for payroll)
- Emergency contact information
Updating Existing Staff Records
- Export current data: Staff → Export.
- Edit in your spreadsheet.
- Re-import with "Update Existing" mode enabled.
- Records match by Email or Employee ID.
Troubleshooting
Q: Staff member didn't receive the welcome email. A: Check their email address is correct. Look in spam/junk folders. You can resend from Staff → [Name] → Actions → Resend Invite.
Q: "Role not found" error. A: Ensure the role name exactly matches one of the built-in roles. Custom roles must be created first in Settings → Users & Roles.
Q: Duplicate email detected. A: Each staff member needs a unique email. If two staff share an email, one will need a different address.
Need help migrating from your old HR system? Contact us for migration support.