Welcome to the Guest List Excel Spreadsheet Mini Series!

A lot has changed in the last 6 years. First, we’re obviously no longer over on Teachable. I had to leave that platform as the fees nearly tripled to host ecourses. {sad face} Second, this Spreadsheet is also no longer free. Having left Teachable, I had to redo my entire business plan. Thank you for your understanding and I hope you can enjoy it and benefit so, so much!

Go Download your Spreadsheet on Etsy.

****** Original Post Continued *******

We recommend you make your Guest List in an Excel Spreadsheet. With the ability to sort and calculate there really is no better method. In fact, we prefer it so much, we’re going to give you a FREE one and walk you through building it!

You can also buy a Microsoft Office Suite from Amazon!

Follow the Excel Spreadsheet Mini-Series!

The popular download is now Blog Mini-Series on YouTube! The videos are free to watch, and you can purchase the spreadsheet template over on Etsy. I’ve put together a five-video tutorial that you can follow from this blog. 

PS- You can totally download and run, no pressure! Come back here and complete the first assignment once you’re in the Series:

How to Make Your Wedding Guest List Excel Spreadsheet

Purchase the spreadsheet on Etsy, download it, then come back here to follow through with the video series. It should then open as a Microsoft Excel Spreadsheet on your computer. If you are a MAC user… well, find a PC or a comparable version for MAC, but I don’t think our equations will still work.

When you open it you will see three Sheets. Now, this looks very confusing at first, but I’ll walk you through it and you’ll be organized in no time! If you have no experience with Microsoft Excel, you will want to have a one-on-one walk-through to understand the key terms.

My spreadsheet has a lot of correlating links that already connect the 3 Sheets:

• A. Your Guestlist- Getting Started {HERE in this post}
• B. Estimated/Actual Expenses- {In the Mini-Series}
• C. Budget Breakdown- {In the Mini-Series}

Many of the cells are also locked and uneditable to you for the integrity of the formulas. If for some reason you need to edit a cell, simply send me an email and I’ll help you through it.

Assignment 1A: Getting Started

On Sheet 1, replace everything that we have coded in GREEN with your own personal information. Insert as many rows as you need to allow for all your guests. Once you have replaced the sample information with your own, highlight the cell and turn the text color to black.

Guest Names

Start on Sheet 1. Enter all of your potential guests, everyone you would ever hope to invite if you had an infinite budget, {some will be put on the B-list in case A-listers decline} using this format of the columns:

• RSVP Tracking # {leave alone for now}
• Last Name
• First Name(s)
• Guest Name in this format, “& John Smith” it will be important for the label mail merge when we do invitations
• Mailing Address
• City, State
• Zip Code
• How many people are invited per this row
• How many people have RSVPed per this row
• Wedding Side: Bride or Groom
• Relation to the couple: Family, Friends, Work, etc Make them precise
• Kids- if this party includes any children under 10 years old
  1. All kids must already be included in the Column G count!
• List- Which List for priority invite this guest is on: A, B, C or D {we’ll cover all of this more later}
• SENT- is a column dedicated to you checking their invitation off after it’s been mailed
• Bridal Shower Invites- You can use this same list to mail merge your Bridal Shower invitations

Bonus Read | How to Mail Merge your Guest List & Why You Should

---

Follow the Mini-Series to find these Assignments and Tutorials too:

• Bookkeeping on Sheet 2 and other purchases all your fun Project Block Ingredients = Assignment 2
• Tracking your RSVPs and saving some money = Assignment 3
• Addressing your Invitations “Properly” by combing through prefixes, guests, children and how to address outer envelopes = Assignment 4

Guest List Spreadsheet | Assignment 2

Guest List Spreadsheet | Assignment 3

Guest List Spreadsheet | Assignment 4

Like what you read?

Follow us on | Facebook | Instagram  | Pinterest  | Etsy

For more Wedding Inspirations, How-To Articles, Vendor Advice and DIY Projects join our Inspired Coordination Newsletter by subscribing below. You’ll get informational posts just like this in your inbox on Wedding Wednesdays. PLUS! I’ll email you a FREE Checklist!

---

Hi there! I’m Kandice, Owner of Green-Eyed Girl Productions and engineer of The Project Block System. An Award-Winning Online ECourse Series across this Blog. Thank you so much for stopping in!

This Post is a part of The Project Block System ECourse. Join thousands of Brides who have worked through this 40-Week Experience while planning their Wedding.

Start your FREE Experience RIGHT NOW and download the Team Action Plan | Weeks 0-2:

Or Launch your Experience with The Project Block System TODAY, at Week 0: Planning Week

Watch the IGTV Videos for WHAT BRIDES ARE SAYING

Like what you read?

Follow us on | Facebook | Instagram  | Pinterest  | Etsy

For more Wedding Inspirations, How-To Articles, Vendor Advice and DIY Projects join our Inspired Coordination Newsletter by subscribing below. You’ll get informational posts just like this in your inbox on Wedding Wednesdays. PLUS! I’ll email you a FREE Checklist!