Having trouble with your employee data importing?
This guide will bring you through all of the different fields in the employee data importing sheets - which fields need to follow our fixed formatting templates and which do not. 😃
Using Importing Sheets in Talenox to Create Employee Profiles in Bulk
To learn how to add employees and open up our employee data importing sheets for mass importing of employee profiles into Talenox, you can refer to our guide on How to Add Employees?
Simply head to Profiles > Manage my database > Employee Listing > Import > Import Employees and select the type of importing sheet you'd like to use (e.g. Excel/Google Sheet):
Employee Importing Sheet Formats
Talenox currently has 2 types of importing sheet formats that you can utilise to mass create employee profiles:
Excel - most frequently used due to ease of transfer of data; most users have their employee data keyed into existing excel sheets
Google Sheets - most accurate for importing
You can select the format that you are most comfortable with using for the importing process. The fields in each type of importing sheet are exactly the same.
Employee Importing Fields
In the importing sheet, there are some fields which have a dropdown list of options to select from:
These fields have a specific template of formatting that it follows. Please always utilise our dropdown list options to fill in each field for employees.
Each column is sensitive to the following inputs (when done manually):
Capitalisation (Capital letter placements)
Spacings between and after letters
Date formatting (Must be in the format of DD/MM/YYYY)
Importing Fields Criteria
You can find the list important of importing sheet fields and the needed criteria to take note of for successful import:
Importing Fields | Criteria for Import | Column in Sheet |
First Name | No template; compulsory for import | B |
Last Name | No template; compulsory for import | C |
| No template; needed for user invites to be sent (in Column G) | F |
Invite User | Fixed template; Compulsory for import | G |
Birth Date | Fixed format (DD/MM/YYYY); Compulsory for import |
P |
Identification Number | No template; compulsory for import | S |
Immigration Status | Fixed template; Compulsory for import | T |
Hired Date | Fixed format (DD/MM/YYYY); Compulsory for import |
BB |
Working Day | Fixed template; Compulsory for import | BI |
Working Hour | Fixed template; Compulsory for import | BJ |
Rate of Pay | Fixed template; Compulsory for import | BK |
Currency of Salary | Fixed template; Compulsory for import | BL |
Basic Salary | Fixed template; Compulsory for import | BM |
Payment Method | Fixed template; Compulsory for import | BQ |
Fixed template; If YES is selected, Compulsory to enter Race, Religion and Immigration Status for import | BV | |
SHG Contribution | Fixed template; If NO is selected, Compulsory for import | BW |
Additional SHG Contribution | Fixed template; Only if needed | BX |
Hope this helps to ease the process of importing your employees into Talenox!