Guest List Spreadsheet

Re: Guest List Spreadsheet

• wittykitty14 member

  

  June 2013

  Having a spreadsheet will be REALLY helpful!

  I would just do it in excel.  It doesn't have any of the "fanciness" that TK or other wedding sites have, but it's kept everything neat and organized for me, and it's not glitchy.

  Report0 Reply
• misslobita member

  

  June 2013

  I created my own spreadsheet and organized it to my liking! This is what I included so I could double check that everyone got sent a STD and invitation:

  1. Names

  2 Number invited

  3. Number of invites to send

  4. Addresses

  5. Save the date

  6. Invitation

  7. yes/no to wedding

  8. number of guests coming.

   

  So 1-8 were on a horizontal line and then I set it up so rows 2,3,and 7 added up the total at the bottom so I quickly could see how many I invited, how many invites to send and how many said yes.

  Report2 Reply
• silver0319 member

  

  June 2013

  I also created my own, but in Google Drive. I shared it with FI and my mom so that they could enter addresses as they collected them from friends and relatives.

  

  Report2 Reply
• jennygru

  

  June 2013

  I also just did an excel spreadsheet, but put it on google drive to share easily with my fiance and parents, and for shower lists.
  

  Report0 Reply
• StPaul0102 member

  

  June 2013

  My fiance and I have been using this big wedding planning template we found on google docs that was designed by Style Me Pretty. We love using google docs for pretty much anything because we can both have access to them wherever we are. I think this is the link to the one we're using:
  
  https://drive.google.com/previewtemplate?id=0AhN0y99GtIFTdEc0ZzFkMU8tZmFTSVp3dmhhMlRycWc&mode=public
  

  
  

  If that link doesn't work you can just google "All-in-one Wedding Planner"

  Report0 Reply
• [Deleted User] member

  

  June 2013

  I'm using excel. - its been really easy to use so far, google docs is another one you can use!
  

  Report0 Reply
• nextrightthing member

  

  June 2013

  We are also using excel.  Our columns are something like - Title, name, address, children's names, number, STD sent?, invite sent?, Yes/No, etc.

  

  Report0 Reply
• dalywill member

  

  June 2013

  i agree - google drive excel is the way to go! i needed to do that b/c my MIL wanted to be able to add/delete addresses at will.  

  Report0 Reply
• JoanE2012 member

  

  June 2013

  I also used google drive spreadsheet and it worked out great.  Don't try to over complicate things....a basic spreadsheet is all you need.

  Report0 Reply
• ashleyep member

  

  June 2013

  sxyktn812 said:

  You can also add columns if you have people make their meal selections so it just totals out for you.  I would HIGHLY recommend saving new versions as updated files with a date in the name rather than overwriting.  This way you know precisely when it was updated and that you're looking at the most up to date version. 

  If you use Google Docs I think they do versioning for you! 

  

  Report0 Reply
• vineheart137 member

  

  June 2013

  sxyktn812 said:

  You can also add columns if you have people make their meal selections so it just totals out for you.  I would HIGHLY recommend saving new versions as updated files with a date in the name rather than overwriting.  This way you know precisely when it was updated and that you're looking at the most up to date version. 

  This is what we did (Well, hubby did, he loves spreadsheets and I'm pretty clueless when it comes to Excel formulas!) It worked out really well and once he created it all I had to do was plug in numbers and everything was totaled out for us.

  
  

  Report0 Reply