Resources

Your team’s 2027 vacation plans, in one spreadsheet.

A free team vacation planner for Excel, with Google Sheets import instructions. See who is away, spot overlapping holidays, and keep full and half-days in one place.

Download the free 2027 template

Excel .xlsx · No email, signup, or macros · Free to use and share

January 2027 calendar with rows for three fictional teammates, full-day V entries and half-day H entries. Weekends are shaded.
A January excerpt with fictional names and dates. Your download starts blank, ready for your team.

What’s inside the template?

  • A full January–December 2027 calendar with space for 20 teammates.
  • A Team tab for names and automatic full-day, half-day, and total days-away counts.
  • Simple V and H leave codes, weekend shading, and a daily count of people away.
  • Frozen names and dates, plus shortcuts to each month.

Use it in Excel

  1. Download and open the workbook, then save your team’s copy.
  2. Enter names in the yellow cells on the Team tab.
  3. On the 2027 calendar tab, enter V for a full day away or H for a half-day.
  4. Check the totals and overlapping dates together. Clear a cell when plans change.

Use it in Google Sheets

Download the same .xlsx file. In a blank Google spreadsheet, choose File → Import → Upload, select the workbook, and create a new spreadsheet. Then share that spreadsheet with your team. There is no separate account or email gate on Parasol.

See Google’s Excel import instructions for the available import options. Check the layout and totals after importing.

How are days counted?

Each V counts as one day and each H as half a day. Totals include any marked weekend dates, so leave non-working days blank. The daily people-away count treats both codes as one person with some time away. Public holidays are not pre-filled because teams work in different countries. The file records plans; it does not calculate leave entitlement or approve time off.

Prefer a calendar your team can update together?

Parasol gives your team a shared calendar through one link, without individual accounts. It is free for up to 50 people per board and includes public holidays for the countries your team chooses. Add your dates in Parasol when you are ready; spreadsheet import is not currently available.

Create a shared calendar in Parasol

Or read our team vacation calendar guide for a simple planning routine.