How to Bulk Import Students and Staff from CSV
Stop entering student and staff data one by one. Bulk import from CSV in minutes. Complete guide with sample format. Save hours of data entry.
Excel Academy had 500 new students enrolling. The admin spent 3 days manually entering each student's name, admission number, class, and parent details. It was exhausting.
Then they discovered SkulCBT's bulk import feature. Now they download a CSV template, fill in the data, and upload 500 students in 30 seconds. 99% time saved.
⚡ The Difference:
Before: 3 days entering 500 students manually. After: 30 seconds. That's 99% time saved.
What Can You Bulk Import?
- Students: Names, admission numbers, classes, gender, DOB, parent names, parent phone, parent email
- Staff: Names, staff IDs, positions, qualifications, salary, phone, email
Student Import CSV Format
| first_name | last_name | admission_no | class_name | gender | dob | parent_name | parent_phone | parent_email | address |
|---|---|---|---|---|---|---|---|---|---|
| Adebayo | Ogunleye | HSA-2024-001 | SS1 A | Male | 2008-05-15 | Mr. Ade Ogunleye | 08012345678 | ade@email.com | 12, Lagos Street |
| Chinonso | Okonkwo | HSA-2024-002 | JSS2 B | Female | 2009-08-22 | Mrs. Chi Okonkwo | 08098765432 | chi@email.com | 5, Abuja Road |
💡 The class_name column auto-populates with your school's classes when you download the template.
Staff Import CSV Format
| first_name | last_name | staff_id | position | qualification | salary | phone | address | |
|---|---|---|---|---|---|---|---|---|
| Oluwaseun | Adebayo | STAFF-001 | Senior Teacher | B.Ed | 150000 | 08011223344 | seun@email.com | 23, School Road |
| Funmilayo | Olayemi | STAFF-002 | Principal | M.Ed | 300000 | 08055667788 | funmi@email.com | 10, Admin Street |
How to Bulk Import in SkulCBT
Download CSV Template
Go to Students Import or Staff Import page. Click Download Template. The template auto-generates with your school's class names.
Fill Your Data
Open the CSV in Excel or Google Sheets. Fill student or staff data in the correct columns. Save as CSV.
Upload CSV
Go back to the import page. Click Upload CSV and select your file. The system validates and imports all data.
Review & Confirm
Review the imported data. Confirm and save. All students or staff are now in your system. Ready to use.
Why Bulk Import is Essential
1. Save Hours of Work
Manual entry takes days. Bulk import takes minutes. 99% time saved. Your admin can focus on more important tasks.
2. Reduce Errors
Manual entry leads to typos. Bulk import from CSV ensures consistency. Data is validated before import.
3. Handle Large Enrollments
New students, new staff, transfers — bulk import handles it all. 500+ records in 30 seconds.
4. Data Migration
Moving from Excel to SkulCBT? Bulk import makes migration easy. Export your existing data, format it, and import.
5. Teacher Dashboard
Teachers can see all their students immediately. No waiting for manual entry. Ready to use instantly.
📊 Real Impact:
Excel Academy imported 500 students and 30 staff in 2 minutes. Manual entry would have taken 3 days. That's 23 hours saved.
Tips for Successful CSV Import
- Use the template: Always download the template first. It has the correct column headers and formats.
- Check class names: Class names must match exactly what's in your system. The template auto-populates them.
- Valid dates: Use YYYY-MM-DD format for dates (e.g., 2008-05-15).
- Valid phone numbers: Use 11-digit Nigerian phone numbers (e.g., 08012345678).
- No empty required fields: First name, last name, and class are required for students. First name, last name, and position are required for staff.
- Save as CSV: Save your file as .csv format, not .xlsx.
FAQ — School Admins Ask
What file format is required for bulk import?
SkulCBT supports CSV (Comma Separated Values) files for bulk import. You can create CSV files using Excel, Google Sheets, or any spreadsheet software.
Does the template auto-generate with my class names?
Yes. When you download the student import template, it automatically includes all your school's classes in the class_name column. You just fill in student details.
Can I import staff data from Excel?
Yes. You can import staff from CSV or Excel files. The system validates the data before importing to ensure everything is correct.
What happens if there's an error in my CSV?
The system validates each row. If there are errors, you'll see a report showing which rows have issues. Fix them and upload again.
Start Bulk Importing Today
Join 100+ Nigerian schools using SkulCBT to bulk import students and staff. Save hours. Reduce errors. Get started in minutes.
Ready to Bulk Import?
Import hundreds of students and staff in minutes. Save hours of data entry. Get started now.
📞 Or call: 07032977572