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

Email

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

AT

Rate of Pay

Fixed template; Compulsory for import

BA

Currency of Salary

Fixed template; Compulsory for import

BB

Basic Salary

Fixed template; Compulsory for import

BC

Payment Method

Fixed template; Compulsory for import

BG

SHG Contribution

Fixed template; Compulsory for import

BL


Hope this helps to ease the process of importing your employees into Talenox!

Did this answer your question?