Switch to Clearleave
Bring every past booking with you. Check every row before it’s saved.
Import your people and years of past leave from a spreadsheet, Timetastic, or any tool that exports a CSV. Every row is matched and checked before anything is saved, and approved leave comes off the right leave year’s balance.
30 days free with every Pro feature. No card needed. Then from $1.50 per person a month.
How to plan the move
- 01
First, understand what needs to move.
List what needs to move: people, working patterns, this year’s allowances and leave already approved. Past leave moves from any CSV. Attachments don’t.
- 02
Check the opening records together.
Your administrator reviews the balances and bookings before Clearleave becomes the everyday source of leave information. Where two records disagree, settle the number before you import, not after.
- 03
Try it with a small group.
A short pilot lets you test requests, approvals and the team view with representative employees. Confirm the result, choose a changeover date and tell the team where to send new requests.
- 04
Run both until the numbers match.
Keep your old tool going while you check balances with a small group. Cancel only when you’re happy.
From a spreadsheet
Keep the records. Stop the chasing.
A spreadsheet can work well for a small team. The problem starts when requests, approvals and balance changes happen somewhere else, leaving one person to keep everything aligned. Clearleave keeps the request, the decision and the team view together, and gives employees one place to check their own leave.
You don’t need a perfect spreadsheet to begin. Start by deciding which file is the real one, which employee records are current and which future bookings have already been approved. Then run a sensible first test:
- Choose five representative employees.
- Include a normal request, a changed booking and any working arrangement that tends to cause questions.
- Review the opening records and check the outcome together before moving the whole company.
A 25-person team on Core pays $37.50 a month plus tax ($1.50 per employee). Weigh that against the hours someone spends keeping the file right.
From another leave tool
Bring your history with you.
Export your people and past leave from your current tool as CSV files. Clearleave matches every row to a person by email and to a leave type by name, and shows you anything it can’t import before a single row is saved.
- Any CSV works; the importer is built to read Timetastic’s export columns
- Up to 2,000 rows per file
- Working days counted from each person’s week and public holidays
- Re-importing the same file adds nothing
- Run both tools side by side until you’ve checked the balances
Import guide
Eight steps, checked as you go.
- 1
Create your account and set your country
The setup wizard walks you through your company, leave year and country. In nine countries (the UK, Ireland, the US, Canada, Australia, New Zealand, South Africa, Singapore and India), your public holidays and a starting allowance are set up for you. If some of your people work elsewhere, calendars for 200+ countries are on the Public holidays page.
- 2
Create leave types with the names you already use
Past leave is matched to a leave type by name (not case-sensitive), so name them the way your export does, for example “Holiday”, “Vacation” or “Sickness”.
- 3
Import your people
Upload a CSV with
First Name,Last NameandEmail, plus optionalRoleandDepartment. Any row that fails, such as an email that already exists, is listed with the reason. - 4
Set up your leave policies and allowances
Past leave is taken from the leave year it happened in, so balances come out right. People without a policy still import; their leave is simply recorded.
- 5
Export your leave history
Any CSV works, and the importer is built to read Timetastic’s export columns (email or name, leave type, start and end, morning or afternoon, status). From a spreadsheet or another tool, download the template in the app, or use
employee_email,leave_type,start_date,end_dateandstatus. - 6
Upload and preview
Every row is checked before anything is saved: unknown people or leave types, bad dates, duplicates and overlaps are shown next to the row. Working days are counted from each person’s working week and public holidays. Up to 2,000 rows per file, and re-importing the same file adds nothing.
- 7
Import and fix the leftovers
Anything that can’t be matched, such as someone who isn’t set up yet, is listed row by row with the reason. Fix it and upload just those rows again.
- 8
Check balances
Approved leave comes off each person’s balance and pending leave waits for approval. The import doesn’t send approval emails to your team. If you’d rather start from opening balances than full history, adjust each balance with a reason.
- Upload your CSVleave-history-2021-2026.csv · 1,842 rows (up to 2,000 per file)(done)
- !Preview every row1,839 ready · 3 rows have a date that isn’t yyyy-mm-dd and are skipped(done)
- !Match people and leave types4 rows name someone who isn’t set up yet, listed row by row(done)
- Import the leave1,835 imported · approved leave comes off balances, pending leave waits for approval(done)
Import complete: 1,835 bookings imported, 4 rows to fix.
employee_email,leave_type,start_date,end_date,status
priya@acme.co,Holiday,2025-08-04,2025-08-08,approved
thabo@acme.co,Sickness,2025-11-12,2025-11-12,approved
sarah@acme.co,Holiday,2026-10-05,2026-10-09,pendingFAQ
Switching questions.
Do I need to stop using my current tool first?
No. Set Clearleave up and import your history while your current tool or spreadsheet keeps running, check the balances with a small group, then move your team over.
Will importing email my whole team?
No. The leave history import records past bookings directly and doesn’t send approval emails. People only hear from Clearleave when you invite them.
My export has more than 2,000 rows. What do I do?
Split it into several files of up to 2,000 rows each, for example one per year, and import them one after another. Re-importing a file you’ve already imported adds nothing.
What if some rows fail?
Only those rows fail. Clearleave lists each one with the reason, such as an email that doesn’t match anyone yet or a leave type name that doesn’t exist. Fix them and import just those rows again.
Can you help with the move?
Yes. The help centre walks you through every step: exporting from your old tool or spreadsheet, uploading the file and checking each row before it’s saved. Questions? Email us and we’ll reply within a working day.
Run your next leave request in Clearleave.
Add your team, book a real request and see how every balance adds up. Free for 30 days.
30 days free with every Pro feature. No card needed. Then from $1.50 per person a month.