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)

Spreadsheet vs checklist guide vs free tools

ToolWhat it doesUse it when
Checklist guideMethod: 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 calculatorsLive 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 guideWhat 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):

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.

ColumnWhat goes in it
Child / guest nameWho is invited
Parent contactName and phone or email for RSVPs and day-of messages
Invite sentYes / No, and optional date or method (card, class chat, text)
RSVPYes / No / Awaiting
ChildrenHow many children from that family are coming (including siblings)
AdultsHow many adults will stay
AllergiesDietary needs and allergens noted by the parent
Gift receivedTick when a present arrives
Thank-you sentTick 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

ColumnWhat goes in it
ItemHall 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 dateDD/MM/YYYY for deposits and balances
NotesSupplier 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

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.

ColumnWhat goes in it
SegmentArrival & free play, games / entertainer, food, cake, final game, party bags / collection
Duration (minutes)How long you plan for that segment
Start timeFirst row = door open; later rows = previous start + previous duration
OwnerWho runs that segment
NotesMusic 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.

ChildParentRSVPChildrenAdultsAllergies
Example — MayaExample — Sam (07…)Yes11Example — none noted
Example — LeoExample — PriyaAwaiting———
Example — Noah + siblingExample — JordanYes20Example — 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

Kids birthday vs baby shower vs christening

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)

DIY sheet vs ready template

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.