Switch from WhosOff
What to export from WhosOff, how to match its columns to the Clearleave template, and what to set up by hand.
WhosOff exports leave and balances to CSV or Excel. Clearleave doesn't read WhosOff files as they are yet, so you'll rename a few columns first.
Still deciding? Clearleave vs WhosOff compares price, contract and cover side by side.
What to export
WhosOff's help article How do I print staff leave records? covers the leave export:
- Leave: go to Reports › Reports Dashboard, and under Breakdown choose Leave by allowance period. Set Show leave breakdown to Yes so you get one row per request, then export to .CSV or .XLSX.
- Balances: the balance report (Reports › Yearly Breakdown) shows opening and remaining balances, including carryover and lieu days. Export it to CSV and keep it for checking balances.
- People: WhosOff doesn't document a staff-list export. Copy names and emails from your staff list into our people template.
Only Approvers and Super Users can run reports in WhosOff.
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) |
If WhosOff gives totals rather than one row per request, go back and set Show leave breakdown to Yes.
Then:
- 1
Set up leave types and people
Create leave types with the same names WhosOff 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 WhosOff.
What doesn't come across
- Lieu time and overtime rules. Set up an hours-based leave type in Clearleave and add balances as adjustments.
- Bradford Factor and limit reports. Clearleave has its own reports and cover rules.
- 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 WhosOff'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 WhosOff's public help pages on 27 September 2026: leave records, balance report.