Wedding Guest List Template
Keep Track of Invitations and RSVPs by Event
Use our free Wedding Guest List Template to track your wedding invitations and RSVPs and who will be attending which part of the wedding day, such as the Dinner or Reception.
Estimate Costs
Easily estimate the costs for your rehearsal dinner and reception based on the number of guests attending. You can use this template along with the Wedding Budget Spreadsheet to keep track of your budget and spending.
Make Note of Important Details
Some of the columns can be used to keep track of important facts about your guests, such as food restrictions, the gift(s) they gave you, as well as any other important notes or details you need to include.
Wedding Guest List
for Excel
Description
This template provides an efficient way to keep all the your wedding guest info in one place. It allows you to keep track of the names and contact information of those you've invited to attend your wedding dinner and wedding reception, or can be customized with other events.
Use the different columns to keep track of important details about your guests, such as dietary restrictions, their gifts, where they will be seated, and other notes.
If you know the cost per person for your dinner and reception, the template will automatically give you a total estimated cost for each event based on how many guests are attending.
You can also print this spreadsheet and fill it out by hand.
Creating Address Labels
Before using Word to do a mail merge, copy the addresses from your guest list into the first worksheet in a new Excel file with the labels as the first row in the worksheet. Then save that new file somewhere convenient. You can then use that Excel file as the Recipient List when doing your mail merge. (You may need to manually match the ST field to State, or change the label to State).
See the article Mail Merge Using an Excel Spreadsheet on the support.office.com site to learn how to do a mail merge.
Wedding Planner Template Bundle
Check out the Wedding Planner Template, which includes a wedding guestlist template along with other valuable spreadsheets for planning your wedding!
Wedding Guest List for Excel 2003
-Original Excel 2003 Version
Description
This is the original version created in Excel 2003, also compatible with OpenOffice. The functionality is basically the same as the newer version.
If you are sending invitations to families, record the number of people you are inviting. Then, after you receive your RSVP, record the # of people attending both the rehearsal dinner and the reception.
Enter the cost per head for the dinner and reception. The total cost is calculated based on the number of people attending.
For the dinner, record known dietary restrictions and make seat assignments, if necessary.
After the reception, use your wedding guest list to help you record the descriptions of gifts received, so that you can mention the gifts in your thank you notes.
