Christmas gift tracker UK: spreadsheet columns and a planner template

A Christmas gift tracker spreadsheet keeps every recipient, budget, purchase and wrap status in one place — in Excel, Google Sheets or a printable grid — so you do not buy twice or find an unwrapped present on Christmas Eve. This guide shows practical columns, an illustrative sample, a Christmas card list, and how the gift tracker sits inside a wider Christmas planner (countdown to-do, food, Day timings). It is a planning method, not financial advice. For a free browser tool that needs no download, use the Christmas gift list instead.

What this guide is (and is not)

Gift tracker vs free browser list vs full Christmas planner

Columns for a Christmas gift tracker spreadsheet

One row per present (or one row per person if you buy one main gift each). Rename columns to match your household.

ColumnWhat goes in it
RecipientWho the gift is for
GroupFamily, children, friends, work, teachers, hosts — useful for filters and totals
Budget (£)Limit you set before shopping
Gift ideaWhat you plan to buy (or "TBC")
From / shopWhere you will buy or ordered from
Spent (£)What you actually paid
Bought?Yes / No (or Idea → Ordered → Bought)
Wrapped?Yes / No
Given?Optional — useful if some gifts go early (teachers, Secret Santa)
NotesSize, colour, delivery date, "from Mum and Dad", return window

Optional extras that help in December: order number, expected delivery, arrived?, return-by date. Those belong on a detailed gift-list tracker such as the Christmas Gift List Tracker (£2.99) if online parcels are your main headache.

Want the presents-only spreadsheet in depth (People, 200 gift rows, online orders with late and return-by alerts, gifts received and thank-yous)? See the Christmas gift list spreadsheet UK guide — that page is the gift-list sibling to this planner-focused guide.

Illustrative sample rows (made-up)

The rows below are made-up examples to show the layout. They are not typical spends, averages or a recommended list.

RecipientGroupBudgetGift ideaFromSpentBoughtWrapped
Example — MumFamily£25CookbookHigh street£22YesYes
Example — SamChildren£40Building setOnline shop£38YesNo
Example — Alex (work)Work£10Secret SantaTBC£0NoNo
Example — NeighboursHosts£15Box of biscuitsSupermarket£12YesYes

Add a simple total row: sum of Budget, sum of Spent, and Budget minus Spent so you see what is left before you buy the next present.

Christmas card list (same spreadsheet or a second tab)

Cards are easy to forget until the last posting week. A short card list keeps names and sent/received next to the gift tracker:

Check Royal Mail for the current year's last posting dates before you rely on second class — dates change each year, so do not invent them from memory. For week-by-week jobs around cards and gifts, see the Christmas to-do list UK.

How the gift tracker pairs with a Christmas planner

Gifts are only one strand. A practical Christmas planner usually also has:

Boxing Day 2026 falls on Saturday 26 December, so the Boxing Day bank holiday in England and Wales is the substitute day on Monday 28 December 2026 (GOV.UK bank holidays). Put leftovers and fridge space on the to-do list for that long weekend if you host.

Printable, Excel, Google Sheets or app?

DIY sheet vs ready templates

More: Christmas gift list spreadsheet UK · Christmas budget spreadsheet UK · Christmas gift list (free tool) · Christmas to-do list UK · family Christmas budget · how much to save for Christmas · days until Christmas · Christmas budget calculator · printable advent calendar · letter to Santa template · Christmas gift tags printable UK

Free tools for this

Frequently asked questions

Is there a Christmas gift list spreadsheet with online orders and thank-yous?

Yes. Our Christmas gift list spreadsheet UK guide covers a presents-only Excel or Google Sheets file with budget per person, gift status, online orders with late-delivery and return-by alerts, and a gifts received and thank-you list. The Christmas Gift List Tracker template has those tabs ready.

What columns should a Christmas gift tracker have?

Recipient, group, budget, gift idea, shop or from-who, spent, bought, wrapped, optional given, and notes. Add order number, delivery and return-by if you buy online a lot.

Is there a Christmas gift tracker template for Excel or Google Sheets?

Yes. You can build the columns in this guide yourself, or use our Christmas Planner & Gift Tracker (all-in-one planner with a gift list) or the Christmas Gift List Tracker (presents-focused). Both work in Excel and Google Sheets with £ and UK dates.

Is a Christmas gift tracker the same as a Christmas gift list?

Almost: both list who you buy for. A tracker usually adds budget, spent and status columns (bought / wrapped) and lives in a spreadsheet you reuse. Our free Christmas gift list is the same idea in the browser with CSV download — no file to keep.

How do I track Christmas gifts on a budget?

Set a budget next to each name before you shop, enter what you actually spend, and watch the running total of spent vs budget. Set the overall Christmas figure with the free Christmas budget calculator first.

Should I use a Christmas planner or just a gift list?

A gift list is enough if presents are the only loose end. A Christmas planner helps when you also need a countdown to-do, card list, food orders and Day timings in one place.

What belongs on a Christmas card list template?

Name, how you send it (card, e-card or message), sent/received ticks and notes. Check Royal Mail for current last posting dates rather than guessing.

Can I make a free Christmas gift tracker spreadsheet?

Yes. Copy the column list above into a blank Excel or Google Sheets file and add a SUM for budget and spent. Or use the free browser Christmas gift list and download CSV if you only need a one-off list.

Is the Christmas Planner & Gift Tracker financial advice?

No. It is a fill-in Excel and Google Sheets planning template. This guide is not financial advice either — set limits you can afford without borrowing.

Written with AI assistance and checked against GOV.UK guidance. General information, not financial, tax or legal advice.