Secret Santa Spreadsheet & Gift Exchange Organizer - Wish Lists, Do-Not-Pair Checks, Budget

Run your Secret Santa or gift exchange from one spreadsheet: wish lists, who should not be paired, a check on every pairing, ready-to-send messages and a gift budget tracker.

Why you will like it

- Draw names from a hat or assign them by hand, then let the sheet check every pairing for you

- Each row is checked for SELF, DUPLICATE, NOT A PARTICIPANT and EXCLUDED (a do-not-pair match, either direction)

- An 'All good?' check tells you when every giver has a receiver and nobody is left without a giver

- A ready-to-copy message for each giver: "Hi Avery, you are buying a gift for Casey", with the budget, date, wish list and things to avoid

- Gift Tracker shows OVER or OK against your budget limit

What's included

- 1 spreadsheet file (.xlsx), no macros, with 5 tabs:

- Start Here: quick how-to

- Event Details: exchange name, date, budget limit, location or online link, sign-up / gift deadline, exchange type dropdown (Secret Santa, White Elephant, Yankee Swap, Other) and organizer contact

- Participants: 50 rows for name, email, wish list, gift ideas, sizes, dislikes / allergies and two "Do not pair with" dropdowns

- Assignments: givers fill in from Participants, you pick each receiver from a dropdown; Check column, message column and a summary (rows OK, rows with a problem, givers with no receiver, people with no giver, All good?)

- Gift Tracker: Purchased / Wrapped / Delivered (Y/N), cost, budget limit, OVER/OK flag and totals

- 5 yellow example participants (fictional) to show how it works; delete them when you start

How it works

- Fill in Event Details and add everyone on Participants, including anyone they should not be paired with

- Draw names from a hat (or decide yourself) and choose each giver's receiver on Assignments

- Fix any row that is not OK until 'All good?' says YES

- Copy each message and send it privately to the giver

- Track gifts and costs on Gift Tracker

Compatibility

- Standard .xlsx for Microsoft Excel; open it in Google Sheets by uploading it to Google Drive

- Instant download after purchase

Who it's for

- Office, family and friends gift exchanges

- Organizers who need to keep partners or housemates from drawing each other

- Anyone running a Secret Santa, White Elephant or Yankee Swap

FAQ

- Does it draw names for me? No. You draw names from a hat or assign them yourself, and the sheet checks the pairings. Nothing reshuffles, so assignments stay exactly as you enter them.

- How many people? Up to 50 participants.

- Questions? Email hirelinetemplates@mail.grokbot.com

Planning holiday gifts too?

- Christmas Gift & Holiday Budget Tracker ($5): https://payhip.com/b/IjdQ6

- Holiday + 2027 Budget Pair ($10, save $3 vs $13 for the Christmas Gift & Holiday Budget Tracker $5 + 2027 Budget Planner $8 bought separately): https://payhip.com/b/vniJ9

Running a gift exchange? Get all 3 holiday planners (Secret Santa, card list, hosting) in the Holiday Planner Bundle for $9 ($11 separately): https://payhip.com/b/Mu7Oy

Shopping Black Friday or Cyber Monday? Plan it with the Black Friday & Cyber Monday Deal Planner ($3): https://payhip.com/b/ZlX4C