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)
- Is: the spreadsheet / planner method for a Christmas gift tracker — columns for recipient, budget, spent, bought, wrapped, where from and notes — plus a card list and how gifts fit a full Christmas planner.
- Is not: the free in-browser gift list (that is /christmas-gift-list/: type names, tick bought/wrapped, download CSV or print, nothing saved). This page is for people searching for a Christmas gift tracker template, spreadsheet, Excel, Google Sheets or printable planner.
- Product honesty: the Christmas Planner & Gift Tracker (£4.50) is a ready planner that already includes a gift tracker and more (cards, food, to-do, Day timings). The Christmas Gift List Tracker (£2.99) is the focused gift-list tracker (presents, online orders, returns, thank-yous). The free browser tool needs no purchase.
Gift tracker vs free browser list vs full Christmas planner
- Free browser gift list (Christmas gift list): quick session in the browser; CSV download or print; nothing stored. Best when you want zero download.
- Gift tracker spreadsheet (this page): a reusable Excel or Sheets file you keep all season — budgets, statuses, shops and notes in columns you control.
- Full Christmas planner: gift tracker plus countdown to-do, card list, food orders, budget overview and Day timings in one workbook — the job the Christmas Planner & Gift Tracker (£4.50) is built for. Pair money detail with the free Christmas budget calculator and the family Christmas budget UK guide.
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.
| Column | What goes in it |
|---|---|
| Recipient | Who the gift is for |
| Group | Family, children, friends, work, teachers, hosts — useful for filters and totals |
| Budget (£) | Limit you set before shopping |
| Gift idea | What you plan to buy (or "TBC") |
| From / shop | Where 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) |
| Notes | Size, 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.
| Recipient | Group | Budget | Gift idea | From | Spent | Bought | Wrapped |
|---|---|---|---|---|---|---|---|
| Example — Mum | Family | £25 | Cookbook | High street | £22 | Yes | Yes |
| Example — Sam | Children | £40 | Building set | Online shop | £38 | Yes | No |
| Example — Alex (work) | Work | £10 | Secret Santa | TBC | £0 | No | No |
| Example — Neighbours | Hosts | £15 | Box of biscuits | Supermarket | £12 | Yes | Yes |
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:
- Name and address or "message only"
- Sent? / Received?
- Notes (e-card, stamp needed, photo card)
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:
- Countdown to-do — budget, travel, food orders, wrapping, Eve prep (see Christmas to-do list UK and days until Christmas).
- Wrapping and tags — once a present is ticked “Wrapped”, tag it: see Christmas gift tags printable UK or the Christmas Gift Tags & Advent Labels (Printable) (£1.99).
- Budget overview — gifts vs food, travel, parties; set the total with the Christmas budget calculator, then save towards it with how much to save for Christmas UK.
- Food and Day timings — menu and shop, then oven schedule from serving time (Christmas dinner planner UK, dinner timings calculator).
- Card list — as above, so cards do not steal Christmas Eve.
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?
- Printable / paper: fine for a short list; harder to total budgets when the list grows.
- Excel or Google Sheets: filters, SUM of budget vs spent, and a file you reopen each year. Upload an .xlsx to Drive and use File → Save as Google Sheets if you prefer Sheets.
- Phone app: handy on the shop floor; still export or mirror into a spreadsheet if you want one household source of truth.
- Free browser tool: our Christmas gift list when you do not want a file at all.
DIY sheet vs ready templates
- DIY: create the columns above in a blank spreadsheet. Costs nothing except your time.
- Gift list only: the Christmas Gift List Tracker (£2.99) if you want orders, returns and thank-yous already laid out.
- All-in-one planner: the Christmas Planner & Gift Tracker (£4.50) for gifts + cards + to-do + food + Day timings.
- Budget depth: the Christmas Budget Planner (£2.99) when category budgets and a payday savings plan are the main gap — see the Christmas budget spreadsheet UK guide for the columns.
- Bundle: the Christmas Planner Bundle (10 templates) (£7.99) puts ten Christmas templates in one download if you want the set.
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
- Christmas Gift List & Budget Tracker
- Days Until Christmas 2026: Countdown & Savings Planner
- Christmas Budget Calculator (UK)
- Christmas Dinner Timings Calculator
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.