1. Employment Hero Help Centre (UK)
  2. Payroll Platform
  3. Business
  4. Payroll Settings
  5. Business Management
  6. FAQ's on Importing Employees

Select your platform and then browse by platform category

Who are you and what section are you in?

Import my employee files using an Excel (.xlsx) or CSV file

James Nixon
Updated
EH Content Team

Available for the following Payroll classic plans: Standard, Premium
Available for the following user access levels: Admin 

The Employee Import feature allows you to bulk upload employee data, streamlining the onboarding process and saving you time.

You can upload your employee data using an Excel (.xlsx) or CSV file, which allows you to import employee information into the platform. This feature simplifies the process of adding multiple employees, saving time and reducing manual entry errors.

Getting started

Import ‌employee data

Warning

Please do not delete any of the columns in your XLSX/CSV file. If you delete or remove columns in your XLSX/CSV file and upload it into the platform, this will result in clearing some of your data on the platform too. This will lead to errors and affect your records and system.

  1. Log into the Payroll classic platform.
  2. Click the Business Settings menu.
  3. Click the Payroll Settings submenu.
  4. Click the Import Employees button.
  5. Select the Standard Format File Upload option in the Import Employees From drop-down.
  6. Click the Select File button.
  7. Enter your chosen file for bulk upload, which is either an Excel (.xlsx) or CSV file.
    Import__UK__1.jpg 
  8. Click the Confirm Upload? button.
    Import__UK__2.jpg
     

  9. You will now see a status message that confirms the successful upload of your employee data into your Payroll classic platform.

    Helpful Hint

    If you encounter errors in the imported file, it is recommended that you ensure the file includes only the necessary employee details. Remove any irrelevant sheets to prevent issues during the upload process.

    Import__UK__3.jpg 

Export the compatible template

You can export the compatible template from the payroll platform before populating and then importing.

  1. Log into the Payroll classic platform.
  2. Click the Business Settings menu.
  3. Click the Payroll Settings submenu.
  4. Click the Import Employees button.
  5. Click the Export button.

Important

You may find it helpful to begin by manually adding one employee. The exported template will then be pre-populated with this employee's information, acting as a visual guide for the required fields and their correct format.

Further information

Data type breakdown: Personal details
Field name. Data type. Notes.
EmployeeID. Number. This column must stay blank for new employees as the platform will auto generate the next available unique number.
Title. Text. Valid values include Mr, Mrs, Miss, Ms and Dr.
PreferredName. Text  
Firstname Text.  
MiddleName. Text.  
Surname. Text.  
PreviousSurname. Text.  
DateOfBirth. Date.  
Gender. Text. Valid values include male, female, and unspecified.
ExternalID. Text. Can be the ID of the employee from another platform. 
ResidentialStreetAddress. Text.  
ResidentialStreetAddress2. Text.  
ResidentialCity. Text.  
ResidentialCounty. Text.  
ResidentialPostCode. Number.  
ResidentialCountry. Text. This field needs completing if you added the entry true to the ResidentialAddress ManuallyEntered field.
ResidentialAddressManuallyEntered. Text. Valid values include true or false.
PostalStreetAddress. Text.  
PostalAddressLine2. Text.  
PostalCity. Text.  
PostalCounty. Text.  
PostalPostCode. Number.  
PostalCountry. Text. This field needs completing if you added the entry true to the PostalAddress ManuallyEntered field
PostalAddressManuallyEntered. Text. Valid values include true or false.
EmailAddress. Text.  
HomePhone. Text.  
WorkPhone. Text.  
MobilePhone. Text.  
StartDate. Date.  
EndDate. Date of employment termination.
ContinuousEmploymentDate. Number.  
Tags. Text. Pipe 'l' separated list of tags to associate with this employee.
Data type breakdown: Pay run setup
Field name. Data type. Notes.
JobTitle. Text.  
PaySchedule. Text. Corresponds to the name of a Pay Schedule that you have already created.
PrimaryPayCategory. Text. Corresponds to the name of a Pay Category that you have already created.
PrimaryLocation. Text. Corresponds to the fully qualified name of a Location that you have already created.
PaySlipNotificationType. Text. Valid values include email, SMS, manual and none.
RotaNotificationChoices. Text. Valid values include email, SMS and none.
Rate. Number. How much is the employee paid? You may specify as a per hour or per annum value.
RateUnit. Text. Valid values include hourly, annually, and daily.
HoursPerWeek. Number. The standard number of hours per week for this employee.
AutomaticallyPayEmployee. True/False. Determines whether the platform automatically applies the employee's standard weekly hours as earnings lines in a new pay run.
LeaveTemplate. Text. Name of the Leave Allowance Template applied to the employee.
PayRateTemplate. Text. Name of the Pay Rate Template applied to the employee.
PayConditionRuleSet. Text. Name of the Pay Rate Conditions Rule Set applied to the employee.
EmploymentAgreement. Text. Name of the Employment Agreement applied to the employee.
IsEnabledForTimesheets. Text. Valid values include enabled, disabled, and enabled for exceptions.
IsExemptFromPayrollTax. True/False.  
Locations. Text. Pipe 'l'

Related to:

Was this article helpful?
1 out of 3 found this helpful