RSVP form template: questions to ask and a sheet to track replies
An RSVP form only needs a handful of questions, and this template has them: attending yes or no, how many people, companion names, dietary needs, a message and the date of the reply. The summary sheet tells you how many replied, how many are coming and how many people that is in total.
Download
No email address needed. Works in Excel, Numbers and Google Sheets (File, Import).
What is inside
- Attending
- Yes or No. Keep it binary; "maybe" makes catering impossible.
- Number of guests
- Including the person replying. The summary sums it for everyone who said yes.
- Companion names
- So name tags, place cards and the door list are right.
- Dietary needs
- Free text, or restrict it to a few options if the caterer needs that.
- Message
- The nice part. Guests like to add a line.
- Responded on
- Who still needs a reminder.
How to use it
- 1
Download the file and keep the RSVPs tab as your master list.
- 2
Send your invitation with the questions from the columns: attending, number of guests, companion names, dietary needs, message.
- 3
Type each reply into a row, or link a Google Form to the sheet so replies appear on their own.
- 4
Check the Summary tab for total responses, attending, not attending and total people coming.
- 5
Two weeks before the event, sort by Responded on and remind everyone who has not answered.
Where the spreadsheet stops
Replies come in five different ways and you type them all.
A GuestlistOnline RSVP link puts a form in front of each guest; answers land on the guest list.
Reminders are manual and you lose track of who got one.
Automatic RSVP reminders go to guests who have not answered, in their language.
Guests need a ticket after they say yes.
Every confirmed guest receives a QR ticket by email, companions included.
Let guests fill it in themselves
Send one RSVP link. Guests answer on their phone, companions and dietary needs included, and your list is always current. Free for up to 50 guests.
Create an RSVP pageQuestions about this template
Other free templates
Free guest list template (Excel, Google Sheets and CSV)
Free guest list template for any event, plus a wedding version with meal choices, tables and thank-you tracking. Excel, Google Sheets and CSV.
Event registration form template (fields, sheet and summary)
Free event registration form template: the questions to ask, a registrations sheet with ticket types and waiting list, and a summary that counts sign-ups. Excel and CSV.
Ready to streamline your event management?
Join thousands of organizers who trust GuestlistOnline for their events. Get started in minutes — no credit card required.
Just one event? Get started free →