How to Make Your Wedding Guest List Excell Spreadsheet. Free Download

Congratulations! You’re engaged! I bet your head is spinning with all the people and plans you hope to include in your special day! It is time to start putting names to paper {or spreadsheet} and building your Wedding Guest List Excel Spreadsheet. How big will your wedding be? How expensive? All these answers and more are truly contingent on your Wedding Guest List, the headcount and the numbers involved. Did you know that the best way to control your budget is to control your Guest List? It is…

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!
If you do not yet have Microsoft Word or Microsoft Excel you can download them both from the Microsoft Website.

You can also buy a Microsoft Office Suite from Amazon!

Enroll in the FREE Excel Spreadsheet Mini-Series!

The popular download is now a FREE ECourse! Still totally free and you don’t even have to give your email anymore! I’ve put together a 5 Video Tutorial AND an Invitation 101 Slideshow together for you.

[CLICK HERE] to Enroll in the Mini-Series and download your FREE Spreadsheet

Wedding Guest List Excel Spreadsheet

PS- You can totally download and run, no pressure! But the videos are free 😉

Come back here and complete the first assignment once you’re in the Ecourse:

How to Make Your Wedding Guest List Excel Spreadsheet

In your first email, after subscribing to the 4 Email Mini-Series, click the link to the shareable file, and use the downward arrow icon to download it.  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 we’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 keying terms.

Our 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 ECourse Mini-Series}
  • C. Budget Breakdown- {In the ECourse Mini-Series}

Many of the cells are also locked, and un-editable 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.How to Make your Wedding Guest List Spreadsheet. Tutorial and Assignments


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

 How to Make your Wedding Guest List Spreadsheet. Tutorial and AssignmentsHow to Make your Wedding Guest List Spreadsheet. Tutorial and AssignmentsHow to Make your Wedding Guest List Spreadsheet. Tutorial and Assignments

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


Enroll in the FREE 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

Sound like assignments you might want to follow through with?



Join The GEG Team Experience!

Award-Winning Online Wedding Planning with Green-Eyed Girl Productions:

Join my FREE Facebook Group right now!

Hi there! I’m Kandice, Owner of Green-Eyed Girl Productions and engineer of The Project Block System. Thank you so much for stopping in on this blog post! Join hundreds of Bride who have worked through The Project Block System while planning their Wedding. Our Team Experience is now FREE to everyone planning a wedding during this chaotic and confusing time.

Watch the IGTV Videos for WHAT BRIDES ARE SAYING

Like what you read?

Follow us on | Facebook | Instagram  | Twitter | 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!

Start Planning your Wedding:

The I’m Engaged ECourse | Our famous FREE ECourse
Are you recently engaged? Congratulations, and you’re in the right spot! If you haven’t already, go enroll in our FREE I’m Engaged ECourse on Teachable. You’ll receive a 7-Day Action Plan, free downloads, and Introductory Wedding Planning Videos. Find it HERE.


The Project Block System | The GEG Trademark
Our Project Block System on Teachable is our unique way of organizing wedding set up that has clients hunting us down worldwide. ENROLL HERE.

 

 
 
Don’t forget to snag some of our best FREEBIES too! From Free Wedding Websites and Registries to cold, hard cash! Read all about our Top 10 Freebies.

**Affiliate Disclaimer**
We are proud to partner with many amazing Affiliate Programs including Amazon, and Many More. When you click on affiliate links and make a purchase we earn a commission. However, all of our opinions, reviews, and recommendations are our own. We would never send you in the wrong direction 😉

Comments! 

I do love responding to comments and questions below. If you have something to add please let me know and I’ll be sure to respond ASAP. Better yet, JOIN OUR FACEBOOK GROUP! I’m much faster at responding over there! 

Facebook Comments Box

16 thoughts on “How to Make Your Wedding Guest List Excel Spreadsheet”

    1. Hi Annie! You should be able to add as many rows as you need so long as you’re inserting them between Rows 3-5 which are un-protected. Does that make sense? If you want to email it to me I can share it back to you?

  1. Hi Kandice,

    I am also having troubles with the protected cells and it correctly counting how many invitations I need. Would you please also send me an unprotected copy?

    Thank you so much!! 🙂

  2. Hi Kandice,

    I was looking a couple of other list but I love your spreadsheet the most! Would it be possible to share an unprotected version?

  3. Hi Kandice, I am having trouble being able to change the text color of any of the green cells as well as adding additional rows between rows 3-5. Are you able to send me an unprotected version? Thanks so much!!

    1. Emailed you 🙂
      I am now uploading a completely unprotected version to the blog… the only reason it was protected was to prevent the formulas from being altared, so Team, just don’t change your formulas! 😉

  4. Maybe I missed it, but I can’t seem to find where you discuss the list column on the guest list. Can you elaborate on it please?

    1. Hi there! The list column is for when you have *too many* people on your list and you need to do the roll-out style of sending your invitations: The main choices will be marked A-List, then once you receive RSVPs that decline you can send out a B List. This method is discussed further in my main ECourse: The idea of not mailing out one massive set of invitations, but sending a few out at a time to prevent guests from having a “Her invites went out last week” and I didn’t get one experience. It also gives you the flexibility to be more graceful when people confront you about an invitation. You can respond, “They’re not all out yet” or “The guest list is a work in progress”
      Thank you for being here and I hope that helps!

  5. Hi Kandice,
    I can’t seem at access the link for the spreadsheet at all? I saw the previous comments, not sure if it has any effect that im on a mac ? are you able to email it through, apologies for any inconvenience, but I’m really keen to try it out! xx

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.