Skip to content

Import leave history

Upload past and booked leave from a CSV or Excel file, check every row, then import the ones that are ready. Up to 2,000 rows per file.

AdminsOwners

Bring in past and future leave so everyone's balance is right from day one. Nothing is saved until you've checked the file.

Import & migration: upload a file, check it, then import.

Import a file

  1. 1

    Upload

    Go to Import & migrationLeave history. Drop a .csv, .xlsx or .xls file on the page, or click to choose one, then select Check file. Select Download the template for a file with the right columns. Under Moving from, select your old tool to see where to get its file.

  2. 2

    Check

    Every row is listed with its outcome: ready, needs fixing (with the reason), already imported, or declined or cancelled (skipped). Use All, Problems, Ready and Skipped to filter. Checking saves nothing.

  3. 3

    Import

    Select Import 240 rows (the button shows how many are ready). A full 2,000-row file can take a minute, so keep the page open. Rows that need fixing aren't imported.

Fix the other rows and upload the same file again: rows already imported are skipped. See Fix import errors.

Columns

One row per booking. Column names can be in any case, with spaces, underscores or hyphens, so Start Date and start_date both work.

ColumnRequiredWhat to put
employee_emailYesTheir email in Clearleave. Or use first_name and last_name, or name, if names are unique.
leave_typeYesThe name or code of one of your leave types, such as Holiday or HOL. Not case-sensitive.
start_dateYesThe first day off.
end_dateYesThe last day off. Both days are included.
start_halfNoafternoon or pm if the first day starts at lunchtime.
end_halfNomorning or am if the last day ends at lunchtime.
hoursNoOnly for leave types booked in hours, such as time in lieu.
statusNoapproved (the default) or pending.
reasonNoKept as the note on the request.

Dates

These all work: 2025-06-02, 02/06/2025, 2 Jun 2025, and dates stored as dates in Excel. Numbers are read day first, so 02/06/2025 is 2 June. If the second number can't be a month, as in 06/13/2025, it's read month first.

Half days

Leave both half columns blank for full days. For a single afternoon, put the same date in both date columns and afternoon in start_half. For a single morning, use morning in end_half.

Hours

For leave types booked in hours, the hours value is kept. If it's more than the working time in the dates, only the working time is counted and the row shows a warning. For leave types booked in days, the days are worked out from the dates.

How days are counted

Days come from each person's working week and their location's public holidays, not from the file. Weekends and public holidays inside a range aren't deducted.

Status

Approved rows are deducted from the balance of the leave year they fall in. Your current allowance isn't checked, because past leave is a fact. Pending rows arrive waiting for approval. Declined, rejected and cancelled rows are skipped. The import doesn't send approval emails.

Duplicates

A row with the same person, leave type and dates as leave already in Clearleave shows as already imported and isn't added again. Two identical rows in one file, or two rows that overlap for the same person, need fixing. So does a row that overlaps different leave the person already has in Clearleave.