Wedding Planning Spreadsheet (Free Download) and How to Use It
Guides

Wedding Planning Spreadsheet (Free Download) and How to Use It

A wedding planning spreadsheet is the least romantic object in a wedding and the one that most decides whether the day feels calm. We have watched hundreds of couples plan, and the ones who arrive at the wedding rested are not the ones with the biggest budget or the best planner. They are the ones who, somewhere around month ten, put everything in one file and kept it current. This is that file. It is free, it is a plain CSV so it opens in Google Sheets, Excel, Numbers or anything else, and the rest of this post explains how each of the five tabs is meant to work and the small habits that keep it from becoming a graveyard of good intentions.

Download the wedding planning spreadsheet and open it in your spreadsheet app of choice. In Google Sheets, use File, Import, and choose "Replace spreadsheet." Then split the single sheet into tabs by the first column, or simply filter by it; both work.

Why a spreadsheet and not an app

Wedding apps are fine until a vendor asks for a number the app does not track, or until two people need to edit at once, or until you want to see the budget and the timeline on one screen. A spreadsheet does all of that and will still open in ten years when you want to remember what the flowers cost. It is also the format every planner and most vendors work in, so sharing is a link rather than an export.

Tab 1: Budget

Eleven lines, which is deliberately few. Most wedding budgets fail by being too detailed too early, with forty rows nobody updates. Start with categories, put a target number in each, and only split a category when you have a real quote to put against it.

The columns: budget (your target), actual (the contracted or final number), paid (what has left your account), status. Two formulas matter:

  • Remaining to pay = actual minus paid, per row and totaled. This is the number that tells you what the last two months will cost.
  • Variance = actual minus budget. Conditional formatting that turns it red over zero is the whole early-warning system.

The contingency line is 10 percent of the total and it is not optional. Something will cost more. In our experience the things that surprise couples most are alterations, vendor meals, overtime, and the gratuities nobody budgeted. The photography line, for context, usually sits between 10 and 15 percent of the total; our wedding photo styles guide explains what moves it within that range.

Tab 2: Timeline

The timeline tab is a checklist ordered by months out, with a due date and an owner for every line. The owner column is the one couples skip and the one that prevents the most arguments. Every row has a name in it, even if the name is the same on most rows.

A few of the dates are worth defending:

  • Photographer at 10 to 12 months. Good photographers book a year ahead for peak Saturdays. Our timeline guide explains what to settle with them once booked.
  • Invitations at 8 to 10 weeks, RSVP deadline at 3 to 4 weeks, final count to the caterer at 2 weeks. Those three dates are chained; move one and move all.
  • Hair and makeup at 6 months, with a trial 6 to 8 weeks out.
  • Marriage license according to your state. Utah's is valid for 32 days from issue; many states differ, and some require a waiting period.

Add rows freely. Delete the ones that do not apply. The goal is a list where, on any given Sunday, you can sort by due date and see the next three things.

Tab 3: Vendors

One row per vendor with contact, contract date, deposit paid, balance due date and the day-of contact person's cell number. The last column is the one that matters on the wedding day, and it is the one that is usually blank. Fill it the week you sign.

A habit that pays off: paste the key terms of each contract into the notes column in plain language. "Eight hours, second shooter included, overtime 400 per hour, gallery in six weeks." When the day runs long you will want that in one place, not in a PDF on someone's phone.

Tab 4: Guests

The guest tab is the one that gets the most use and the most abuse. Keep the columns the spreadsheet starts with: name, address, invited, RSVP, meal, table, gift, thank-you sent. Three rules:

  1. One row per invitation, not per person, until the RSVPs arrive. A couple is one row with "2" in the invited column. It keeps the count honest.
  2. Never delete a declined guest. Change RSVP to no. You will want the addresses for announcements and the record for the thank-you notes.
  3. Fill the gift and thank-you columns the day gifts arrive, not in a heap afterward. This is the single habit that gets the notes written.

A COUNTIF on the RSVP column gives the live headcount; a COUNTIF on the meal column gives the caterer their numbers; a SUMIF on invited minus a SUMIF on RSVP tells you who to chase.

Tab 5: Day-of

The day-of tab is a timeline of the wedding day itself with a time, a location and a note for each block. This is the tab you print and hand to the photographer, the coordinator and the maid of honor. It should fit on one page.

Build it backward from sunset. Find the sunset time for your date and venue, subtract 60 to 75 minutes, and that is the golden-hour portrait slot that most couples wish they had protected. Everything else fits around it. If there is a first look, it goes 3 to 4 hours before sunset, which is what makes a relaxed afternoon possible; the engagement photo poses post has a short version of why a first look also makes the portraits better.

Two blocks couples underestimate: family photos, which take about three minutes per grouping with a helper and ten without one, and travel, which in Utah can mean 45 minutes of canyon road between a temple and a reception.

The habits that keep it alive

  • One file, one link, shared with everyone who needs it. Not a copy each.
  • Sunday night, fifteen minutes: update paid amounts, tick the timeline, chase two RSVPs. That cadence is enough.
  • When a vendor quotes, the number goes into the actual column that day, before the email is closed.
  • Freeze the budget tab two weeks out. After that you are spending the contingency, and you should know it.
  • After the wedding, keep the file. The vendor tab becomes the list you recommend to friends, and the guest tab becomes the thank-you list.

The Knot's Real Weddings Study is the best public benchmark for what each category costs nationally if you want a sanity check on your budget tab before the first quote comes in.

A last note from the editors. A spreadsheet will not make your wedding beautiful. It will make the week before it quiet, which is the thing that shows in the photographs. Download it, fill in the first tab tonight, and let the rest come as the quotes do.