Bulk data import and export

Bulk Data Import and Export

Use bulk data to import employee information from a spreadsheet, or export it to one. It is how you load employees at go-live, update many profiles from a file, or download employee data. Choose carefully between Append and Overwrite, because Overwrite can delete data for everyone in your file.

Where:

  • Employee data: My Team › Settings, under Bulk tools › Profile Import/Export. It is also on the Team tab as Import / Export, and on Tools & Reports.
  • Everything else, such as leave balances, shifts, holidays and payslips: My Team › Settings, under Bulk tools › Company Bulk Data

You need:

  • The Bulk Profile Data right to open these pages
  • For each kind of data, the matching right in User Rights: Edit to import, Read to export. If you lack it, that section is greyed out

Which tool, when

You want toUse
Load or replace a lot of data from a fileBulk data import
Change a few fields on people you can see on screenProfile Manager
Assign approvers and managers to many peopleBulk Assignments
Add one personAdding and onboarding employees

Append or Overwrite: read this before importing

  • Append changes only what your file contains. Blank cells do not delete existing information.
  • Overwrite treats a blank cell as "delete this". If a column is empty in your file, that data is permanently deleted for every employee in the file.
⚠️ Overwrite with a partly filled spreadsheet is how companies lose bank details and emergency contacts in one click. Use Append unless you mean to clear fields, and if you do, test on one person first.

How to import employee data

  1. Open Profile Import/Export. The window opens on Export.
  2. Under Type, choose Import.
  3. Under Download Template, choose the data you want. The worksheet downloads.
  4. Fill it in, keeping the template's columns as they are, and save it as .xlsx.
  5. Select the matching section, such as Employment Details or Payroll. You can select several if your file covers them.
  6. Choose Append or Overwrite.
  7. Select Browse file and choose your file.
  8. Select Import.
  9. Wait for the Data Import email, and read it.

The Profile bulk data window set to Import: the data sections, Download Template, Append or Overwrite

How to export employee data

  1. Open Profile Import/Export, and leave Type on Export.
  2. Select the sections you want. Master Profile Export covers the main ones together, and Master Profile Export (Custom) lets you choose.
  3. If you selected several, choose whether to tick Export all the selected sections in a single file.
  4. Select Export.

If you open this from a filtered Team list, the export covers only the employees matching your filters.

How to import or export company data

  1. Open Company Bulk Data. The page is called Bulk Import / Export.
  2. Select the kind of data, such as Leave Balances, Shifts or Holiday.
  3. Select Get a sample template to download the worksheet, and fill it in.
  4. Choose Import or Export. For an import, choose Append or Overwrite if they are offered.
  5. Choose your file, then select Import or Export.

What you can import

WhereSections
Profile Import/ExportMaster Profile Import, Employee Profile, Employment Details, Profile Access, Lifecycle, Attendance, Payroll, Dependents, Team Org, Education details, Disciplinary Action, Employment History
Company Bulk DataIncludes Event Request, Bulk Schedule, Holiday, Payslips, Expenses, Leave Balances, Leave Events, Event Template, Shifts, Branches, Profile Other Payments, Previous Employer, Assets and Profile Picture Import

Master Profile Import is one combined template for onboarding employee records in bulk. For past role and pay changes, see Importing Lifecycle records.

What Happens Next

  • The import runs in the background. You get a notification and a Data Import email when it finishes.
  • If any row has an error, nothing in that section is saved. The email lists the errors. Fix them and import the file again. If you imported several sections, some can save while others fail.
  • Import History, on the Company Bulk Data page, shows every import, who ran it, its type, its file and its status: In Progress, Success, Failed or Partial Success.
  • Changes appear in the Audit Trail as bulk imports.
  • Effects follow the data. Placement changes can re-route approvals and trigger Profile Automations. Payroll fields reach the next run.
  • There is no undo. Reversing an import means importing corrected data.

Tips

  • Import a sample of ten first. Ten people you can check by hand surface a column or ID problem quickly.
  • Export before a large import. A current export is the closest thing you have to a backup.
  • Keep the source file. When someone disputes a value months later, it shows where the value came from.
  • Do not import on payroll day. Give yourself a run to check the result.

Troubleshooting / FAQ

Q: How do I upload employees from Excel? Follow How to import employee data above, using Master Profile Import.

Q: My import failed and nothing changed. That is how it works. One bad row stops the whole section. The Data Import email lists the row numbers and errors.

Q: Where can I see if my import worked? Read the Data Import email, or open Company Bulk Data › Import History.

Q: Data has disappeared from profiles. An Overwrite import had blank columns. Restore from your export, or import the correct values again.

Q: A section is greyed out. You do not have the right for that data. See User rights and access control.

Q: Who changed this field? The Audit Trail records it, and Import History shows who ran each import.

Related articles