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.
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
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
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
.csvor.xlsx. - 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 column | Clearleave column |
|---|---|
| Email, Email address, Work email, Staff email | employee_email |
| First name and Surname, or Name, Employee, Full name | first_name + last_name, or name (only if names are unique) |
| Leave type, Type, Absence type, Leave, Category | leave_type |
| Start, From, Date from, Leave start | start_date |
| End, To, Until, Date to, Leave end | end_date |
| Start period, Start session | start_half |
| End period, End session | end_half |
| Hours, Hours taken, Total hours | hours |
| Status, Approval status | status |
| Notes, Comment, Description, Details | reason |
| Days, Days taken, Total days | Not 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.