Skip to content

Switch from BrightHR

What to export from BrightHR, how to match its columns to the Clearleave template, and what to set up by hand.

AdminsOwners

BrightHR's reports can be exported for a date range, so you can bring across past and booked leave. Clearleave doesn't read BrightHR files as they are yet, so you'll rename a few columns first.

Still deciding? Clearleave vs BrightHR compares price, contract and cover side by side.

What to export

BrightHR's guide Making the most of reports names the reports to use. Run them from the reports section of BrightHR:

  • Employee Information Report: everyone on your account. Use it for the people import (first name, last name and email).
  • Absence Report: every absence in a date range, with notes and whether it was approved or declined. Pick a range that covers this leave year and any leave already booked ahead.
  • Annual Leave Summary Report: entitlement and leave taken per year. Keep it to check balances after the move.

If a report offers several formats, choose CSV or Excel.

Map your columns

Open the leave export in Excel or Google Sheets, rename the column headers as below, and delete any other columns. Headers can be in any case, with spaces or underscores. Columns named Email, Leave type, From, To and Notes are recognised without renaming.

What you needClearleave column
The person's work emailemployee_email
The leave type's nameleave_type (must match a Clearleave leave type)
The first daystart_date
The last day (inclusive)end_date
Half day at the start or end, if anystart_half (pm) or end_half (am)
Hours, for hours-based types such as TOILhours
Approved or pendingstatus (approved if left blank)
Notesreason (optional)

Declined rows can stay in the file with status set to declined: they're skipped. If BrightHR shows a booking's length but not which half of the day, add start_half or end_half yourself for half days.

Then:

  1. 1

    Set up leave types and people

    Create leave types with the same names BrightHR uses, then import your people from the people export.

  2. 2

    Upload the leave file

    Go to Import & migrationLeave history, upload the file as .xlsx or .csv, and select Check file. Every row shows whether it's ready or what needs fixing.

  3. 3

    Import, then check balances

    Import the ready rows, add carried-over days as opening balances, and compare three people's balances with BrightHR.

What doesn't come across

  • Sickness costs, lateness and overtime. These reports have no equivalent to import.
  • Documents and notes on the person. Keep them in BrightHR or your HR files.
  • Allowances. These come from your Clearleave policies, not the file. Carried-over days are added as adjustments.
  • Day counts. Clearleave counts working days from each person's working week and their location's public holidays. If a row's count differs from BrightHR's, check the person's working pattern.

How long it takes

For a team of about 25, allow an hour to export and rename the columns, plus a few minutes to check and import. Files over 2,000 rows need splitting.

Export steps checked against BrightHR's public help pages on 27 September 2026: Making the most of reports.