Manage Your Wedding Guest List for Free: DIY Tracking
Managing your guest list is one of the most time-intensive parts of wedding planning—but it doesn't require expensive software. A simple spreadsheet paired with free tools will give you everything you need to track invites, monitor RSVPs, manage addresses, and plan meals. Here's how to build a system that works.
Start with a master spreadsheet
Create one spreadsheet (Google Sheets is free and lets multiple people edit at once) with these columns:
- Guest name
- Relationship or how you know them
- Phone number
- Email address
- Mailing address
- Invitation sent (date or yes/no)
- RSVP status (yes, no, pending)
- Number of guests in their party
- Meal choice (or dietary notes)
- Seating section or table number (fill this in later)
- Notes (e.g., "bringing partner", "vegetarian", "can't do shellfish")
This single sheet becomes your source of truth. Share it with your partner and your parent(s) or wedding planner if they're helping—Google Sheets lets you control who can edit versus view only.
Collect and verify addresses early
Before you order invitations, use your spreadsheet to collect correct mailing addresses. Email or text guests asking for their current address (people move, and Canada Post charges extra to return undelivered mail). Enter everything in your spreadsheet as it comes in.
For guests you're unsure about, cross-reference with LinkedIn, Facebook (if you're comfortable), or just ask. Typing addresses wrong costs time and money when invites bounce back—it's worth getting them right the first time.
Set up free RSVP collection
You have two main options:
Google Forms (free, simple): Create a short form asking for name, number of guests, meal choice, and any dietary restrictions. Share the link via email or text. Responses automatically populate a spreadsheet you can reference. This works well for 30–100 guests.
Free wedding website with built-in RSVP (more polished): Platforms like Wix, Carrd, or even a free Wordpress site let you create a simple wedding page with an RSVP form. Guests see your wedding date and details, and their responses feed into a database you can download or view. See how to make a free wedding website with RSVP functionality for detailed setup.
Include a deadline in your invitation and website (typically 6–8 weeks before the wedding). Mark RSVPs in your spreadsheet as they arrive, and send a gentle follow-up email to anyone who hasn't responded two weeks before your deadline.
Track meal choices and dietary needs
When guests RSVP, ask them to select their meal option or note any allergies and dietary restrictions. Record this directly in your spreadsheet's meal column. Categories might be:
- Chicken
- Beef
- Vegetarian
- Vegan
- Fish
- Special dietary need (e.g., gluten-free, nut allergy)
Keep detailed notes in the "Notes" column for anything your caterer needs to know. A column for "confirmed with caterer" helps you track when you've passed that information along.
Use conditional formatting to spot gaps
In Google Sheets, highlight rows where RSVP status is "pending" in one colour, "no" in another, and "yes" in a third. This makes it instantly obvious which guests haven't responded and who's confirmed. Use the same approach for dietary restrictions—colour-code anything that needs caterer follow-up.
Sync your list with seating later
Once your guest list is final and you're ready to plan seating, you already have every guest's name, dietary needs, and plus-one information in one place. You can sort by table number, cross-reference with seating-chart best practices, or even print sections of the spreadsheet to hand to your caterer. Some couples print their spreadsheet and annotate it on paper—entirely valid.
Export and share what you need
Before your wedding day, create a clean export of your list for your caterer (names, meal counts, dietary restrictions only—not phone numbers or addresses). Make another copy for your seating coordinator or best man. Google Sheets lets you download as .PDF, .CSV, or Excel, so you can format it however you need.
A final note on privacy
Keep your master spreadsheet private. Don't share the full guest list (with addresses and phone numbers) more widely than necessary. Only your partner, parents helping with planning, and your caterer need that complete information.
This system takes about an hour to set up and then just needs quick updates as RSVPs arrive. By wedding day, you'll have a complete record of who's coming, what they're eating, and where they're sitting—no subscription required.