Skip to content
The title slide and first slides of the Christmas Gift List template

Christmas Gift List

Spreadsheet template for Google Sheets and Excel

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

Every slide (3)

Overview

A gift list for keeping track of who you are buying for. Each row is one person, with their relationship, budget, gift idea, where to buy it, the price paid and whether the gift is bought and wrapped. The Dashboard shows the total budget, the spend and what is left, broken down by relationship.

The template comes with sample people and gifts. Make a copy, then replace the sample rows with your own. The overspend column, the dashboard and the chart update on their own as you enter prices.

Useful for

  • Setting a budget for each person before shopping
  • Ticking off gifts as they are bought and wrapped
  • Checking the total spend against the budget

What's included

  • 3 tabs: Dashboard, Gifts, How to use
  • Dashboard: a dashboard with 4 summary figures
  • Gifts: 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 Gifts 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 Christmas Gift List 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, checkboxes and charts all work there.

Can I keep gift lists for more than one year?

Make a copy for each year. Clear the sample rows and keep the same tabs and formulas for the new list.

  • #christmas-planner
  • #christmas-gift-list
  • #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…