Skip to content

Switch from a spreadsheet

Turn your leave spreadsheet into two files Clearleave can import, a list of people and one row per booking, and see what to set up by hand.

AdminsOwners

A spreadsheet moves across as two files: your people, then your leave. Decide first which spreadsheet is the authoritative one, and which future bookings are already approved.

Still weighing it up? Replacing your leave spreadsheet covers what changes for your team, the opening balances and a five-person pilot.

What to export

  1. 1

    A list of people

    One row per person with first name, last name and work email, plus their role, department, manager's email, location and working days if you like. Save it as a .csv. See Import your people.

  2. 2

    One row per booking

    Many leave spreadsheets are a calendar grid, with a column per day. The importer needs one row per booking instead: who, which leave type, first day and last day. Rewrite the grid as a list, or start from the template in Import & migrationLeave history (Download the template). Save it as .csv or .xlsx.

  3. 3

    This year's balances

    Keep a copy of each person's allowance, days taken and days carried over. You'll use it to check balances after the import.

Map your columns

Column names can be in any case, with spaces or underscores. If your sheet uses one of these headings, it's read as is.

Your columnClearleave column
Email, Email address, Work email, Staff emailemployee_email
First name and Surname, or Name, Employee, Full namefirst_name + last_name, or name (only if names are unique)
Leave type, Type, Absence type, Leave, Categoryleave_type
Start, From, Date from, Leave startstart_date
End, To, Until, Date to, Leave endend_date
Start period, Start sessionstart_half
End period, End sessionend_half
Hours, Hours taken, Total hourshours
Status, Approval statusstatus
Notes, Comment, Description, Detailsreason
Days, Days taken, Total daysNot imported. Used only to warn you when it doesn't match the working days Clearleave counts.

Leave type values must match the name or code of one of your Clearleave leave types, such as Holiday or HOL. Dates can be 2025-06-02, 02/06/2025 (day first) or 2 Jun 2025.

What doesn't come across

  • Allowances. These come from the policy each person is on. Set up your policies before you import.
  • Carried-over days and manual corrections. Add these as balance adjustments. See Set opening balances.
  • Colours, formulas and totals. Only the values in the columns above are read.
  • Days off counted in the sheet. Clearleave counts working days itself, from each person's working week and their location's public holidays.

How long it takes

Most of the time goes on reshaping the spreadsheet. For a team of about 25, allow an afternoon to tidy the data, then a few minutes per file to upload, check and import. Each file can have up to 500 people or 2,000 bookings.