Tracking RSVP Responses With Google Sheets

You can keep track of your RSVP responses the old fashioned way, with a pencil and paper, or you can use this simple spreadsheet I created.

All this requires is that you type in the names of the groups you invited and how many people are in each group (see screenshot below)

As you get RSVPs back, simply input whether the response is a yes or a no. You’ll also have to put in the food choices. When you put the food choices in, make sure separate them with a comma and a space if there is more than one so that the sheet can accurately track the food choices (again, see the screenshot above).


If you’ve heard everything you need to hear and are ready to make this sheet your own you can CLICK HERE.

To make this sheet your own click File and then click Make a Copy. You can then go and add your own names. Just don’t touch the grey boxes on the right side or you risk messing up the formulas.


If you’re like me and you’re a giant nerd, you may want to know everything that’s happening in that spreadsheet. If so, read on!

The most basic thing going on here is conditional formatting:

  • When somebody is marked as not coming the sheet will automatically grey out the entire row except for the name.

  • When somebody is marked as attending but you have not entered their food choice, that box will become bright yellow as a reminder to enter their food choice.

  • As long as somebody has not sent back their RSVP their row will remain red to let you know that you haven’t heard back from them yet.

Beyond that, we’ve got the grey boxes on the right side:

  • The Total Invited box uses a simple Sum formula to add up the number of invited guests

  • The Total Responses box looks to see if someone has responded using a SUMIF formula and adds all of those totals together.

  • The Number of Attendees box finds the total number of people that said they are coming, again using a SUMIF formula.

  • The Waiting On Box just finds the difference between the number of people invited and the number that have responded to give you another way of seeing how many RSVPs you’re waiting on.

The meal counter boxes below are slightly more complicated, but not too bad if you know what you’re doing with formulas. This box looks at all of the food choices on both of the lists and, if there is a comma and a space, splits the text into just the meals. Then it counts the number of each meal and adds it together. If you’re interested in looking more closely at exactly how this is accomplished, you can look at the sheet.

Here’s the link again: Click Here.

To make this sheet your own click File and then click Make a Copy. You can then go and add your own names. Just don’t touch the grey boxes on the right side or you risk messing up the formulas.