Guides Tools
The wedding planning spreadsheet, in four tabs, and when to stop using one
The spreadsheets that get abandoned are usually the ones with twelve tabs. Four tabs, a few dropdowns and five formulas cover a whole wedding, and it is easy to see when one of them has outgrown the sheet.
The short answer
A wedding planning spreadsheet needs four tabs: Guests, Budget, Payments and Checklist. Keep one row per thing, pick replies and statuses from a dropdown, and let five formulas do the counting. A spreadsheet works until the months when balances fall due and replies come in. If two of the four warning signs below apply to you, move those parts to something that reminds you.
The spreadsheets people sell and share tend to be large: a dashboard, a vendor directory, a seating tab, a honeymoon tab, a countdown. They look complete on the first day and go stale by the third month, because every tab is one more place to keep current. This guide goes the other way. It is the smallest spreadsheet that runs a whole wedding, with the exact columns and formulas, and an honest rule for when it has stopped working.
The formulas below are written for Google Sheets, where you can both edit the same file. The same formulas work in Excel.
Tab 1: Guests
One row per invited person, so a couple is two rows. A plus-one lives on their host's row, with a reply of their own, so every place is counted exactly once.
| Column | Header | What goes in it |
|---|---|---|
| A | Name | One person. A couple on one invitation is two rows |
| B | Group | Whose side, or family, friends, work |
| C | Reply | A dropdown: Pending, Attending, Declined |
| D | Plus-one reply | A dropdown: None, Pending, Attending, Declined |
| E | Dietary notes | As the guest wrote it |
| F | Table | A number, once you seat people |
| G | Thank-you sent | A checkbox |
Make the reply column a dropdown (Insert, then Dropdown, in Google Sheets). Typed replies drift into "yes", "Yes, both of us" and "coming", and a formula cannot count those.
Two formulas at the top of the sheet, or on a small summary tab:
- Confirmed people:
=COUNTIF(C:C,"Attending")+COUNTIF(D:D,"Attending") - Still waiting:
=COUNTIF(C:C,"Pending")+COUNTIF(D:D,"Pending")
Both count the guests and their plus-ones, so the confirmed number is the one to give the caterer.
Our free guest list template already has these columns, the dropdowns, and a name and a reply for each plus-one. Paste your names and it downloads filled in. When the list is too long, our guide to cutting a guest list has a fair method.
Free toolWedding guest list templatePaste your names and download a guest list for Excel or Google Sheets, already filled in.Make my guest listTab 2: Budget
One row per category, not per vendor. Three numbers each. Our wedding budget template fills these rows in for a $30,000 wedding and shows what to do when a quote comes in over.
| Column | Header | What goes in it |
|---|---|---|
| A | Category | Venue, Catering, Photography |
| B | Planned | What you set aside before any quote |
| C | Booked | The signed contract total, with tax and service charges |
| D | Paid | A formula, from the Payments tab |
First give three columns of the Payments tab a name (Data, then Named ranges): column B PayCategory, column C PayAmount and column E PayPaid. Then in D2, fill down: =SUMIFS(PayAmount,PayCategory,A2,PayPaid,TRUE)
That adds every payment on the Payments tab for this category that is ticked as paid, so you never type a paid amount twice. The names also keep the formula readable when you come back to it in six months. The gap that matters is Booked minus Planned: a positive number means that line needs money from somewhere else. Our guide to planning a wedding on a budget shows which lines to take it from.
Tab 3: Payments
This is the tab most spreadsheets leave out, and the one that matters most in the last months. One row per payment, not per vendor: a deposit and a balance are two rows.
| Column | Header | What goes in it |
|---|---|---|
| A | Vendor | The name on the contract |
| B | Category | Exactly as written on the Budget tab |
| C | Amount | The payment, not the contract total |
| D | Due | A real date, not "a month before" |
| E | Paid | A checkbox |
One formula tells you what is coming: due in the next 30 days and not yet paid.
=SUMIFS(C:C,E:E,FALSE,D:D,"<="&(TODAY()+30))
Here is what it shows for a wedding on 25 September 2027, opened on 15 August:
| Vendor | Category | Amount | Due | Paid |
|---|---|---|---|---|
| The venue | Venue | $3,000 | 15 Jan 2027 | Yes |
| The venue | Venue | $7,400 | 1 Sep 2027 | |
| The photographer | Photography | $900 | 1 Feb 2027 | Yes |
| The photographer | Photography | $1,900 | 25 Aug 2027 | |
| The caterer | Catering | $2,000 | 1 Mar 2027 | Yes |
| The caterer | Catering | $5,000 | 10 Sep 2027 |
The formula returns $14,300: three balances inside 16 days, more than twice the $5,900 paid since January. This is normal. Deposits are spread out and balances bunch up just before the wedding. Our guide to paying wedding vendors explains why, and when each vendor usually wants its money.
The spreadsheet only shows you this if one of you opens it. Keep that in mind for the warning signs below.
Tab 4: Checklist
| Column | Header | What goes in it |
|---|---|---|
| A | Task | Book the photographer |
| B | Due | A date |
| C | Owner | One of your names. Never "both" |
| D | Done | A checkbox |
Open tasks for one of you: =COUNTIFS(C:C,"Sam",D:D,FALSE)
The owner column is what keeps a shared checklist moving. A task that belongs to both of you tends to belong to neither. Our guide to planning a wedding together has a way to split the work so each of you owns whole areas, not scattered tasks. For the tasks themselves and when each is due, start from the wedding planning checklist.
Four rules that keep it true
- One owner per tab. Either of you can read everything, but one person keeps each tab current.
- Dates as dates. A date typed as text, such as "early June", cannot be sorted or counted by a formula.
- Dropdowns and checkboxes wherever there is a fixed set of answers. Formulas only count what they can match.
- Share it with edit rights, so there is one file. Two copies emailed back and forth will disagree within a week.
When to stop using one
A spreadsheet is a fine way to plan a wedding, and plenty of couples use one to the end. It stops working in predictable ways. Look at these four signs:
- A payment or a deadline was nearly missed because nobody opened the file. A spreadsheet never reminds you.
- One of you plans on a phone. A seven-column sheet on a phone screen is slow to edit, so it gets edited less.
- Replies are arriving. Every reply means opening the sheet, finding the row and changing the dropdown, often several times a day for a few weeks.
- The same guest is being typed in two places, such as the guest list and a seating plan.
The rule: if two or more apply, move those parts to something that reminds you and keeps the pieces connected, and keep the spreadsheet as your record. If none apply and one of you enjoys keeping it, stay. Our comparison of wedding planning apps covers the options, including a spreadsheet, honestly.
Yes, I Do
Every guest, every reply
Paste a list from anywhere and it becomes names. Replies, plus-ones, dietary notes and tables stay in one place, for both of you.
Moving over without starting again
Nothing in your spreadsheet needs retyping. In Yes, I Do you can paste names straight from a spreadsheet, a note or a chat, and they become guests, sorted by side and with their plus-ones, for you to review before adding. The budget does what the Budget and Payments tabs do: photograph a quote and the amounts and due dates are filled in, and with payment reminders on, you get a notice 7 days and 1 day before each payment is due. Your partner sees and changes the same plan on their own phone.
When the venue asks for final numbers, the guest packet sends a PDF or a CSV with seats, plus-ones, sides, dietary notes and tables, so the caterer still gets a spreadsheet. After the wedding, the thank-you list tracks each gift and whether its note is sent.
Questions
How do I make a wedding planner in Excel or Google Sheets?
Make four tabs: Guests, Budget, Payments and Checklist. Give each one row per item, use dropdowns for replies and checkboxes for paid and done, and add COUNTIF and SUMIFS formulas to count replies and add up payments. The columns and exact formulas are above.
What tabs should a wedding planning spreadsheet have?
Four cover everything: Guests, Budget, Payments and Checklist. Payments is the one most templates leave out, and it matters most, because deposits and balances fall due on different dates. Extra tabs for vendors or a dashboard are optional and are the first to go out of date.
Is a spreadsheet or an app better for wedding planning?
A spreadsheet is free and flexible and works well if one of you enjoys keeping it. An app is better once you need reminders for payments, replies are arriving and both of you plan on your phones. If two of those apply, the app will save you time.
What is the 50/30/20 rule for weddings?
A starting split for the budget tab: about 50 percent for the venue, food and drink, 30 percent for photography, attire, music and flowers, and 20 percent for everything else and surprises. It is a sanity check, not a rule. Our guide to the average wedding cost shows how real budgets split.
What is the 30-5 rule for weddings?
It is a rule of thumb for the schedule on the day, not for the spreadsheet: allow a 30-minute buffer around the big fixed moments and 5 minutes for every move between places. Our wedding day timeline guide shows how to apply it.
Sources
- Google Docs Editors Help: COUNTIF, for the syntax used to count replies.
- Google Docs Editors Help: SUMIFS, for the syntax used to add up payments.
- Google Docs Editors Help: name a range of cells, for linking the Budget and Payments tabs.
- Google Docs Editors Help: create an in-cell dropdown list, for making reply columns dropdowns.
- Google Docs Editors Help: add and use checkboxes, for the paid and done columns.