Bulk Import Students from Excel or CSV
Step-by-step guide to importing hundreds of student records at once using Excel or CSV templates.
Bulk Import Students from Excel or CSV
TL;DR: Download our Excel template, fill in your student data, upload it, and EduSuite OS will create all student records in one go. Supports up to 5,000 students per import.
Prerequisites
- Admin or Super Admin access
- Student data in a spreadsheet (Excel, Google Sheets, or CSV)
- Classes and sections already created in EduSuite OS
Step 1: Download the Template
- Navigate to Students → Import Students.
- Click Download Template to get the Excel (.xlsx) file.
- The template includes all supported fields with example data.
Template Columns
| Column | Required | Example |
|---|---|---|
| First Name | ✅ Yes | Rahul |
| Last Name | ✅ Yes | Sharma |
| Class | ✅ Yes | 10 |
| Section | ✅ Yes | A |
| Roll Number | Optional | 15 |
| Date of Birth | Optional | 2012-05-15 |
| Gender | Optional | Male |
| Parent Name | ✅ Yes | Anil Sharma |
| Parent Email | Optional | anil@email.com |
| Parent Phone | ✅ Yes | 9876543210 |
| Address | Optional | 123 Main Street |
| Blood Group | Optional | B+ |
| Admission Number | Optional | ADM2026001 |
Step 2: Prepare Your Data
Formatting Rules
- Date format: Use
YYYY-MM-DD(e.g., 2012-05-15) - Phone numbers: Include country code without + symbol (e.g., 919876543210)
- Class names: Must exactly match what's configured in EduSuite OS
- Gender: Use "Male", "Female", or "Other"
- No blank rows: Remove any empty rows between data entries
Common Mistakes to Avoid
❌ Using date format DD/MM/YYYY (use YYYY-MM-DD) ❌ Having spaces in class names that don't match ("Class 10" vs "10") ❌ Duplicate phone numbers for different parents ❌ Special characters in names (emojis, unusual symbols)
Step 3: Upload & Preview
- Go to Students → Import Students.
- Click Upload File and select your prepared spreadsheet.
- EduSuite OS will parse your file and show a Preview Table.
- Review the preview carefully:
- ✅ Green rows — Ready to import
- ⚠️ Yellow rows — Warnings (missing optional data)
- ❌ Red rows — Errors (must be fixed before import)
Handling Errors
If errors are found:
- Click Download Error Report to see what went wrong.
- Fix the issues in your original spreadsheet.
- Re-upload the corrected file.
Step 4: Import
- Once all rows show ✅ or ⚠️, click Import Students.
- A progress bar shows the import status.
- When complete, you'll see a summary:
- Total records processed
- Successfully imported
- Skipped (duplicates)
- Errors (if any)
Step 5: Verify
- Navigate to Students → All Students.
- Filter by class to spot-check imported records.
- Click into a few student profiles to verify data accuracy.
Advanced: Updating Existing Records
To update existing student data in bulk:
- Go to Students → Export to download current data.
- Make changes in the exported file.
- Go to Students → Import → Update Existing.
- Upload the modified file.
- EduSuite OS will match records by Admission Number and update accordingly.
Limits & Performance
| Detail | Value |
|---|---|
| Max records per import | 5,000 |
| Supported file types | .xlsx, .xls, .csv |
| Max file size | 10 MB |
| Average import time | ~30 seconds per 1,000 records |
Troubleshooting
Q: Import stuck at "Processing". A: For large files (3,000+ records), processing may take 2-3 minutes. Refresh the page after waiting. If still stuck, try splitting into smaller batches.
Q: "Class not found" error. A: The class name in your spreadsheet doesn't match EduSuite OS. Go to Settings → Academics → Classes to verify exact names.
Q: Duplicate students detected. A: EduSuite OS checks for duplicates by name + parent phone. If a legitimate new student is flagged, use "Force Import" on that row.
Need help with data migration from another system? Contact our migration team for hands-on assistance.