FAQ‎ > ‎

How to import employee information from Excel?

 
1. Prepare an Excel worksheet with first column [EE_NO] and the rest columns are the fields you wish to update (Refer Import Fields for Employee Master) or download the "Sample Employee Import File.xlsx" for reference.
 
 
2. Open the Employee Master, click the Import button, and select the Excel file to import.
 


This format contain the mandatory fields and will insert new employee (provided that the employee number did not exist in the system).

 When import the Salary Increment for a group of employees, you can add the column [START_DATE] as the effective date of the Salary . e.g.

and these dates will be recorded in Appointment History

If the Auto Number is turned on in Company Setup, you can let HRPro assigns the Employee Number based on the Auto Employee Number.


See also