Skip to content

Switch from WhosOff

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

AdminsOwners

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 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)

If WhosOff gives totals rather than one row per request, go back and set Show leave breakdown to Yes.

Then:

  1. 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. 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 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.