Fix leave import errors
What each message in the leave history check means and how to fix the row, from unknown people to overlapping dates.
Rows that need fixing are listed in the Check step with the reason, and aren't imported. Import the ready rows, fix the others in your file, then upload the same file again: rows already imported are skipped.
Problems with the whole file
Your file needs … columns
A required column is missing or has a name we don't recognise. The message lists the headers we found. Rename yours to employee_email, leave_type, start_date and end_date, or select Download the template.
Unsupported file type
Upload a .csv, .xlsx or .xls file.
We couldn't read that CSV or spreadsheet
Open the file and save it again as CSV (comma-separated) or .xlsx.
That file has no rows under its header row
Put the column names in row 1 and the bookings below them.
This file has … rows
One file can import up to 2,000 rows. Split it, for example by year. Rows past the limit show Over the 2,000-row limit for one file. A file with more than 10,000 rows isn't checked at all: you'll see Files can have at most 10000 rows.
Who the leave is for
Say who this is: add their email
The row has no email or name. Fill it in.
"…" isn't an email address
Correct the typo.
No one with the email … is in Clearleave
Add them first (Import your people), or correct the email to the one they have in Clearleave.
No one called … is in Clearleave
The name must match their first and last name in Clearleave. Fix the spelling, add the person, or add an employee_email column.
… people are called …
Two people share the name. Add an employee_email column.
Leave type
Leave type is missing
Fill in the leave type.
Unknown leave type "…"
Use the name or code of one of your leave types. The message lists them. Rename the value in the file, or create the leave type first.
Dates and amounts
Start date is missing
Fill in the first day off.
Start date or End date "…" isn't a date we can read
Use 2025-06-02, 02/06/2025 or 2 Jun 2025.
End date is before the start date
Swap the dates or correct one of them.
A day that starts in the afternoon can't end in the morning
On a one-day row, use either afternoon in start_half or morning in end_half, not both.
Start half or End half "…" should be morning or afternoon
Use morning, am, afternoon or pm, or leave it blank for a full day.
Longer than a year
Split it into one row per leave year.
Hours "…" should be a number above 0
Use a number such as 3 or 7.5.
Status "…" should be approved or pending
Use approved or pending. Declined and cancelled rows are skipped, not errors.
No working days in these dates
Every day is a weekend, a day off or a public holiday for this person. Check the dates, or their working week and location.
Duplicates and overlaps
Same leave as row …
Two identical rows. Delete one.
Overlaps row … for the same person
Two rows cover some of the same days. Merge or correct them.
Overlaps leave already in Clearleave
The person already has different leave on some of these days. The message gives its dates. Check which is right, then change that leave or the row. Identical leave shows as already imported instead.
Could not import this row
Something failed while saving. Upload the file again; if it keeps happening, contact support.
Warnings
Rows with a warning are still imported.
… hours is more than the working time in these dates
Only the working time is counted. Correct the hours if that's wrong.
The file says … days
Clearleave counts working days from the person's working week and public holidays, so it may differ from your old tool. If it's wrong, check their working week and location before importing.