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
| Name | The guest's name; for a couple, one row such as "Margaret and Richard Hart". |
|---|---|
| Group | Family, friends, work, neighbours. Shows who is coming from where. |
| Side | Bride's or groom's side; useful for the seating plan. |
| Invited to | Ceremony, reception, henna night or all. The henna list differs from the wedding list. |
| Phone | For sending the invitation link on WhatsApp. |
| Optional. | |
| Guests | Total people on the row; the summary sheet adds these up. |
| RSVP | Attending, not attending, not sure yet, no reply. Use the spelling from the Values sheet so the totals stay right. |
| Table | Table number; filled in two weeks before the day. |
| Notes | Dietary needs, high chair, transport. |
| Gift | What they gave; for the thank-you note. |
| Thank-you sent | Thank-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.
