Skip to content

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.

AdminsOwners

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.