Secret Santa spreadsheet UK: Excel and Google Sheets organiser
A Secret Santa spreadsheet (Excel or Google Sheets organiser) keeps the names, must-not-draw pairs, spend limit, swap date, wish lists and “you're buying for…” messages in one file you can reopen — unlike a one-off browser draw. This UK guide compares a spreadsheet with a free online generator, shows the columns that matter, explains how a fair draw works conceptually, covers tips when the organiser is in the draw, Excel vs Sheets, printable gift tags and reveal cards, and when to DIY, buy a ready template or take the Christmas bundle. It is a planning method, not legal, tax or financial advice. Choosing a fair price limit first? See the Secret Santa budget for work (UK) guide. Only need an anonymous draw with no wishlist? Use the free Secret Santa generator.
What this guide is (and is not)
- Is: the method for a Secret Santa spreadsheet / Excel / Google Sheets organiser with exclusions, wish lists, messages and printable tags — records you keep after the draw.
- Is not: a price-limit and office-rules walk-through (Secret Santa budget for work UK), a free one-click browser draw (Secret Santa generator), or a full office party plan (office Christmas party planning UK / Christmas party checklist UK).
- Honest split: the free generator is enough for a one-off anonymous draw with a budget on each link and no wishlist. The Secret Santa Organiser (£2.99) is for kept records, must-not-draw pairs, wish lists, copy-paste messages and printable tags.
Spreadsheet vs free online generator
| Topic | Free online generator | Spreadsheet organiser |
|---|---|---|
| Best for | Quick anonymous draw; WhatsApp / Teams links | Office or family draw you want to reopen, edit and print |
| Exclusions | Yes (pairs who must not draw each other) | Yes (must-not-draw per person) |
| Wish lists | Usually none in the draw itself | Yes — stored next to each name and pulled into messages |
| Messages | Private link per person | Copy-paste “you're buying for…” with limit, date and wishlist |
| Printables | None (links only) | Gift tags, reveal cards, wish-list cards, paper organiser |
| Organiser in the draw | Matches hidden on screen; organiser opens own link | Tips tab; draw stays fixed until you change the draw number or names |
| Use both? | Yes — draw online for speed, or keep everything in the spreadsheet if you need records and tags | |
Set the price limit and opt-in rules with the budget for work guide either way. Fold the swap into the party plan with the office Christmas party planning guide, office Christmas party games and the free Christmas party checklist UK.
Columns matching a Secret Santa organiser
Keep one sheet. Share only each person's own message — never the full draw — so matches stay secret.
| Column / field | Why it matters |
|---|---|
| Group name | Office team, family or friends label on every message |
| Spend limit | One figure (for example £10) so nobody over- or under-spends |
| Swap date and place | When and where gifts are opened |
| Name + contact | Who is in the draw and how to reach them |
| Wish list | Hints for the buyer; appears on their message |
| Must not draw | Partner, flatmate or teammate who should not be matched |
| Draw / match | Who they buy for (hidden from the group view) |
| Status check | Confirms everyone is matched or flags a must-not-draw clash |
| Messages | Ready text: “Hi Amelia! You're Secret Santa for George…” with limit, date and wishlist |
How the draw works (conceptually)
A fair Secret Santa draw is a derangement with extra rules: everyone is assigned exactly one person to buy for, nobody gets themselves, and any must-not-draw pairs are avoided. In a spreadsheet organiser:
- Enter every participant and any must-not-draw names.
- Run the draw (often by typing a draw number so you can retry if the status check flags a clash).
- Check status — everyone matched, or a clash that needs another draw number.
- The draw stays the same each time you open the file until you change the draw number or the names.
- Copy each person's message from the Messages tab into a private text, email, Teams or Slack DM — one recipient only.
If the rules make a fair draw impossible (for example three people where one is excluded from both others), change the exclusions or the group rather than breaking a rule.
Tips when the organiser is in the draw
- Do not leave the full match list on a shared screen or printer tray.
- Send messages one by one from the Messages tab, or ask a trusted colleague who is not in the draw to send them.
- If you use the free Secret Santa generator instead, matches are not shown on the organiser's screen — only private links — so you can open your own link like everyone else.
- Keep gifts suitable for work; agree anonymity and the open date in the rules template from the budget guide.
Illustrative sample rows (made-up)
The rows below are made-up examples to show the layout. They are not real people or a recommended office list.
| Name | Must not draw | Wish list (example) | Notes |
|---|---|---|---|
| Example — Amelia | Example — George | Example — nice mug, plant | Example — partners |
| Example — George | Example — Amelia | Example — socks, dark chocolate | Example — partners |
| Example — Priya | — | Example — notebook, tea | Example — remote; post by 10 Dec |
| Example — Sam | Example — Jordan | Example — board game | Example — flatmates |
Example message shape (made-up): “Hi Amelia! You're Secret Santa for George. Spend limit: £15.00. Swap date: Friday 18 December… Wish list: socks, dark chocolate.”
Excel vs Google Sheets
- Excel: download the .xlsx and open it in Excel 2016 or later / Microsoft 365.
- Google Sheets: upload the .xlsx to Google Drive, open it, then File › Save as Google Sheets (free Google account needed). Handy when several people add wish lists from phones — but lock or hide the draw columns so matches stay private.
- A Start Here tab walks through every step. Example rows show how it works — overwrite or clear them.
Printable gift tags, reveal cards and wish-list cards
A spreadsheet organiser often ships with a printable A4 PDF: Secret Santa gift tags, “You're buying for…” reveal cards, wish-list cards and a paper organiser sheet with a checklist. Print at 100% / actual size on A4, or fill in on a tablet. Useful when some of the group prefer paper, or for the gift pile at the party. For general Christmas To/From and message tags (not Secret Santa), see Christmas gift tags printable UK.
DIY vs ready template vs Christmas bundle
- DIY: copy the columns above into a blank Excel or Google Sheets file and run the draw by hand (or with a simple formula). Costs nothing except your time; you build messages and tags yourself.
- Ready organiser: the Secret Santa Organiser (£2.99) if you want automatic matching, must-not-draw pairs, status check, Messages tab and printable tags already built.
- Free browser draw: the Secret Santa generator when you only need private links, exclusions and a budget — no wishlist or printables.
- Christmas bundle: the Christmas Planner Bundle (10 templates) (£7.99) for ten Christmas templates including the Secret Santa Organiser.
- Party planner: the Corporate Event & Christmas Party Planner (£8.95) when the Secret Santa sits inside a full office Christmas party spreadsheet.
- Games pack: the Office Christmas Party Games (£2.99) for printable quiz, bingo and more at the reveal.
- Free party checklist: the FREE Christmas Party Checklist (Printable) (£0) for the jobs around the party, not the draw itself.
More: Secret Santa generator · Secret Santa budget for work · office Christmas party planning · office Christmas party games · Christmas party checklist UK · cost per head calculator · HMRC £150 Christmas party rule
Free tools for this
- Secret Santa Generator (free, no email)
- Office Christmas Party Cost Per Head Calculator
- Party Drinks Calculator (UK)
Frequently asked questions
Is there a Secret Santa spreadsheet for Excel or Google Sheets?
Yes. You can build the columns in this guide yourself, or use our Secret Santa Organiser — an Excel template that also works in Google Sheets after upload, with names, must-not-draw pairs, automatic draw, status check, Messages tab and printable A4 gift tags, in £ with UK dates.
How is a Secret Santa spreadsheet different from a free online generator?
A free generator is ideal for a one-off anonymous draw with private links and exclusions. A spreadsheet keeps records you can reopen: wish lists, copy-paste messages, status checks and printable tags. Use the free Secret Santa generator when you only need links; use a spreadsheet organiser when you need the paperwork.
What columns should a Secret Santa organiser have?
Group name, spend limit, swap date and place, each person's name and contact, wish list, anyone they must not draw, the match, a status check and a messages tab with ready text for each buyer.
How do Secret Santa exclusions or must-not-draw pairs work?
Mark partners, flatmates or teammates who should not buy for each other. The draw should avoid those pairs both ways and still ensure nobody gets themselves. If the rules make a fair draw impossible, change the exclusions or group size.
Can the organiser take part in a spreadsheet Secret Santa?
Yes, with care: do not leave the full match list visible, and send each message privately. Some organisers ask someone outside the draw to send the messages. Our free browser generator hides matches on the organiser screen and uses private links instead.
Does a Secret Santa spreadsheet include printable gift tags?
A ready organiser often includes an A4 PDF with gift tags, reveal cards, wish-list cards and a paper organiser sheet. You can also print tags from a DIY sheet. Our Secret Santa Organiser includes those printables alongside the spreadsheet.
Is there a Secret Santa message template?
Yes. A messages tab can write out each person's text with the recipient's name, spend limit, swap date and wish list, ready to copy into a text or email. This guide shows the shape; the Secret Santa Organiser fills it automatically.
Is the Secret Santa Organiser legal or financial advice?
No. It is a fill-in Excel planning template. This guide is not legal, tax or financial advice. For workplace price limits and opt-in rules, see the Secret Santa budget for work UK guide; for employer-paid gifts, check GOV.UK trivial benefits guidance.
Written with AI assistance and checked against GOV.UK guidance. General information, not financial, tax or legal advice.