Skip to content
The title slide and first slides of the Birthday Gift Tracker template

Birthday Gift Tracker

Spreadsheet template for Google Sheets and Excel

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

Every slide (6)

Overview

Remembering a birthday is easier than remembering what you gave last time. The People tab holds each name, relationship, birthday and gift budget, then works out the next birthday and the days to go, highlighting anyone within two weeks. The Ideas tab collects gift thoughts through the year with a price and a status. The Given tab records past years with the gift, cost and the reaction it got.

The Dates tab counts the birthdays in the next 30 and 90 days, shows the number of people and the total gift budget and charts birthdays by month so you can see the busy stretches. The sample list has ten made-up people with birthdays across the year. Years of birth can be any year; only the month and day are used.

Useful for

  • See upcoming birthdays before the week arrives
  • Never repeat a gift
  • Plan a gift budget for each month

What's included

  • 5 tabs: People, Dates, Ideas, Given, How to use
  • People: a table
  • Dates: a dashboard with 4 summary figures
  • Ideas: a table
  • Given: 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 People 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

How can I remember birthdays and the gifts I gave?

List each person with their birthday and budget, note ideas when you hear them and record what you gave after the party. The sheet shows the next date and the days to go.

How are days to go calculated?

The sheet takes the month and day of the birthday and finds the next time it occurs from today, then subtracts today. It updates every day the file opens.

Is the birth year required?

No. Any year works, since only the month and day are used. Use a placeholder year if you prefer not to store real birth years.

  • #tracker
  • #birthday-gift-tracker
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More tracker templates

See all 33

Also in Holidays

All holidays templates
Get this template

Preparing your template…