Track Gifts in Google Sheets

To track gifts in Google Sheets, create one row per gift and columns for recipient, occasion, year, gift, status, link, and notes. Record an item when you consider or buy it. Before shopping, filter by the recipient to see unused ideas and gifts you have already given.

Set up the sheet

Create a blank Google Sheet and name it Gift Tracker. Use these headers in the first row:

Recipient	Occasion	Year	Gift	Status	Link	Notes

Freeze the header row so the column names remain visible as the list grows. Turn on a filter for the header row. The filter lets you narrow the sheet by person, occasion, year, or status without rearranging the underlying records.

Keep everything in one sheet at first. Separate tabs for every person or year feel tidy, but they make it harder to search your full gift history. One table lets you answer questions that span several years.

Add one row for every gift

Use a separate row for each idea or purchase. A row might look like this:

The notes column should explain why the gift seemed right. That context is often more valuable than the product name. Six months from now, camping mug may look generic. Old mug cracked, prefers ceramic tells you exactly why you saved it.

Enter the recipient's name consistently. Do not switch between Mom, Mum, Mother, and her full name. Filters only work cleanly when the values match.

For couples or households, decide whether the recipient is an individual or the household. Sam and Priya works for a shared present. Use separate rows when each person is receiving something different.

Use a small set of statuses

A status shows what still needs attention. Keep the choices simple:

Idea
Considering
Bought
Wrapped
Given

You can add a dropdown to the Status column using Google Sheets data validation. A dropdown reduces spelling differences and makes filtering easier.

Do not create a status for every possible event. A long workflow becomes another task to maintain. The sheet only needs to tell you whether an idea is available, whether you bought it, and whether the gift has been given.

Update the status instead of deleting the row. The old rows become your gift history.

Record enough detail to prevent duplicates

The sheet can answer “Did I already give her that?” only if the record identifies the gift clearly.

For a book, include the title and author. For clothing, include the type, brand, colour, or pattern. For an experience, include the venue or activity. For a recurring category such as candles or slippers, describe the specific item.

A useful row could say:

That is easier to recognize than candle. It also lets you see whether you keep returning to the same category for the same person.

Add the year in its own column even if the occasion includes a date. You can then filter one person's history across several years or review everything purchased for one holiday season.

Save ideas as soon as they appear

The best gift ideas often arrive months before you need them. Someone mentions a broken mug, admires a bag, or talks about a class they want to try. Waiting until the holiday means relying on a memory with no useful prompt.

Open the sheet and add a row while the clue is fresh. Use Idea as the status. Paste a product link if one exists, but do not save a bare link. Pages change, items disappear, and URLs rarely explain why you cared.

When you cannot open the sheet immediately, capture the idea in whatever is closest, then transfer it later. A temporary note is fine if you have a routine for clearing it. A useful habit is to review temporary notes whenever you update the sheet after a purchase.

Filter the sheet before shopping

Before a birthday or holiday, filter the Recipient column to the person you are buying for. Then review two groups.

First, look at rows marked Idea or Considering. These are your current options. Check the notes before opening the links because the reason may point you toward a better version of the original item.

Second, look at rows marked Given. This is your duplicate check. You can see whether you already bought the same object or have repeated one category too often.

For Christmas shopping, you can also filter by the current year and hide rows marked Given. That produces a working list of gifts still in progress. Keep the recipient filter available so you can focus on one person at a time.

Make the sheet usable on your phone

A gift tracker fails if adding a row feels like paperwork. Keep the important columns on the left so they appear first on a small screen. Recipient, gift, and status deserve the first positions. Links and longer notes can sit farther right.

Avoid decorative merged cells, separate layouts for each occasion, and complex formulas. They make the file harder to update from a phone. The useful part of the sheet is the consistent table, not its appearance.

Bookmark the sheet in your browser or star it in Google Drive. If you share gift planning with a partner, share the file carefully and agree on the same recipient names and statuses. Remember that a shared sheet is a poor place to track a surprise for the person who can open it.

Choose a lighter tool if the sheet becomes a chore

Google Sheets is a good fit when you want a visible table, filters, and a long gift history. It is less convenient when most ideas arrive as photos, spoken comments, or pages you encounter while browsing.

If you stop opening the sheet, simplify it before abandoning the habit. Remove unused columns and return to recipient, gift, status, and notes. You could also use a notes app or a searchable saving tool such as dEssence, as long as every entry still includes who the gift is for and why you saved it.

The next time you buy a gift, add the row before closing the confirmation page or putting away the receipt. That single completed record is enough to start a history you can use next year.