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). Sample Employee.xlsx⇩

(The import fields for Employee Master may be different for different HRPro version. To get the full list of fields of Employee Master of your version in Excel, press the Export button to export a full list of fields that match your version.)

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.