heidzillas how to: guest list

Here is one version of a guest list template that I have found to work.  Plug these bullets into Excel (along the top row):

  • RSVP #
  • List
  • Rooms
  • Invited
  • Accepted
  • Regrets
  • Abbr 1
  • First Name 1
  • Last Name 1
  • Meal Choice 1
  • Meal Choice 2
  • (Meal Choice 3…)
  • Abbr 2
  • First Name 2
  • Last Name 2
  • Meal Choice 1
  • Meal Choice 2
  • (Meal Choice 3…)
  • Address
  • City
  • State
  • Zip
  • Email 1
  • Email 2
  • Shower gift
  • Wedding gift 

Key to this template:

RSVP # - when you send your RSVPs, whether it be postcards or the cards in envelopes, number them all based on this list, lightly in pencil on the back or on the corner by your return address. You wouldn’t believe that people actually forget to write their name on them. I wouldn’t have believed it AT ALL until we got TWO that way. I was glad we numbered them, although the postage cancellation gave it away, too, although that was luck.

LIST – If you choose to do A/B lists… you can do that here. I like to use this space for an initial of whose family it is… If your name is Jane Doe and his is Bill Smith, put S for his family’s guests, and D for your family, and J for your work people  and friends, and B for his work people and friends. Then do a  U for “us” – people you’re mutually friends with. This helps with sorting and double checking. Especially when phone calls need to be made for the people who didn’t RSVP in the time they were asked to and you need to give the list to your mom or your fiance’s mom.

ROOMS – This is where you can guestimate who would book a room for your room block and then you can easily reserve that many. Once you’ve reserved, the hotels can usually share the list of the people who have booked rooms under your wedding code with you. You can clear your guesestimate from that column and then fill in who has booked. If you do welcome bags, you’re all set with how many you need and who’s booked if you want to write personalized name tags or notes.

INVITED – how many people were invited per this invitation (include the “and guest” count here, too!)
ACCEPTED - how many people are coming
REGRETS - how many people aren’t coming  (rocket science, right?)

 
ABBR 1 – Mr.’s only in this column!
First Name 1 - if your girlfriend gets “and guest”  write guest in this line until you get the RSVP with his name, or no guest at all. If it’s no guest, be sure to put that in your regrets line, or your invited to accepted/regrets count will not match up.
Last Name 1

 

Meal Choice 1 - Chicken? Beef? Vegetarian?…. Mark a 1 in this column if that’s what they ordered… a 0 if they didn’t 
Meal Choice 2 - If you’re doing buffet only, delete all these lines. 
Three choices? Add a column!:)

ABBR 2 - Mrs/Miss/Ms.  Keep all your ladies on the right hand side, even if you’re only inviting a lady with no gentleman. That way, when you need to export your list to whomever is throwing your shower and/or bachelorette parties, it’s all set and you don’t have to reformat. 

First Name 2
Last Name 2

Meal Choice 1
Meal Choice 2

Address
City
State - Stick with the two letter abbreviation here. Don’t know them? Click here. 
Zipcode - In Excel, be sure to format this column as a “zip code” or anyone with a zip code that starts with a 0 will look like they have a 4 digit zip code. Click Format > Cells > Special > Zip Code. You don’t want your Boston friends not getting your invite, now do you?

Email 1 – primary email of guests. Don’t necessarily need to fill these all in. (Do you really want to try to get the most up-to-date email address for all your guests? Does Great Aunt Lucy even have one?)  It’s nice to plug in your friends and bridal party if you have these handy, though, for shower and bachelor/ette party reasons. See note  after Mrs/Miss/Ms.

Email 2 - If there’s no primary email address, so you have one for each guest. Make 1 the boy’s and 2 the girls for easy sorting for the bachelor/bachelorette parties!

Shower gift - what this guest bought you if they came to your shower. Make sure your maid of honor writes this down when you’re opening gifts so you can write your thank you cards!

Wedding gift - I like these lines because then you have it saved for when your mom asks you who got you which thing… and for thank you card checking off. I also like  having the shower list handy when you’re writing your wedding thank you cards, because then you can refer to the shower gift again. Very thoughtful. These lines also help when in Excel for totaling up money so you can be sure you added it up correctly before depositing it in the bank, or for realizing how much you have in certain gift cards before you go to the store to get those items still left on your registry.

 

Other columns to consider along the way:

  • Phone numbers (especially for RSVP time)
  • Table number -  once you assign them, so it’s an easy reference and you can export your list of names plus table number for your calligrapher or designer.
  • Personal notes - Such as your mother in law mentioned that her sister Sally can’t stand your father in law’s Uncle Milton. Reference your notes pre-table assigning. Do you have friends or family members allergic to peanuts? What about with gluten allergies? Note these so you can alert your caterer and/or bakery.
  • Childrens’ names – I’ve only accounted for 2 people per invitation. You might have more lines and more meal selections. (You could also put them on the next row so your spreadsheet doesn’t get any wider… Remember to repeat the RSVP # on the left hand side.

by heidzilla

show hide 3 comments

Sarah - You and my fiance should meet. He’s excel obsessed.February 18, 2009 – 10:07 pm

klockerc - This post rocks! I will definitely be using this to update the lame list I have tried to put together myself :) Thanks Heidi!February 19, 2009 – 6:54 am

Kate - Seriously Heeds, your blog is so good that I regularly read it and I’m not even engaged or anything, lol. It’s just really interesting stuff. Kudos!February 24, 2009 – 7:58 pm

Your email is never published or shared. Required fields are marked *

*

*

There was an error submitting your comment. Please try again.

f a c e b o o k
t w i t t e r
f e e d b a c k