Import Students from Excel

Back to Students
Import Instructions
  • Download the Excel template to see the required format
  • Fill in the student data following the template structure
  • Ensure all required fields are filled (marked with *)
  • Faculty and Department names must match existing records
  • File size should not exceed 10MB
  • Supported formats: .xlsx, .xls, .csv
Download Excel Template

Download the template to see the required format and structure for importing students.

Download Template
Supported formats: .xlsx, .xls, .csv (Max size: 10MB)
Required Fields in Excel:
  • student_number - Unique student identifier
  • first_name - Student's first name
  • last_name - Student's last name
  • email - Student's email address
  • phone - Student's phone number
  • date_of_birth - Date of birth (YYYY-MM-DD)
  • faculty_name - Faculty name (must exist)
  • department_name - Department name (must exist)
  • level_of_study - Undergraduate, Masters, PhD, etc.
  • status - Active, Graduated, Suspended, etc.
  • enrollment_date - Date of enrollment (YYYY-MM-DD)
Optional Fields:
  • middle_name - Student's middle name
  • id_number - National ID number
  • nationality - Student's nationality
  • address - Student's address
  • emergency_contact_name - Emergency contact
  • program_name - Academic program name
  • student_type - Regular, Exchange_Incoming, etc.
  • study_mode - Full-time, Part-time, Distance
  • gpa - Grade Point Average
  • notes - Additional notes
Cancel
Sample Data Format
student_number first_name last_name email phone date_of_birth faculty_name department_name level_of_study status
STU001 John Doe john.doe@university.edu +1234567890 2000-01-15 Faculty of Engineering Computer Science Undergraduate Active