- Hatfield Florist
How to use the Editable Wedding Planning Spreadsheet Template
Updated: Jul 7, 2021
First of all - Congratulations on your engagement!
Second - This is an exciting time. As you go through the process of planning your wedding, remember that at the end of the day what's most important is that you and your fiance are MARRIED. Then you have the rest of your lives to work on your marriage. Your wedding is one day. But yes, it can be really fun and amazing day :)
Third - So how do you use this Wedding Planner Spreadsheet Template?
If you haven’t gotten your free copy of this editable Wedding Planner Template spreadsheet, go ahead and grab that for your self here.
Now, the main point is that this template isn't meant to be a comprehensive checklist of everything you need to do. You probably already have so many of those lists. And because you are unique, you probably also have things you need to do for you wedding that no one else has to do.
This editable template is meant to be a place where you can compile all those tasks that you have to do, along with any other random information that you need a place to put it.
When you enter your email to access the Google Sheet, you will then receive an email with a link to access. Once you click the link, you'll see a new tab open. You may need to first create a Google account. If you are already signed in to your Google account, you'll see this screen:
Click the blue "Make a copy" button. This will then open up the Google Sheet as a new file in your own Google Drive account, so that you can edit it.
If you're really a beginner to spreadsheets or Google Sheets, you can watch some Google Sheet tutorials, such as this one, to help you out.
These are tabs (like tabs in your internet browser, they are part of the same document but allow you to have different information in each of them)
The tabs we've already made for you:
HOW TO USE: In this tab we explain how to save a copy to your own Google Drive. You don’t really need this tab after that, so you can delete it if you want to. Just be sure to bookmark this How-To blog post!
Checklist: This is where you’ll keep your tasks that need to get done.
Budget: This is where you can keep track of your budget and actual costs.
Vendors: A place to list all the options for all your vendors, in one simple list
Registry Planning: Use this sheet to compile both people’s preferences on items, then make a final selection.
Seating Chart: You can use this to help make your seating arrangements
Drop Downs: Here is where we keep the options for the drop-down choices in some of the tabs (you might have to scroll over to see this tab, just use the arrows next to "Seating Chart" tab.
This is what this tab looks like:
You can overwrite anything in these cells simply by clicking on a cell and then typing. When you’re done typing, just hit enter.
Start by entering your wedding date (overwrite where it says, “11/14/2020”)
Then BAM. The Days until the BIG Day automatically changes!
That’s because it’s a formula that automatically calculates how many days from today until the wedding day. No need to change the “Today” date!
Mostly, you’ll be editing the “Tasks”, the “Start in Month”, “Due Date” and “Notes”
In the “Category”, “Who does it” and “Status” columns, you can simply click in the cell and then select from the drop down.
But what if you want to change those drop down options?
Select the “Drop Downs” tab (all the way on the right in the tab selector bar)
Then find the one you want to change and simply overwrite. You can also add more below what’s already there. The idea is that whatever is underneath the word “Category” will be a drop-down option for the “Category” column. Same goes for “Who does it” and “Status”. (We recommend keeping the options listed in “Status” because they are color coded with conditional formatting, but if you want to change, you can!)
In the Budget sheet, you have a tool to help plan your budget up front and then track along the way.
First, enter in your total desire budget. Then you start working in the grid.
There are 3 columns.
Budgeting - this is your ideal amount you want to spend. You set this in the beginning.
Estimated - this is what you fill in as you start selecting vendors and options.
Actual - this is what you actually write the check for.
Each Category could be an area of the wedding such as ceremony, food, dresses, entertainment, printed items, etc. Then you can list out the specific items in each category (ie in “printed items” you might have Save the Dates, Invitations, Programs, Menus, Escort Cards, Thank You Cards, etc).
The top line for each category will automatically add up the individual items below it, as will the top pink line. So you can easily see how things start adding up.
In the Vendors tab you can keep track of all the options for vendors that you start collecting. You could separate these out to each type of vendor in its own tab, but that may give you too many tabs. It's up to you to decide what is best for you!
PRO TIP: Use the filters in the top pink row to filter (so you can see only one type) or sort (so you can see all the options together).
In this tab, you can track both partners’ preferences for items on the registry. That way, you can easily compare and review. Once you come to a final decision, place that link in the final column and then add it to your registry!
Seating Chart Template
The grids in this tab are set up for 21 tables of 10, but of course you can use less or add more.
Simply overwrite the “Person1” “Person2” with the name of the guest. Then mark their entree preference (if necessary) and any other notes (such as allergies).