Download an employee list into excel to add new staff members and update details on existing staff members.
- Click Excel Employee Update on left hand navigation
- Click Click here to download employee list , this will open an excel sheet showing all staff members already loaded on the portal
- Update existing employees by finding the line and column and editing the existing record.
- Add new employees by scrolling to the bottom of the list and adding the employee details in the last row and filling in the correct column.
- Upload the edited list
IMPORTANT NOTE: Formatting of information in columns is needed to ensure information is imported correctly.
Here is how you format your excel sheet
|
Column
Name
|
Formatting
|
Mandatory
field
|
What
Information to enter
|
|
FirstName
|
|
Yes
|
The
first name as it appears on the official ID Book or passport
|
|
Surname
|
|
Yes
|
The Surname
as it appears on the official ID Book or passport. If updated recently use
the surname on the most recent document.
New surnames will show in ID verification check if updated at the DHA.
If there is then a non-match on the ID check you will need to update surname
and rerun ID check.
|
|
IdNumber
|
|
Yes
|
ID or
passport number as appears on the official ID Book or passport
|
|
CellNumber
|
TEXT
|
Yes
|
Numeric Characters
only; formatted as TEXT to keep any numbers starting with 0
|
|
TypeOfId
|
ID or
Passport
|
No
|
|
|
DateOfBirth
|
YYYY/MM/DD
|
Yes
|
Date of
birth as per official document e.g. 1955/03/25
|
|
Gender
|
Male or
Female
|
Yes
|
Male or
Female
|
|
PhysicalAddressLine1
|
|
Yes
|
|
|
PhysicalAddressLine2
|
|
No
|
|
|
PostalCode
|
TEXT
|
Yes
|
Numeric
Characters only; formatted as TEXT to keep any numbers starting with 0
|
|
Suburb
|
|
Yes
|
|
|
Province
|
|
Yes
|
Province
must be one of the below options:
·
Gauteng ·
Eastern Cape ·
Free State ·
Western Cape ·
Northern Cape ·
North West ·
Mpumalanga ·
Limpopo ·
KwaZulu Natal
|