Replace a spreadsheet
Replace the leave spreadsheet. Keep every record.
A spreadsheet works well for a small team. It stops working when requests, approvals and balance changes happen somewhere else, and one person has to keep them all in line.
30 days free with every Pro feature. No card needed. Then from $1.50 per person a month.
When it stops working
One place for the request, the decision and the balance.
In Clearleave, people request leave in one place, managers approve it there with cover checked, and the balance updates itself. Nobody retypes a decision into a file.
Signs your spreadsheet has reached its limit:
- Requests arrive by email or chat, and get typed in later
- Only one person can safely edit the file
- Balances need explaining, cell by cell
- Part-timers and public holidays need their own formulas
- Clashes are spotted after they happen
Balances you can defend
Every balance shows how it adds up.
A spreadsheet gives you a number. Clearleave gives you the number and every entry behind it: the allowance, carry-over, leave taken, leave booked, and any adjustment with who made it and why. When someone asks why they have 6.5 days left, you can show them.
- Granted for 2026plus 25 days1 Jan · policy: Standard
- Carried over from 2025plus 3 daysCarry-over cap: 5 days
- Carry-over expired 31 Marminus 1 daysUnused carry-over expires after 3 months
- Taken so farminus 9.5 days4 requests
- Booked, not yet takenminus 5 daysMon 5 – Fri 9 Oct
How to move
A careful move takes an afternoon, not a project.
- 01
Decide which file is the real one.
Choose the main spreadsheet, check which employee records are current, and note which future bookings are already approved. You don’t need a perfect file to start.
- 02
Agree the opening balances.
Write down each person’s allowance, carry-over, leave taken and leave booked. Check that the file doesn’t already take future bookings off, so they aren’t counted twice.
- 03
Import, with every row checked.
Turn the calendar grid into one row per booking and upload it. Clearleave checks every row before saving and lists anything it can’t match, with the reason. Up to 2,000 rows per file.
- 04
Pilot with five people.
Include a normal request, a changed booking and any working arrangement that causes questions. Compare their balances with the spreadsheet before moving the whole team.
Is the move worth it?
Compare the price with your own time.
A 25-person team on Core pays $37.50 a month plus tax ($1.50 per employee). You can try everything free for 30 days first.
Set that against the time your administrator spends keeping the file right and answering balance questions. Use your own figures, not ours.
See pricingFAQ
Spreadsheet questions.
Our spreadsheet is a calendar grid. Can you import it?
Not as a grid. The importer needs one row per booking: who, which leave type, first day and last day. The help guide shows how to turn a grid into a list, and the template in the app has the columns ready.
Do we have to bring our history across?
No. You can import this year’s bookings and let Clearleave work out each balance, or skip the history and set each person’s opening balance with an adjustment. Either way the reason is recorded.
Can we keep the spreadsheet?
Yes, and you should keep it read-only for your records. Just make sure only one of them takes new requests after the changeover date.
What about part-time staff?
Allowances are pro-rated from each person’s working week, and public holidays can be on top of the allowance or part of it. If they’re part of it, each person is only charged for the public holidays on their own working days.
Move the spreadsheet, keep the records.
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.