We're in beta and it's completely free. Your feedback shapes what we build — feedback@rotaleave.co.uk

Import from BrightHR

Move from BrightHR with the employee details export and an optional absence report — CSV or Excel, previewed before anything is written.

Updated 11 July 2026

Rotaleave reads BrightHR report downloads directly — CSV or Excel. Importing is admin-only, from Settings → Import / Migrate, the People page’s Import / Migrate button, or during onboarding on the Your people step — set Source to BrightHR.

Get your BrightHR exports

  1. Log in to BrightHR as an admin.
  2. From Reports, download the employee details export — required.
  3. Optionally download an absence report for the date range you want to bring across.

BrightHR has no self-serve API, so the file export is the supported route.

What comes across

ColumnBecomes in Rotaleave
Emailidentifies the person (must be unique)
First name / Last nameName
TeamDepartment (BrightHR “Teams” are org units)
Annual leave entitlementAnnual allowance (days)
Employee IDlinks leave rows to the right person (and flags duplicate IDs)
StatusActive/archived
Absence typeLeave type (created if missing)
Start date / End dateStart/end dates
DurationHalf-day/day-part
Referenceused to keep re-runs safe

Not imported: remaining balances — enter opening adjustments after migrating — job title, and lateness rows, which are skipped because they aren’t leave. Anything else the importer doesn’t recognise is listed as a warning, never dropped silently.

Preview, then import

  1. Upload the employee details file (and the absence file if you have one).
  2. Click Preview — nothing is written yet. You get Created / Updated / Skipped counts per entity plus any warnings.
  3. The Import button stays disabled until a preview exists — the dry run isn’t optional, by design.
  4. Happy with the counts? Click Import and look for “Import complete.”

Safe to re-run

People are matched by email and leave records by their reference, so re-importing the same or a corrected file updates rather than duplicates. Iterate until the preview is clean.

After the import

  • Spot-check a few people’s entitlements against BrightHR.
  • Decide your bank holiday policy.
  • Invite everyone when you’re ready — importing doesn’t email anybody until you say so.

Was this page helpful?