To transfer your Excel sheet to Google sheets, click file > import > upload. It's a great way to keep everyone in the loop at all times. Share your Google Sheet with your wedding planner, catering staff, or anyone else who is helping you plan the big day. You can easily share your wedding guest list details with anyone by converting your Excel sheet into a Google Sheet. 9| Turn your Excel sheet into a Google sheet for easy sharing. Plus, the hosts of each different event may ask for a guest list with contact information so they can send out invitations or other correspondence. Separate each Excel sheet by event, like one sheet for “wedding”, one for “rehearsal dinner” and so on. This is a helpful way to keep track of guests who have attended your wedding showers, too, and is an especially useful for notating gifts from each guest. That way you can easily keep track of how many seats you have reserved in someone's honor.Ĩ| Create a new Excel "sheet" for each wedding event. 4| Have one column for "number of guests invited" and another column for "number of guests attending".įor those who are only allowing a certain number of guests per party, you'll need to include two columns to keep track of it all: one column for the number of guests invited and another column for the number of guests who are attending. Then click format > cells > special > zip code. In Excel, select the entire zip code column. So if you have guests in the northeastern United States, a "01102" suddenly becomes "1102". When a zip code begins with "0", Excel drops the zero. 3| Change zip code column cells to "zip code" or "text". Otherwise, it's just a really nice, clean way to view all addresses without seeing everything jumbled together in one column. (This is how I set up envelopes for address printing!) If you already have this divided up in your original spreadsheet, it may save you the trouble of having to copy it over into a new form. If you are having addresses printed, many professional print shops will require a separate column for the guest's name, street address, city, state and zip code. Here’s how to organize your wedding guest list in Excel… or skip the DIY and get instant access to my Wedding Guest List Excel Sheet Template in the form below.Ģ| Use separate columns for each: street address, city, state and zip code. Not only is this useful for wedding invitation addressing, but it will also help you keep track of RSVPs and meal selections, get a final headcount before the big day, develop your seating chart, and write thank you notes. Today, I am spilling the beans on how to organize your wedding guest list in Excel. Imagine how relieved you’ll feel when you can easily keep track of RSVPs, meal choices, phone numbers, and more–all in one place. Quickly pass along meal selections to your caterer. If you’re feeling overwhelmed, then it’s time to learn how to organize your wedding guest list in Excel.īe the bride who has it all together–the one who sends thank you cards on time and remembers Aunt Mae’s gluten allergy. Does it feel like your wedding planning to-do list never ends? How will you keep track of all of those RSVPs? Gifts? Food allergies?
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |