Kids party planner spreadsheet UK: Excel and Google Sheets template columns
A kids party planner spreadsheet (template, Excel or Google Sheets — search boxes use all those words) keeps the guest list, budget, countdown to-dos and on-the-day running order in one file you reopen until the party is over. This guide shows practical columns that match a typical UK children's birthday, baby shower or christening, how the spreadsheet differs from our checklist method guide and free calculators, and how to build it yourself or use a ready template. It is a planning method, not legal, tax or financial advice. For the planning timeline, food quantities and allergen detail, start with the kids birthday party checklist UK.
What this guide is (and is not)
- Is: the spreadsheet / planner / template method for a kids' birthday, baby shower or christening — columns for guest list (children and adults), budget with paid/unpaid, countdown to-dos and a timed running order.
- Is not: the checklist and method walk-through (kids birthday party checklist UK: timeline, food quantities, allergies, party bags, hall questions). It is also not the free live tools for food or drinks totals.
- Product honesty: the Party Planner: Kids' Birthdays & Baby Showers (£4.50) is a ready planner for guest list, budget, to-dos and running order. Allergen and food-safety detail stays on the checklist guide (FSA / NHS pointers already checked there). The free calculators need no purchase.
Spreadsheet vs checklist guide vs free tools
| Tool | What it does | Use it when |
|---|---|---|
| Checklist guide | Method: timeline, budget lines, food quantities, allergies, party bags, hall hire questions, baby shower notes. | You need the decisions and the order of jobs |
| Catering / drinks calculators | Live totals for adult finger-buffet items or alcohol; nothing is stored. | You want a quick quantity check for parents who stay (start lower for children) |
| Hall hire guide | What to check on a village-hall or community-centre quote. | You are comparing halls before you book |
| Planner spreadsheet (this page) | Reusable Excel or Sheets file: guest list, budget, countdown to-dos and running order you update as RSVPs arrive. | You want one household source of truth until the party ends |
A simple flow: plan with the kids birthday party checklist, compare halls with the hall hire cost UK guide, check food and drinks with the free catering quantity calculator and party drinks calculator, then keep the live numbers in the spreadsheet.
Overview dashboard columns
Put a one-glance summary at the top of the file (or on a Start Here sheet):
- Days to go — counted from today's date to the party date
- Children coming and adults coming — summed from RSVP yes rows
- Awaiting reply — invites with no RSVP yet
- Budget left — total budget minus paid so far
- Party bags needed — children coming plus one or two spares
- Diets and allergies — count of guests with a note recorded
- Jobs done — to-dos marked complete vs still open
Guest list columns (children and adults)
One row per invited child (or per adult guest for a baby shower). Parent contact is the key field for children's parties.
| Column | What goes in it |
|---|---|
| Child / guest name | Who is invited |
| Parent contact | Name and phone or email for RSVPs and day-of messages |
| Invite sent | Yes / No, and optional date or method (card, class chat, text) |
| RSVP | Yes / No / Awaiting |
| Children | How many children from that family are coming (including siblings) |
| Adults | How many adults will stay |
| Allergies | Dietary needs and allergens noted by the parent |
| Gift received | Tick when a present arrives |
| Thank-you sent | Tick after the note or message goes out |
Sum Children and Adults only on RSVP = Yes rows for final numbers. Keep allergy detail on the list; for how to handle food safely at the party, use the checklist guide rather than inventing rules here.
Budget columns with paid / unpaid tracking
| Column | What goes in it |
|---|---|
| Item | Hall hire, entertainer, cake, food, drinks, decorations, party bags, and so on |
| Budget (£) | What you planned to spend on that line |
| Actual (£) | What the quote or receipt says |
| Paid (£) | What you have already paid |
| Unpaid / still owed (£) | Actual minus paid |
| Due date | DD/MM/YYYY for deposits and balances |
| Notes | Supplier name, invoice number, "deposit refundable until…" |
There is no "normal" kids-party total — cost each line from your own quotes. The checklist guide lists the budget lines to cost; this sheet is where you track them.
To-do list counted back from the party date
- Task — what to do
- Due date — worked back from the party (for example invite send, cake order, food shop)
- Owner — who is responsible
- Done? — Yes / No
- Status — optional: overdue when due date is before today and Done is No (conditional formatting turns the row red in Excel or Sheets)
A simple overdue flag: =IF(AND(Done="No",Due<TODAY()),"Overdue","") (adjust cell names to match your sheet).
On-the-day running order (times that update)
One row per segment of the party. Keep start times linked so a late arrival shifts the rest.
| Column | What goes in it |
|---|---|
| Segment | Arrival & free play, games / entertainer, food, cake, final game, party bags / collection |
| Duration (minutes) | How long you plan for that segment |
| Start time | First row = door open; later rows = previous start + previous duration |
| Owner | Who runs that segment |
| Notes | Music cue, allergen reminder, gift-list clipboard by the door |
In Sheets or Excel, if start is in column C and duration (minutes) in B, row 3 can use =C2+TIME(0,B2,0) so changing the first start time updates the rest.
Illustrative sample rows (made-up)
The rows below are made-up examples to show the layout. They are not typical guest lists, budgets or recommended timings.
| Child | Parent | RSVP | Children | Adults | Allergies |
|---|---|---|---|---|---|
| Example — Maya | Example — Sam (07…) | Yes | 1 | 1 | Example — none noted |
| Example — Leo | Example — Priya | Awaiting | — | — | — |
| Example — Noah + sibling | Example — Jordan | Yes | 2 | 0 | Example — egg (parent staying) |
Made-up budget examples: Hall hire · Budget £90 · Actual £90 · Paid £30 · Still owed £60 · Due 01/11/2026; Cake · Budget £25 · Actual £28 · Paid £28 · Still owed £0.
Made-up running-order examples: Arrival 14:00 · 20 min; Games 14:20 · 40 min; Food 15:00 · 30 min; Cake 15:30 · 15 min; Bags at door 15:45.
Excel vs Google Sheets how-to
- Google Sheets is easier if two parents update RSVPs from their phones.
- Excel (2016 or later / Microsoft 365) suits one person offline.
- An .xlsx file opens in both: upload to Google Drive and use File › Save as Google Sheets.
- Useful formulas:
SUMIFfor children/adults on Yes RSVPs;COUNTIFfor awaiting replies;TODAY()for days to go and overdue flags;TIME/ duration addition for the running order.
Kids birthday vs baby shower vs christening
- Kids birthday: guest list is children + parent contacts; count adults who stay for food; party bags and a timed running order matter most.
- Baby shower: guest list is mostly adults; track dietary needs, who is paying which budget line, and gifts/thank-yous for the parent-to-be.
- Christening / naming: same guest-list and budget bones; running order may follow a service or blessing time rather than games. Adapt segment names; do not invent religious requirements here — check with your venue or place of worship.
The same file structure works for all three; rename sheets and segments to match the event.
Food, drinks and hall hire (link out, do not restate)
- Food quantities and allergens: method on the kids birthday party checklist UK; live adult totals on the catering quantity calculator.
- Drinks: squash, juice and water for children; tea and coffee for parents. Use the party drinks calculator only if adults are having alcohol.
- Hall hire: questions to ask and how to read a quote on the hall hire cost UK guide.
DIY sheet vs ready template
- DIY: create the columns above in a blank spreadsheet. Costs nothing except your time.
- Ready kids party planner: the Party Planner: Kids' Birthdays & Baby Showers (£4.50) if you want overview, guest list, budget, countdown to-dos and running order already laid out.
- Supplier payments: the Event Supplier & Payment Tracker (£4.50) when several deposits and balances need tracking.
- Venue viewing: free FREE Venue Viewing Checklist (Lite), UK Wedding & Event Venues (£0) or Venue Comparison Scorecard & Viewing Checklist (£2.99) when you are comparing halls in person.
More: kids birthday party checklist UK · hall hire cost UK · catering quantity calculator · party drinks calculator · venue hire cost comparison · party venues directory
Free tools for this
Frequently asked questions
What columns should a kids party planner spreadsheet have?
An overview (days to go, children and adults coming, awaiting reply, budget left, party bags, diets, jobs done), a guest list with parent contact, invite sent, RSVP, children, adults, allergies, gift received and thank-you sent, a budget with paid and unpaid amounts, a to-do list counted back from the party date, and an on-the-day running order with start times and durations.
Is there a kids party planner template for Excel or Google Sheets?
Yes. You can build the columns in this guide yourself, or use our Party Planner: Kids' Birthdays & Baby Showers — an Excel and Google Sheets template with overview, guest list, budget, countdown to-dos and running order, in £ with UK dates.
What is the difference between a kids party planner spreadsheet and the checklist guide?
The checklist guide is the planning method (timeline, food, allergies, party bags, hall questions). The spreadsheet is the working file you update as RSVPs and payments arrive. Use the checklist first, then the spreadsheet.
How do I make a kids birthday party planner in Google Sheets?
Copy the guest-list, budget, to-do and running-order columns into a blank Google Sheet, use SUMIF/COUNTIF for RSVP totals, TODAY() for days to go and overdue flags, and duration addition for start times. An .xlsx template can be uploaded to Drive and saved as Google Sheets.
How do I track kids party guests and RSVPs in a spreadsheet?
One row per child with parent contact, invite sent, RSVP, children count, adults count and allergies. Sum children and adults only on Yes replies for final food and hall numbers.
Can I use the same planner for a baby shower or christening?
Yes. Keep the same sheets and rename segments: baby showers are mostly adult guests with gift tracking; christenings often follow a service time. Adapt labels — do not invent religious requirements in the file.
Can I make a free kids party planner spreadsheet?
Yes. Copy the columns and formulas from this guide into a blank Excel or Google Sheets file. Pair it with the free kids birthday party checklist UK for the method, and the free catering and party drinks calculators for quantity checks.
Is the Party Planner legal, tax or financial advice?
No. It is a fill-in Excel and Google Sheets planning template that tracks what you enter. This guide is not legal, tax or financial advice either.
Written with AI assistance and checked against GOV.UK guidance. General information, not financial, tax or legal advice.