Christmas gift list spreadsheet UK: Excel, Google Sheets, orders and thank-yous
A Christmas gift list spreadsheet (or Christmas present list in Excel or Google Sheets) is the working file where you keep everyone you are buying for, every present and its status, every online order with its delivery and return-by date, and the thank-yous to send after the day. This UK guide compares a gift list spreadsheet with our free browser gift list and an all-in-one Christmas planner, shows the tabs and formulas, gives made-up sample rows and a free DIY method, and is honest about what the ready template does and does not include. It is a planning method, not financial advice.
Free gift list vs gift list spreadsheet vs all-in-one Christmas planner
UK searches for "Christmas gift list" mix three different jobs. Pick the one that fits:
| What | Job | Typical format |
|---|---|---|
| Free Christmas gift list (browser tool) | Quick list of names, ideas and budgets with bought/wrapped ticks; download CSV or print; nothing saved | Web page, no download or sign-up |
| Christmas gift list spreadsheet (this page) | Presents only, in depth: budget per person, 200 gift rows with status, online orders with delivery and return dates, gifts received and thank-yous | Excel or Google Sheets working file, plus printable pages |
| All-in-one Christmas planner | Whole of Christmas in one file: overall budget, gift list, cards, food and drink orders, countdown to-do and Christmas Day timings | Excel or Google Sheets — see the Christmas gift tracker UK guide and the Christmas Planner & Gift Tracker (£4.50) |
A simple rule: if presents and parcels are the headache, use a gift list spreadsheet such as the Christmas Gift List Tracker (£2.99). If you want gifts, cards, food and the day itself in one overview, use the Christmas planner. If you just want a list tonight with no file, use the free tool.
What tabs a Christmas gift list spreadsheet needs
A practical layout matches the same shape as the Christmas Gift List Tracker (£2.99):
- People: name, group (family, children, friends, work, teachers…) and budget per person, with number of gifts, spent, left and a progress label (Nothing yet / Ideas only / In progress / All wrapped) worked out for you.
- Gifts: one row per present — who it is for (drop-down from People), gift, shop, price and status: Idea › Ordered › Bought › Wrapped › Given.
- Online orders: order number, expected delivery, arrived? and return-by date, with alerts for late deliveries and return windows closing within 7 days.
- Overview: days to Christmas, people, gift budget, spent, left, gifts by status, deliveries outstanding and spend by group.
- Gifts received & thank-you list: who gave what, with the thank-yous still to send highlighted.
- Gift ideas & sizes: a page to fill in through the year (clothes and shoe sizes, hints people drop in July).
- Start Here guide tab.
Online orders: late deliveries and return-by dates
Most December stress is parcels, not ideas. Give every online order its own row: the gift it belongs to, the shop, order number, expected delivery date, an arrived? tick and the return-by date. Two simple alerts do the work:
- Late: expected delivery is in the past and arrived? is not ticked — chase the retailer or courier before the last posting week.
- Return closing: the return-by date is within the next 7 days — decide now whether the jumper is the right size.
Returns windows and Christmas returns extensions are set by each retailer, so copy the date from your order confirmation or the shop's returns page rather than guessing. For posting dates, check Royal Mail for the current year.
Gifts received and the thank-you list
After the day, the same file becomes your thank-you list: who gave what, and whether a thank-you card, message or call has gone out. Highlighting the ones still to send stops a great-aunt slipping through the cracks in January. Children can help write cards from the list — our letter to Santa template UK guide has free wording ideas for younger writers.
Excel vs Google Sheets vs printable gift list
| Need | Excel (.xlsx) | Google Sheets | Printable A4 |
|---|---|---|---|
| Totals, budget left, alerts | Formulas work offline | Same formulas, live on your phone | Tick boxes only — add up by hand |
| Sharing with a partner | OneDrive / email copies | Share a link; both edit live | One copy on the fridge |
| Hiding it from the children | File on your laptop | Private Drive file (do not share with the family account) | Harder to hide |
| UK £ and DD/MM/YYYY | Format cells / regional settings | File › Settings › Locale: United Kingdom | — |
A common UK workflow is to keep the .xlsx on Google Drive so you can check it in the shop, then print a gift-list page for wrapping night. The Christmas Gift List Tracker (£2.99) ships as .xlsx plus a 5-page printable A4 PDF (2 gift-list pages with ordered/arrived/wrapped tick boxes, online orders & returns, gift ideas & sizes, gifts received & thank-yous) for that reason.
Example gift list rows (made-up)
The rows below are a made-up example for an imaginary household. They are illustrative only — not typical spends, averages or a recommended list.
| For (example) | Gift (example) | Shop (example) | Price £ (example) | Status (example) |
|---|---|---|---|---|
| Example — Nan | Photo calendar | Online print shop | 18.00 | Ordered |
| Example — Leo (age 7) | Science kit | Toy shop | 24.00 | Wrapped |
| Example — Priya (friend) | Candle | High street | 12.00 | Bought |
| Example — Class teacher | Card + chocolates | Supermarket | 6.00 | Idea |
| Order (example) | Expected (example) | Arrived? (example) | Return by (example) | Alert (example) |
|---|---|---|---|---|
| Example — #A1001 photo calendar | 04/12/2026 | No | — | Late (if today is after 04/12) |
| Example — #B2002 jumper | 28/11/2026 | Yes | 15/12/2026 | Return window closing (within 7 days) |
These names, prices, order numbers and dates are fiction for layout only.
How to make a Christmas gift list spreadsheet yourself (free DIY)
- Sheet 1 — People: name, group, budget. Add Spent
=SUMIF(Gifts!A:A,A2,Gifts!D:D)and Left=C2-D2. - Sheet 2 — Gifts: For (data validation list from People), gift, shop, price, status (data validation: Idea, Ordered, Bought, Wrapped, Given).
- Sheet 3 — Online orders: gift, shop, order number, expected delivery, arrived?, return-by. Late alert:
=IF(AND(E2<>"Yes",D2<TODAY()),"LATE",""). Return alert:=IF(AND(F2>=TODAY(),F2-TODAY()<=7),"Return soon",""). - Sheet 4 — Overview: days to Christmas
=DATE(2026,12,25)-TODAY(), total budget, total spent, COUNTIF of each status and of orders not yet arrived. - Sheet 5 — Thank-yous: from, gift received, thank-you sent? — use conditional formatting to highlight the blanks.
- Weekly check: ten minutes each weekend from November — update statuses, chase late parcels, decide on returns. Count down with days until Christmas and set the overall figure with the Christmas budget calculator.
Prefer not to build the drop-downs, late and return alerts and the Overview yourself? The Christmas Gift List Tracker (£2.99) already includes People, Gifts (200 rows), Online orders, Overview, Gifts received & thank-yous, Gift ideas & sizes, the printable PDF and Start Here.
DIY vs ready gift list vs planner vs bundle
- Free and no file: the Christmas gift list browser tool — CSV download or print, nothing stored.
- DIY (free): the steps above in a blank Excel workbook or Google Sheet.
- Ready gift list spreadsheet: the Christmas Gift List Tracker (£2.99) when presents, parcels, returns and thank-yous are the main job.
- Whole of Christmas in one file: the Christmas Planner & Gift Tracker (£4.50) — gift list plus cards, food and drink orders, countdown to-do and Christmas Day timings. Compare the columns on the Christmas gift tracker UK guide.
- Christmas money in depth: the Christmas Budget Planner (£2.99) for category budgets, a spending log and a payday savings plan — see the Christmas budget spreadsheet UK guide.
- Everything: the Christmas Planner Bundle (10 templates) (£7.99) includes the Gift List Tracker alongside the Budget Planner, Christmas Planner & Gift Tracker and seven more Christmas templates in one download.
- Wrapping night: the Christmas Gift Tags & Advent Labels (Printable) (£1.99) once everything is ticked Wrapped — see Christmas gift tags printable UK.
What is (and is not) in the Christmas Gift List Tracker
- Included in the Christmas Gift List Tracker (£2.99): People (name, group and budget per person, with gifts, spent, left and progress worked out); Gifts (200 rows: who it is for via drop-down, gift, shop, price, status Idea › Ordered › Bought › Wrapped › Given); Online orders (order number, expected delivery, arrived?, return-by date, with alerts for late deliveries and return windows closing within 7 days); Overview (days to Christmas, people, gift budget, spent, left, gifts by status, deliveries outstanding, spend by group); Gifts received & thank-you list with the ones still to send highlighted; Gift ideas & sizes page; printable A4 PDF (5 pages); Start Here guide; example rows to overwrite. Excel .xlsx (Excel 2016 or later / Microsoft 365) or upload to Google Sheets. UK edition (£ GBP, DD/MM/YYYY). Digital download for personal use or use within your own organisation. AI-assisted with an original brief.
- Not included: it is a presents-only tracker — no Christmas card list, food orders, countdown to-do or Christmas Day timings (those are in the Christmas Planner & Gift Tracker (£4.50)), and no category budget or savings plan (that is the Christmas Budget Planner (£2.99)). It does not connect to shops or couriers, so delivery and return dates are the ones you type in. Nothing physical is posted; please do not resell or share the files. It is a planning tool, not financial advice.
More: Christmas gift tracker UK · Christmas gift list (free tool) · Christmas budget spreadsheet UK · family Christmas budget · Christmas to-do list UK · Christmas gift tags printable UK · Secret Santa spreadsheet UK · days until Christmas · Christmas budget calculator
Free tools for this
- Christmas Gift List & Budget Tracker
- Days Until Christmas 2026: Countdown & Savings Planner
- Christmas Budget Calculator (UK)
Frequently asked questions
What is a Christmas gift list spreadsheet?
A working Excel or Google Sheets file where you list everyone you are buying for with a budget, log each present with its shop, price and status, track online orders with delivery and return-by dates, and keep a thank-you list after the day. It is more detailed than a one-off paper or browser list.
Is there a Christmas gift list template for Excel or Google Sheets?
Yes. You can build the tabs in this guide yourself, or use our Christmas Gift List Tracker (£2.99): an Excel .xlsx you can upload to Google Sheets, with People, Gifts (200 rows), Online orders, Overview, thank-you list, gift ideas and sizes, and a printable A4 PDF.
How is this different from the Christmas gift tracker guide and the Christmas planner?
The Christmas gift tracker UK guide covers the basic gift columns and how gifts sit inside a whole-Christmas planner (cards, food, to-do, Day timings). This page is the presents-only spreadsheet in depth: online orders, late delivery and return alerts, gifts received and thank-yous.
How do I track online Christmas orders and returns in a spreadsheet?
Give each order a row with gift, shop, order number, expected delivery, arrived? and return-by date. Flag LATE when the expected date has passed and it has not arrived, and flag returns closing within 7 days. Take the return-by date from the retailer, as policies vary.
How do I keep a Christmas thank-you list?
List who gave what and add a thank-you sent? column. Highlight the blanks with conditional formatting so you can see who is left. Our Christmas Gift List Tracker includes a gifts received and thank-you list with the ones still to send highlighted.
Can I print a Christmas gift list?
Yes. Our free Christmas gift list tool prints from the browser. The Christmas Gift List Tracker also includes a 5-page printable A4 PDF: two gift-list pages with ordered, arrived and wrapped tick boxes, online orders and returns, gift ideas and sizes, and gifts received and thank-yous. Print at 100% / actual size.
Free gift list or a paid template?
If you only need names, ideas, budgets and bought/wrapped ticks, the free Christmas gift list tool or a DIY sheet is enough. A ready template such as our Christmas Gift List Tracker suits you if you want the order, delivery and return alerts, overview and thank-you list already set up.
What is included in the Christmas Gift List Tracker?
People with budget, spent, left and progress; Gifts (200 rows) with status Idea, Ordered, Bought, Wrapped, Given; Online orders with late and return-window alerts; Overview; Gifts received and thank-you list; Gift ideas and sizes; printable A4 PDF (5 pages); Start Here. Excel .xlsx for Google Sheets upload, UK edition in £ with DD/MM/YYYY. Digital download; nothing is posted; not financial advice.
Written with AI assistance and checked against GOV.UK guidance. General information, not financial, tax or legal advice.