Free Excel leave tracker template
A simple spreadsheet to track annual leave, sick days and time off for one team — free to download, no sign-up. Opens in Excel, Google Sheets, Numbers or LibreOffice.
What's in the template
One row per leave request, with columns for employee, department, leave type, start and end dates, working days, status and notes — plus a row for the annual allowance and remaining balance. Duplicate the sheet per team or per year.
Where the spreadsheet stops working
This template is deliberately basic — and that's the point. The moment you need any of the following, a spreadsheet starts costing you more time than it saves:
- Pro-rata allowances for part-timers and mid-year joiners
- Accruals and carry-over rules that update automatically
- An approval trail (who requested, who approved, when)
- Multiple offices, timezones or public-holiday calendars
- A shared, always-current view of who's off — without emailing the file around
Frequently asked questions
- Is this Excel leave tracker template free?
- Yes — download the CSV and open it in Excel (or Google Sheets, Numbers, LibreOffice). There's no sign-up and no email gate.
- What does the template track?
- One team's leave: employee, department, leave type, start and end dates, working days, status and notes, plus a simple allowance/remaining row. It's intentionally basic — it does not calculate accruals, carry-over, pro-rata or approvals.
- When should I stop using a spreadsheet for leave?
- A spreadsheet works for a handful of people on a single allowance. It tends to break once you pass roughly ten employees, add part-timers (pro-rata), carry-over rules, multiple offices, or need an approval trail. At that point a dedicated tracker saves time and avoids payroll disputes — and Absenca is free for up to 15 people.
Outgrown the spreadsheet? Absenca is free for 15
Absenca does everything this template can't — accruals, carry-over, pro-rata, approvals, public holidays and a shared calendar — free for up to 15 people, then $0.75/user/month. Import this spreadsheet via CSV in minutes.