How to plan a wedding in Excel or Google Sheets

Updated 2026-10-17 · Planners and templates · by CyberMax

Short answer

Use four tabs: Budget (category, estimate, actual, paid), Guests (name, party size, invited, RSVP, meal), Vendors (contact, deposit, balance, due date) and Timeline (task, due, done). COUNTIF and SUMIF give live RSVP totals, meal counts and money still to pay.

Copy-paste code

Live totals

Guests coming:      =SUMIF(Guests!E:E, "Yes", Guests!B:B)        (B = party size, E = RSVP)
No reply yet:       =COUNTIFS(Guests!A2:A1000, "<>", Guests!E2:E1000, "")
Meals (chicken):    =SUMIFS(Guests!B:B, Guests!E:E, "Yes", Guests!F:F, "Chicken")
Still to pay:       =SUM(Vendors!D:D) - SUM(Vendors!E:E)
Over budget by:     =SUM(Budget!C:C) - SUM(Budget!B:B)
Next payment due:   =MINIFS(Vendors!F:F, Vendors!G:G, "<>Paid")

Good to know

Set the budget split first (venue and catering usually take the biggest share), then plan the guest list to fit it, not the other way round.

Wedwren Wedding Planner: Plan the whole wedding in one calm spreadsheet

from $14

Wedwren is a calm, ready wedding planner spreadsheet: budget, guests, RSVPs and seating in one file for Excel and Google Sheets.

Get Wedwren Wedding Planner: $14 See what's inside Free preview (PDF)

Secure checkout · 14-day fix-or-refund if it doesn't work as described (terms)

Questions

Excel or Google Sheets?

Sheets is easier to share with a partner and family; both work.

How early should vendors be booked?

Venues and photographers are often booked first; check local availability.

Free: the Free Planner Sampler

4 printable previews (budget, debt payoff, focus planner, habit tracker), then 5 short emails with formulas that make a budget stick.