Guest List Spreadsheet

futuremartin2015

I'm trying to start my guest list with my fiance, but I'm having trouble finding a good spreadsheet to use. I think using a spreadsheet will be best to keep my head straight and I was wondering if anyone had found one that they absolutely loved. Any advice is appreciated! Thank you!

wittykitty14

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.

misslobita

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.

silver0319

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.

jennygru

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.

StPaul0102

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"

[Deleted User]

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

nextrightthing

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

dalywill

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.  

JoanE2012

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.

ashleyep

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! 

vineheart137

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.