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:

WhatJobTypical format
Free Christmas gift list (browser tool)Quick list of names, ideas and budgets with bought/wrapped ticks; download CSV or print; nothing savedWeb 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-yousExcel or Google Sheets working file, plus printable pages
All-in-one Christmas plannerWhole of Christmas in one file: overall budget, gift list, cards, food and drink orders, countdown to-do and Christmas Day timingsExcel 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):

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:

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

NeedExcel (.xlsx)Google SheetsPrintable A4
Totals, budget left, alertsFormulas work offlineSame formulas, live on your phoneTick boxes only — add up by hand
Sharing with a partnerOneDrive / email copiesShare a link; both edit liveOne copy on the fridge
Hiding it from the childrenFile on your laptopPrivate Drive file (do not share with the family account)Harder to hide
UK £ and DD/MM/YYYYFormat cells / regional settingsFile › 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 — NanPhoto calendarOnline print shop18.00Ordered
Example — Leo (age 7)Science kitToy shop24.00Wrapped
Example — Priya (friend)CandleHigh street12.00Bought
Example — Class teacherCard + chocolatesSupermarket6.00Idea
Order (example)Expected (example)Arrived? (example)Return by (example)Alert (example)
Example — #A1001 photo calendar04/12/2026No—Late (if today is after 04/12)
Example — #B2002 jumper28/11/2026Yes15/12/2026Return 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)

  1. Sheet 1 — People: name, group, budget. Add Spent =SUMIF(Gifts!A:A,A2,Gifts!D:D) and Left =C2-D2.
  2. Sheet 2 — Gifts: For (data validation list from People), gift, shop, price, status (data validation: Idea, Ordered, Bought, Wrapped, Given).
  3. 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","").
  4. 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.
  5. Sheet 5 — Thank-yous: from, gift received, thank-you sent? — use conditional formatting to highlight the blanks.
  6. 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

What is (and is not) in the Christmas Gift List Tracker

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

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.