Track Gifts in Google Sheets

Set up the sheet

Create a blank Google Sheet named Gift Tracker. Use these headers:

Recipient	Occasion	Year	Gift	Status	Link	Notes

Freeze the header row and turn on a filter. Filters let you narrow the table by person, occasion, year, or status without rearranging the records.

Keep everything in one sheet initially. Separate tabs for every person or year make it harder to search a history spanning several years.

Add one row for every gift

A row might look like this:

The notes column preserves why the gift seemed right. Six months later, camping mug may feel generic; old mug cracked, prefers ceramic restores the reason.

Use recipient names consistently. Do not alternate between Mom, Mum, Mother, and a full name. Filters work cleanly only when values match.

Use a household name such as Sam and Priya for a shared present, and separate rows when each person receives something different.

Use a small set of statuses

Recommended statuses are:

Idea
Considering
Bought
Wrapped
Given

Add a dropdown to the Status column with Google Sheets data validation to avoid spelling variations.

Do not create a status for every possible event. The sheet only needs to show whether an idea is available, whether it was bought, and whether it was given.

Update the status instead of deleting a row. Completed rows become the gift history.

Record enough detail to prevent duplicates

The sheet can answer “Did I already give her that?” only if the gift is identifiable.

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

For example:

That is more recognizable than candle and reveals whether you repeatedly choose the same category.

Keep the year in its own column even when the occasion has a date. You can then review one person's history across years or one holiday season across recipients.

Save ideas as they appear

Gift ideas often arrive months early: someone mentions a broken mug, admires a bag, or talks about a class they want to try.

Add a row while the clue is fresh and use Idea as the status. Paste a product link when available, but never save a bare URL. Pages change, products disappear, and links rarely explain why you cared.

If you cannot open the sheet immediately, capture the idea in the closest tool and transfer it later. Review temporary notes whenever you update the tracker after a purchase.

Filter before shopping

Filter the Recipient column to the person you are buying for, then review two groups:

Idea or Considering: current possibilities. Read the reason before opening the link; it may point to a better version.
Given: the duplicate check. Look for repeated objects and categories.

For Christmas, filter by the current year and hide rows marked Given to produce 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 a phone

Place Recipient, Gift, and Status on the left. Links and longer notes can sit farther right.

Avoid merged cells, separate layouts for each occasion, and complex formulas. The useful part is the consistent table, not decorative formatting.

Bookmark the sheet or star it in Google Drive. When planning with a partner, agree on recipient names and statuses. A shared sheet is a poor place to track a surprise for someone who can open it.

Choose a lighter tool if the sheet becomes a chore

Google Sheets suits a visible table, filters, and a long history. It is less convenient when ideas arrive as photos, spoken comments, or pages encountered while browsing.

Simplify before abandoning the habit. Remove unused columns and return to recipient, gift, status, and notes. A notes app or searchable saving tool such as dEssence can also work, provided every entry includes who the gift is for and why it was saved.

After the next purchase, add the row before closing the confirmation page or putting away the receipt. That one record starts a history you can use next year.