The life of every party is in the people that attend. Today, we are going to learn how to create a guest list for your bridal shower.
Bridal shower is one of the most interesting build-up to any bride’s wedding. A lot of things can make or break your bridal shower party and one of them is the quality of people you invites.
While inviting people may not seem a great deal, getting organised around it is important and that is why today we are going to learn how to create a bridal shower guest list using our good old friend Microsoft excel. If you are like me, you can skip the stage below and simply download the free template.
Before we start, what is a bridal shower list and who should be on the list?
A bridal shower gathering is a party that includes the closest associate of the bride. A bridal shower guest list is a list containing the bride’s attendant, personal friends of the bride and family.
Now, let’s create our bridal shower guest list.
Step 1: Decided who you want on the list
If you are saddled with planning your friend’s bridal shower, you will immediately realise that deciding on the people to invite and the number is not an exact science.
As a rule of thumb, the number of people invited to a bridal shower should not be more than 20. Also, avoid inviting people who you know will not be invited to the wedding and finally, make sure the bride is aware of everyone who is invited to the party. After all, it is her party and you do not want to throw a “pleasant” surprise on her.
Step 2: Decide what information you want to keep
There are lots of information you want to keep about your guest but from experience, the following are some of the most important ones you should keep.
- Relationship to the bride
- Invite sent
- Reply Received
Step3: Pick your storage format
Basically, you have two option for storing your document. You may decide to store it online which means you will have to create it using the online version. The other option is to create it on your local system using your Microsoft Excel application.
Either option gives yo the same end result but you can always access one online anytime you want.
I will be creating my template using Google doc so you can easily download the template.
Step 4: Open Excel Sheet
- Go to Google drive.
- Click File
- Click Google Sheet
- Name your sheet
Step 5: Fil in the headers
Now it is time to fill in all the headers we listed above. By the time you are done, your sheet should look like mine.
Step 6: Freeze the top plane
We want to ensure that we know what information we are filling into the different column so we are going to keep the header fixed.
Click on View and use the freeze menu to keep the upper row in place.
Step 7: Enter all other information
Now populate the excel sheet with your information adding appro[iste information in the “notes” column.
That is how we make a guest file in excel. You can make yours following our step by step procedure or you simply make a copy using this link
Now that you have your guest list figured out and properly planned, it is time to send out those invitations. Not sure where to start, check out our invitation section for ideas.