Import Staff from Excel

Back to Staff
Import Instructions
  • Download the Excel template to see the required format
  • Fill in the staff 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 staff.

Download Template
Supported formats: .xlsx, .xls, .csv (Max size: 10MB)
Required Fields in Excel:
  • staff_number - Unique staff identifier
  • first_name - Staff's first name
  • last_name - Staff's last name
  • email - Staff's email address
  • phone - Staff's phone number
  • date_of_birth - Date of birth (YYYY-MM-DD)
  • faculty_name - Faculty name (must exist)
  • department_name - Department name (must exist)
  • position - Staff position/title
  • employment_type - Full-time, Part-time, Contract, Temporary
  • status - Active, Inactive, On Leave, Terminated
  • employment_start_date - Date of employment (YYYY-MM-DD)
Optional Fields:
  • middle_name - Staff's middle name
  • gender - Male, Female, Other
  • nationality - Staff's nationality
  • id_number - National ID number
  • address - Staff's address
  • emergency_contact_name - Emergency contact
  • emergency_contact_phone - Emergency contact phone
  • employment_end_date - End date if applicable
  • salary - Salary amount
  • notes - Additional notes
Cancel
Sample Data Format
staff_number first_name last_name email phone date_of_birth faculty_name department_name position status
STF001 John Doe john.doe@university.edu +1234567890 1980-01-15 Faculty of Engineering Computer Science Professor Active