The Plunge's Badass Guest List Spreadsheet

You will have a guest list. You will need a spreadsheet for organizing said guest list. Want the best one in the business? You're welcome.

Convincing The Groom

Earlier in our discussion of your role in the wedding, we suggested that you doze off when you can, fake it when you can, and only chime in when it really matters.

This is one of those times.

If you haven't already done so, read up on the guest list tug of war. You should now be familiar with the "rule of thirds," the battles over who's invited, and the importance of chunking the list into Her Parents, Your Parents, and your own friends.

Maybe your fiancée is completely on top of this junk, and maybe she's already created a spreadsheet that has everything you need. Then again, maybe not.

(It's also possible, frankly, that she'll find The Plunge's spreadsheet more useful and comprehensive than the standard-issue ones for brides.)

GuestList_SS_body_350x300The spreadsheet is below--just click on the link.

Some things to keep in mind:

1) This is not a kindergarten spreadsheet. We're not effing around. It's easy to use, but it requires a little savvy. If you're lost, no sweat, we created a Help Screen (on second tab) to guide you.

2) Especially if you're not an Excel wiz, hover your mouse over the little red triangles--this will show the pop-up comments.

3) When you first open the spreadsheet, you might wonder, WTF, where's the stuff like "address," "zip," and all that horseshit? Click on the little "plusses" - way up top of the sheet - to expand some hidden columns.

4) Feel free to hack it, change it, make it your own. The founder of The Plunge used this system for his wedding and it worked like a charm, but you might have some additional tricks to throw in there. Go for it.

5) Once you've got a bunch of people in there--like over 50 or 60, say--it will be helpful to filter and sort the data. That's what the "auto-filters" are for - the little gray arrows in the title of each column. For instance, you can filter for only "Her Parents," or you can sort by people who have given you gifts. It's handy.

The_Plunges_Badass_Guest_List_Spreadsheet.xls

Good luck.

And if you have any questions about the spreadsheet that the Help Screen doesn't answer, drop us a line at Drowning@ThePlunge.com.

Need some more tools, checklists, and spreadsheets? Get the motherload here.

Follow The Plunge on Twitter: http://twitter.com/ThePlunge_com

Send
Print
Share
 

 

Comments (6)

...

Here is a spreadsheet for a guest list that is a little more better
Monica Barrientos, August 30, 2009
 

Paulette & James

Guest List
Diann Utley, November 12, 2009
 

...

guest list
Diann Utley, November 12, 2009
 

wedding guest list

need to get help with planning my wedding
tina, March 03, 2010
 

YOU GUYS ROCK

So it's three in the morning I got engaged this weekend and I have already been asked to pound out a head count, a location, and a date. I'm mostly cool with this because her folks are paying for it ( one of the most pleasant surprises of my adult life). Anyway crusin around your site avoiding sleep and sorting of the tenitive head count my fiance and I just pushed through and what do I find the spread sheet I was about to build from scratch myself already built for me THANKS GUYS
Erick L, March 09, 2010
 

RSVPs not adding up

I've had a very successful time with the guest list. Now theRSVPs have begun coming in, and the total doesn't seem to be working! It is easy to see this early on that 14 have responded that are coming, but the table only says 10. What could be wrong?
RK, July 09, 2010
 
smaller | bigger
 Subscribe via email (registered users only)

security image
Write the displayed characters

Submit

busy  
 
Join The Plunge
Unlike a certain someone, we're not asking for a
lifelong commitment. This can stay casual.
Join us and get:
  • Access to the Community
  • To-do reminders (less lame than it sounds)
  • Antidotes to your bride's wedding-porn
Join The Plunge
Join The Plunge
Unlike a certain someone, we're not asking for a
lifelong commitment. This can stay casual.
Join us and get:
  • Access to the Community
  • To-do reminders (less lame than it sounds)
  • Antidotes to your bride's wedding-porn
Join The Plunge

Know someone getting married? Throw 'em a bone.

Tell a Friend
 
busyLoading Poll...