Wedding Guest List Template

A ready-made guest list for Excel and Google Sheets: group, side, which event, number of guests, RSVP, table, gift and thank-you columns, with a summary sheet that adds itself up.

For Google Sheets: File > Import and upload the .xlsx; the formulas keep working.

Columns

NameThe guest's name; for a couple, one row such as "Margaret and Richard Hart".
GroupFamily, friends, work, neighbours. Shows who is coming from where.
SideBride's or groom's side; useful for the seating plan.
Invited toCeremony, reception, henna night or all. The henna list differs from the wedding list.
PhoneFor sending the invitation link on WhatsApp.
EmailOptional.
GuestsTotal people on the row; the summary sheet adds these up.
RSVPAttending, not attending, not sure yet, no reply. Use the spelling from the Values sheet so the totals stay right.
TableTable number; filled in two weeks before the day.
NotesDietary needs, high chair, transport.
GiftWhat they gave; for the thank-you note.
Thank-you sentThank-you sent after the wedding.

Summary sheet: invitations, total guests, attending and not attending counts, rows with no reply. The formulas work in Excel and Google Sheets.

You do not have to keep the list by hand

In a digital invitation guests tap the reply button; who is coming and how many appears in your panel instantly and exports in one click. The template is for building the list and the seating plan; the invitation collects the replies.

Frequently asked

How many people should I invite?

Usually 75 to 85 percent of invited guests attend; fewer when many travel. Size the venue to that rate and build the list accordingly.

Separate lists for the henna night and the wedding?

Keep one file and use the "Invited to" column. You can then filter the henna guests and send them a separate link.

Where is the file uploaded?

Nowhere. The template is generated in your browser and downloads straight to your device.