Import employees from a spreadsheet
Add or update many employees at once by uploading a spreadsheet in Reports & Data Exchange, mapping columns, fixing errors and reviewing the results.
On this page
Use an import when you need to add or update many employees at once.
Before you start
- Prepare a spreadsheet with one row per employee.
- Set up the employment types and outlets your file refers to.
Steps
- Open Reports & Data Exchange and choose the employee import.
- Upload your file.
- Map your column headers to Inside fields. Inside recognises some common header names automatically; check each mapping.
- Validate the file. Inside shows which rows will create a new employee, update an existing one or have errors.
- Fix errors in your file and upload again, or exclude the invalid rows.
- Apply the import.
- Review the results. Download the error workbook if any rows failed.
Things to know
- The import doesn't overwrite employees' existing role or outlet assignments. Change those in Employee Hub.
- Past imports are listed in the import history.