Skip to content
The title slide and first slides of the Holiday Party Planner template

Holiday Party Planner

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
6
Difficulty
Beginner
Updated
November 6, 2026

Every slide (6)

Overview

A planning file for hosts and party committees. The Guests tab tracks replies, plus ones and dietary needs. The Menu tab works out the cost of each food and drink line. The Tasks tab gives each job an owner and a due date, and the Budget tab compares planned and committed spend. The Dashboard brings the main numbers together.

The template comes with sample guests, menu lines, tasks and budget rows. Make a copy, then replace the sample rows with your own. Totals, the overdue highlights, the dashboard and the chart update on their own as you add rows.

Useful for

  • Running an office or community Christmas party
  • Keeping one shared task list between helpers
  • Checking the food and drink cost against the budget

What's included

  • 6 tabs: Dashboard, Guests, Menu, Tasks, Budget, How to use
  • Dashboard: a dashboard with 4 summary figures
  • Guests: a table
  • Menu: a table
  • Tasks: a table
  • 1 chart that update as you type
  • Formulas, dropdowns and colour rules already set up
  • Sample rows that show how to fill it in

How to use it

  1. 1

    Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.

  2. 2

    Start on the Guests tab: replace the sample rows with your own.

  3. 3

    Keep the formula columns as they are; they fill in as you type.

  4. 4

    Read the How to use tab for tips. For Excel, download the .xlsx file instead.

What you need

Requirements

  • A Google account, or Microsoft Excel for the download

Works with

  • Google Sheets
  • Microsoft Excel (download the .xlsx)

Questions

Is this Holiday Party Planner template free?

Yes. Download the template and make a copy for your own use at no cost.

Does it work in Excel?

Yes. Download the .xlsx file from this page and open it in Microsoft Excel. The tabs, formulas, dropdowns and charts all work there.

Are overdue tasks highlighted?

Yes. A task turns red when its due date has passed and it is not marked Done. The check uses today's date, so it updates every day.

  • #christmas-planner
  • #holiday-party-planner
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More christmas templates

See all 83

Also in Holidays

All holidays templates
Get this template

Preparing your template…