Mass Update - Employee Demographics

Mass Update - Employee Demographics

Use Mass Update to change employee IDs and addresses for multiple active employees at once with a spreadsheet. Employers and Feature Admins can complete this update.

You can update:
  • Employee ID
  • Employee Street Address
  • Employee City
  • Employee State
  • Employee Zip Code
To update salaries with the same tool, see Mass Update - Salary.

To mass update employee demographics:
  1. Go to Employees, then select Mass Update in the secondary navigation.
  2. Select Mass Update.
  3. In the Mass Update window, select Download to get the employee template. You must use this template or your import will not work.
  4. Fill in the spreadsheet for each employee you want to update:
    • First Name, Last Name, and Employee SSN are required to match the employee. Do not include dashes in the SSN.
    • Enter values only in the columns you want to change: Employee ID, Employee Street Address, Employee City, Employee State, and Employee Zip Code. Leave a column blank to keep the current value.
    • Employee State must be a valid two-letter state code. Employee Zip Code must be five digits.
    • Leave salary columns blank unless you are also updating compensation.
  5. Under Upload your data, select the completed spreadsheet file, then select Import.
Only active employees are matched and updated. An Employee ID cannot be assigned if it is already used by another employee.