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)

Spreadsheet vs free online generator

TopicFree online generatorSpreadsheet organiser
Best forQuick anonymous draw; WhatsApp / Teams linksOffice or family draw you want to reopen, edit and print
ExclusionsYes (pairs who must not draw each other)Yes (must-not-draw per person)
Wish listsUsually none in the draw itselfYes — stored next to each name and pulled into messages
MessagesPrivate link per personCopy-paste “you're buying for…” with limit, date and wishlist
PrintablesNone (links only)Gift tags, reveal cards, wish-list cards, paper organiser
Organiser in the drawMatches hidden on screen; organiser opens own linkTips 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 / fieldWhy it matters
Group nameOffice team, family or friends label on every message
Spend limitOne figure (for example £10) so nobody over- or under-spends
Swap date and placeWhen and where gifts are opened
Name + contactWho is in the draw and how to reach them
Wish listHints for the buyer; appears on their message
Must not drawPartner, flatmate or teammate who should not be matched
Draw / matchWho they buy for (hidden from the group view)
Status checkConfirms everyone is matched or flags a must-not-draw clash
MessagesReady 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:

  1. Enter every participant and any must-not-draw names.
  2. Run the draw (often by typing a draw number so you can retry if the status check flags a clash).
  3. Check status — everyone matched, or a clash that needs another draw number.
  4. The draw stays the same each time you open the file until you change the draw number or the names.
  5. 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

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.

NameMust not drawWish list (example)Notes
Example — AmeliaExample — GeorgeExample — nice mug, plantExample — partners
Example — GeorgeExample — AmeliaExample — socks, dark chocolateExample — partners
Example — Priya—Example — notebook, teaExample — remote; post by 10 Dec
Example — SamExample — JordanExample — board gameExample — 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

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

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

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.