Employee holiday planner for 2027: a free team vacation calendar
An employee holiday planner shows which of your people are away on each day, so you can see overlaps before you approve more leave. This one is for managers and small teams who keep holiday in a spreadsheet: a free annual leave planner for 2027 in Excel and Google Sheets, with one row per teammate, one column per day and a count of who is away.
In the UK, Ireland and Australia this is usually called an annual leave planner or holiday planner; it is the same file. The Holidays tab already lists 2027 bank and public holidays for England and Wales, Scotland, Northern Ireland, Ireland and New South Wales from public holidays 2027 by country, and the vacation days calculator counts the working days in a trip so you know how much leave it uses.
What is an annual leave planner?
An annual leave planner, or team vacation calendar, shows who is away on each date so teammates can review overlaps and plan cover. Ample offers a free 2027 Excel and Google Sheets calendar, a monthly browser planner and printable 2026 and 2027 calendars. The browser planner can export CSV; neither format approves leave, calculates balances or syncs with the other.
Free · No signup · Entries stay in this tab until you close or reload it
2027 team vacation calendar in Excel or Google Sheets.
One row for each of up to 30 teammates and one column for every day of 2027, with weekends shaded. Type a code in each day someone is away: V for vacation, S for sick, H for a public holiday, C for a company closure, P for requested and not yet approved. An Away row counts who is out each day and turns red when two or more people are. A Holidays tab lists 2027 public holidays for 14 countries from official government lists.
Free .xlsx and .csv · No signup · No macros · Doesn’t sync with any calendar
Google Sheets: upload the Excel file to Google Drive and open it with Google Sheets to keep the codes, shading and Away count; or choose File → Import → Upload with the CSV to add the blank day grid to a Sheet you already use.
Plan the whole year.
Download a printable team vacation calendar for 2026 or 2027. Each PDF includes a year-at-a-glance page and 12 monthly grids, with space for eight teammates and coverage notes.
13 pages each · US Letter landscape · Print at “Fit” on A4 · Weekends shaded · No public holidays prefilled
Print the year overview, the months you need, or the full planner. Write names in the first column and mark each day as requested, approved or a team closure. Print extra copies for larger teams. These are blank print-and-write PDFs; your online entries are not transferred into them.
Which employee holiday planner to use
Google suggests several wordings for the same need. Staff holiday planner, employee leave planner and annual leave planner all mean the files and tools on this page. Pick by how you plan.
| Excel or Google Sheets file | Browser planner below | |
|---|---|---|
| Covers | All of 2027, up to 30 teammates | One month at a time, up to 50 absences |
| You enter | A code per day: V, S, H, C or P | First day, last day and an optional covering teammate |
| Overlaps | An Away row counts who is out each day and turns red at two or more | Dates with more than one absence are highlighted |
| Public holidays | Holidays tab for 14 countries | Not included |
| Saved | In the file you keep | Not saved; reloading clears entries, so export first |
| Approves leave or syncs with a calendar app | No | No |
Use the file for a year-long view you keep and share. Use the browser planner to check one month quickly or to print it.
Employee holiday planner template in Excel
The 2027 Excel file above is the template: names down the side, days across the top, weekends shaded and the Away count already built. Fill in codes for each person and the count updates.
Staff holiday planner, free
Every file on this page is free with no signup: the Excel file, the CSV, both PDFs and the browser planner.
Staff holiday planner wall chart
The 2027 PDF has a year-at-a-glance page and 12 monthly grids for eight teammates. Print the overview page and hang it where the team can see it; write names and dates by hand.
Employee holiday planner app
The browser planner below is the nearest thing on this page to an app: add each absence, see the month, export the dates as CSV. It keeps nothing after you close the tab and does not send reminders. If you need requests and approvals, the best PTO tracker for small remote teams compares seven tools.
Employee leave planner in Excel
Same file under a UK and Australian name. Add the dates people have booked, then check them against the public holidays on the Holidays tab.
How to make a holiday spreadsheet in Excel
- Put each teammate’s name in column A, one per row.
- Put the dates of the year across row 1, one column per day.
- Shade Saturdays and Sundays so weekends are easy to skip.
- Type a code in each day a person is away, such as V for vacation.
- Under the last name, count the filled cells in each day’s column with =COUNTA(D2:D31), adjusting the range to your rows.
The 2027 file above already has all of this built, so you can skip the setup.
Two people asked for the same days? Pick one rule and reply to both. Setting blocked dates? See vacation blackout period wording or cancelling approved time off.
Found a gap on the calendar? Ask a coworker to cover with one of four messages.
Plan the month
Add your first absence or try the fictional example.
Monthly calendar
Monday–Sunday · All-day absences, inclusive of both dates · Purple labels show who is away
Named cover is a plan, not a confirmation. Check availability and agreement with each covering teammate.
How to make a team vacation calendar
- Choose a month and add each teammate’s first and last day away.
- Review dates with multiple people away. Check which roles still need coverage.
- Agree on a covering teammate and use a handoff template for deadlines and responsibilities.
- Print the monthly view or export all entered absences to a CSV file.
Does this calendar approve time off?
No. It displays the dates you enter, including weekends and holidays. It does not calculate working days, accruals, minimum staffing or approval status. An overlap is a prompt to review coverage, not proof of a staffing shortage. Use the coverage calculator to compare available people with your team’s minimum.
Can I share this vacation calendar?
Print it or choose “Save as PDF” in your browser’s print dialog. The CSV export includes every entered absence, even outside the displayed month, and can be opened in a spreadsheet. Share the exported file through your team’s normal channel. This page does not create a public link containing your team’s dates.
Does the annual template include holidays?
The 2027 Excel file has a Holidays tab with every 2027 public holiday on public holidays 2027 by country, from official government lists for 14 countries; mark the days each teammate takes as H. The PDFs shade Saturdays and Sundays but leave holidays and company closures for your team to add. Use the notes area for local dates and adjust for teammates with different workweeks. Calendar marks do not calculate PTO balances or approve requests.
Are my team’s dates saved?
Your entries stay in this page’s memory. Reloading or closing the tab clears them. Export before leaving if you want a record. Names and dates are not submitted to Ample or included in analytics. Keep sensitive reasons for leave out of the calendar.
Team spread across time zones? The time zone overlap calculator shows which hours a covering teammate actually shares with the person who is away.
Found an overlap? Agree who covers each responsibility in a vacation coverage plan template for Excel or Google Sheets.
Planning December? The holiday coverage schedule template lists every weekday from November 23, 2026 to January 8, 2027 with US and UK holidays filled in, and flags days with fewer people than you need.
Running on-call as well? The on-call rotation schedule template checks each rotation week against the time off you have booked.
Outgrowing a calendar? The best PTO tracker for small remote teams compares seven tools on price per person, free tier, Slack and coverage, with dated sources.
Want the calendar in a paid tool instead? Timetastic alternatives compares leave planners by price per person, Slack and coverage.
Using Vacation Tracker and paying its $50 monthly minimum for a small team? Compare Vacation Tracker alternatives for small teams, with prices from each vendor’s own pages.
Someone going on parental leave? Put the dates on the calendar and the interim owners in the maternity leave coverage plan template.
Two people asking for the same week? Decide the notice and approval rules ahead of time in a PTO policy template, then use this calendar to apply them.