Importing employees in batch from an Excel file

Importing employees in batch from an Excel file

Emprez offers you the possibility of importing employees from an Excel template. You can download the template directly from the application.
For companies that have Desjardins or Nethris as their web service, consult the article on importing employees through the web service in order to import your employees' files directly from your web service.
To import your employees in batches from an Excel file, follow these steps: 
  1. Click on the Employee tab, then Create / Import an employee 
  2. In the menu Import Employees from a file, click on Excel Template to download the template that you will use to create employees 
  3. Download your structure, it will be useful later.

  1. Enter the employee information in the downloaded template
Here is the format to respect for the different cells and the mandatory cells: 
  1. Enter the Employee number,
  2. Enter the first and last name in their respective boxes,
  3. Enter the gender: F for female or M for male,
  4. Under Date of birth/seniority/hiring date: 2018/07/20  * Be careful to put "/" and not "-"
    If this is not the format you have, change the format of the cell in the cell properties.
  5. Under Unit owning job: copy and paste the fields of your structure to your list of employees on which you work,

  1. Under Position: 15.25 *Put a "." instead of "," for cents,
  2. Under Schedule type: mark one of the following three terms: Régulier, Probation ou Partiel,
  3. Under Position type: Permanent, Contractual, Probation, Intern, Temporary, Occasional or Temporary (80 days and +),
  4. Under Bonus on Job: mark the exact name of the bonus already created in Emprez,
  5. Save the file on CSV UTF-8 format.
Warning:
It is important that the name of the payroll company, the Unit owning job, as well as the position, are exactly the same as the terms used in your structure otherwise the system will not be able to export the data to Emprez. You must pay particular attention to spaces and capital letters.
Remove unnecessary empty boxes. Leave no space between one employee and another.
5. Import your document
  1. Choose the company in which you want to add the employees contained in your work file.
If after all these steps your file turns out to be rejected, do not hesitate to send us a ticket with your file attached.

    • Related Articles

    • Modification of the employee file (used for sorting) in batch

      For more information on the sort order and its functions, click here.  Click on the Employee menu, Choose Modify Employee Sorting Order (batch), Select the employees: by the enterprise, OR by service/department OR by position, Click on Search, Check ...

    • Employee file creation

      If you are responsible for entering data in Emprez during hiring, be aware that the Parameters profile option allows you to copy settings from one employee to another employee who occupies the same position. There are 3 methods to create employees ...

    • Import of your employee files from your payroll system

      This option is currently only available to customers with the following payroll service AND whose Web service is activated: Nethris Employer D (Desjardins) This feature assumes that you have linked your Emprez account with your payment system. You ...

    • Employee file: Demographic information & calendar synchronization

      Fill in the demographic information of the employee Go to your employee's file: Employees> Enter the name of the employee concerned> Select the employee from the proposed list, Click on the employee's name (1), Edit the data concerning the employee's ...

    • Duplicate employee file

      You cannot delete an employee file when it is created. However, you can make the account invisible so that you no longer see them in your application. Here are the steps to follow:  Step 1: Go to the duplicate Employee file you want to delete, Click ...