Importing Student Data (CSV)
Bulk import multiple students using CSV files
What is CSV Import?
CSV (Comma-Separated Values) import allows you to add multiple students at once by uploading a spreadsheet file. This is perfect for bulk registration at the start of a semester or when transferring from another system.
Prepare Your CSV File
Create a spreadsheet with the following columns (in this exact order):
firstName,lastName,email,studentId,dateOfBirth,class,phone,address
Example row:
John,Doe,john.doe@email.com,STU001,2005-03-15,Grade 10,555-0123,123 Main St
Save as CSV Format
In your spreadsheet application (Excel, Google Sheets, etc.):
- Click "File" → "Save As" or "Download"
- Choose "CSV (Comma delimited)" or "CSV" format
- Save the file to your computer
Navigate to Import Page
Go to the Students page and look for the "Import CSV" or "Bulk Import" button, usually located near the "Add Student" button.
Upload Your File
Click the "Choose File" or "Browse" button, select your CSV file, and click "Upload" or "Import".
Review and Confirm
The system will show a preview of the students to be imported. Review the list and click "Confirm Import" to complete the process.
CSV Format Requirements
Required Columns
firstName, lastName, email, studentId - these must be present and filled
Optional Columns
dateOfBirth, class, phone, address - can be left empty
Date Format
Use YYYY-MM-DD format (e.g., 2005-03-15)
Unique Values
Email and studentId must be unique - no duplicates allowed
Common Import Errors
❌ Duplicate Email/ID
Solution: Check for duplicates in your CSV and ensure no student is already registered with that email or ID.
❌ Invalid Date Format
Solution: Use YYYY-MM-DD format for all dates (e.g., 2005-03-15, not 03/15/2005).
❌ Missing Required Fields
Solution: Ensure firstName, lastName, email, and studentId are filled for every row.
❌ Wrong File Format
Solution: Make sure you saved as .csv, not .xlsx or .xls.
Tips for Success
- ✓ Test with a small file (5-10 students) first
- ✓ Keep a backup of your original data
- ✓ Remove any special characters from names and addresses
- ✓ Use consistent formatting throughout the file
- ✓ Double-check email addresses for typos