Switch from BrightHR
What to export from BrightHR, how to match its columns to the Clearleave template, and what to set up by hand.
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 need | Clearleave column |
|---|---|
| The person's work email | employee_email |
| The leave type's name | leave_type (must match a Clearleave leave type) |
| The first day | start_date |
| The last day (inclusive) | end_date |
| Half day at the start or end, if any | start_half (pm) or end_half (am) |
| Hours, for hours-based types such as TOIL | hours |
| Approved or pending | status (approved if left blank) |
| Notes | reason (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
Set up leave types and people
Create leave types with the same names BrightHR uses, then import your people from the people export.
- 2
Upload the leave file
Go to Import & migrationLeave history, upload the file as
.xlsxor.csv, and select Check file. Every row shows whether it's ready or what needs fixing. - 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.