Skip to content

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
Guide: when a leave spreadsheet stops working

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.

Priya Sharma · Annual leave 2026How it adds up
  • 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
Available to book12.5 days

How to move

A careful move takes an afternoon, not a project.

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 pricing

FAQ

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.