Skip to content

Free · Excel and Google Sheets

Free staff holiday spreadsheet for any country.

A year planner for your team in Excel or Google Sheets, with your country’s public holidays already marked. Type each person’s allowance, mark their days off, and it works out what they’ve taken and what’s left, half days and part-timers included.

Pick your country, region and year below. It’s free.

Get the holiday spreadsheet

The download starts straight away, and we email you a copy of the link.

We keep your email with the download for 30 days, then delete it, unless you ticked the box above. Unsubscribe any time. Privacy

What’s inside

  • A tab for each month, one row per person, with weekends shaded and public holidays marked and named.
  • Codes for a day off, a morning or afternoon off, sick days and other absence, with a drop-down on every day.
  • A Team tab with each person’s allowance, a pro-rata helper for part-timers, days carried over, taken and left.
  • A list of the year’s public holidays for your country or region, and a “How to use” tab, including how to open it in Google Sheets.
  • Room for 40 people. No macros, nothing to install.

Who it’s for

For whoever keeps track of the team’s holidays.

  • Office managers and owners of small teams who keep leave in a spreadsheet today and want one that adds up the days for them.
  • Teams in any country, or across several: download one for each place your people work.
  • Anyone who wants to see who’s off when before the year starts, with the public holidays already in.

When the spreadsheet gets too much, see how to replace your leave spreadsheet without losing its history.

Preview

Every month on one screen.

The first two weeks of January 2027 for a sample team in England & Wales. Your copy has your country’s holidays and your team.

January 2027 · England & Wales

H holiday · AM / PM half day · S sick

The first two weeks of January 2027 in the staff holiday spreadsheet for England & Wales, with a sample team
NameFr1Sa2Su3Mo4Tu5We6Th7Fr8Sa9Su10Mo11Tu12We13Th14Taken
Amara OkaforHHHHH5
Tom HughesAM0.5
Priya ShahSHH2
Jonas Becker0
Public holidays in orange: New Year’s Day (1 January).

FAQ

Questions, answered.

Does it work in Google Sheets?

Yes. In Google Sheets, open a blank spreadsheet, choose File → Import → Upload, pick the file and choose “Replace spreadsheet”. The formulas, drop-downs and colours come across. It also opens in Excel, LibreOffice and Numbers.

Which countries does it cover?

Over 200, from the same open-source holiday data Clearleave uses. Where holidays differ by region, such as the UK’s nations, US states or Australian states, pick the region and its own days are marked too. Governments sometimes add or move a holiday, so check your official calendar.

Are public holidays taken from the allowance?

That’s up to your policy and the law where you are. The spreadsheet marks public holidays so you can see them; it only takes a day from someone’s allowance when you type a code on it.

How does it work out a part-timer’s allowance?

Type their full-year allowance and the days they work each week. The Team tab works out allowance × days worked ÷ full-time days per week (5 to start with, and you can change it). Round it, or change it by hand, if your policy says so.

How do half days work?

Type AM for a morning off or PM for an afternoon off. Each counts as half a day in the totals. H is a full day, S a sick day (counted separately) and O any other absence that isn’t taken from the allowance.

My leave year doesn’t start in January. Can I still use it?

This one runs from January to December. If your year starts in April, say, download both years and use the months you need, adjusting the totals by hand. In Clearleave, each leave policy can start its year in any month.

Why do you ask for my email?

So we can send you a copy of the link to find later. The download starts straight away either way. Unless you tick the box to hear from us, we don’t add you to any list, and we delete the request after 30 days.

More free templates

Clearleave launches 1 January 2027

When the spreadsheet gets too much, Clearleave does the counting.

Requests, approvals and every balance in one place, with each country’s public holidays loaded for every office and part-timers handled properly. Book your place and we’ll email you at launch.

Book your place for launch day.

One email at launch, with an invitation to start early. Nothing else.