Use this free, importable wedding guest list template in Excel to track names, RSVPs, meal choices and seating — and to import those rows into Google Sheets, Outlook or a guest-management app. The file is set up so you can print name lists, build a seating plan and export for check-in.
What does this wedding guest list template contain?
This Excel template is a single workbook with three tabs: Master list, RSVP log and Summary. Each guest is one row in the Master list and has a unique ID (G001, G002…). The important columns included are:
- Unique ID (for safe imports and syncs)
- Party name / Household name
- Guest first name, last name
- Email address (optional)
- Mobile phone (optional)
- Invitation sent (date)
- RSVP status (Invited / Yes / No / Maybe / Pending)
- Number of attendees in this row (1, 2, etc.)
- Plus-one allowed (Yes/No)
- Meal choice (Vegetarian / Meat / Fish / Child / Other)
- Dietary restrictions (free text)
- Table number / Seating group
- Place name / Meal served
- Accommodation needed (Yes/No)
- Transport required (Yes/No)
- Notes (e.g. gift idea, role in wedding)
The RSVP log records the date and method of each RSVP (email, form, phone) so you have a time-stamped history. The Summary tab has pivot-like formulas: totals by RSVP status, meal counts and a simple table map for printing.
How to download and use the template (Excel and printable)
The template is an .xlsx file ready to open in Excel (Windows or Mac), LibreOffice and most spreadsheet apps. To use it:
- Download the file and save a copy immediately with your wedding name and date in the filename (e.g. "SmithWedding-GuestList.xlsx").
- Open in Excel and enable editing if required. Do not rename the Unique ID column header — it is used for imports.
- Start by filling the household or invited party rows, not every +1. Use the "Number of attendees" column to record how many seats a row will occupy.
- Use data validation lists (already in the template) to keep RSVP, meal and table inputs consistent.
- Print the Summary tab for your caterer and the Master list for check-in. The template's print layout fits A4/letter with compact columns.
If you prefer a printable roster only, use the Summary tab and the "Guest name and meal" print view. > Tip: print one copy per table with place names for place-card production.
How to import my Excel list into Google Sheets, Outlook or an app?
Short answer: export or upload the .xlsx file directly to Google Drive (Sheets) or convert to CSV for Outlook and many apps. Steps differ by platform:
- Google Sheets (international): Upload the .xlsx to Google Drive and open with Google Sheets — the sheet structure and validation usually survive. Check formulas and data validation after import.
- Outlook Contacts (US/UK/Israel, indicative): Export a contacts CSV with headers that Outlook recognises (First Name, Last Name, Email Address, Business Phone). Use the Contacts import wizard in Outlook to create contact records for email invitations. Excel to CSV and then import.
- Planning apps: Most apps accept CSV or Excel imports. Open the app's import template or mapping screen and map our columns (Unique ID -> ID, First Name -> First Name, RSVP -> Status, etc.). Always run a small test import first with 5–10 rows.
Why use CSV for imports: CSV is the lowest-common-denominator format and reduces formatting problems. Keep encoding to UTF-8 if you have accented characters (common in French or Hebrew names).
Can I synchronise the Excel list with a guest-management application?
Yes, most modern wedding systems allow an import and some offer two-way sync — though true live sync depends on the app. Typical options:
- One-time import: You upload your Excel/CSV. The app stores and becomes the new source of truth.
- Manual re-import: You keep the Excel as master and re-import updated CSVs when needed (risk of duplicates).
- Two-way sync: Rare in free tools; usually paid apps offer connectors to Google Sheets or CSV sync. When available it uses the Unique ID to match rows and update existing records rather than creating duplicates.
Before syncing: always back up your Excel file and ask the app to show a preview or dry-run. Map the Unique ID so the app updates rows instead of creating new ones.
See our comparison of tools in Spreadsheet or wedding planning app: which should you use? for guidance on when to stay in Excel and when to move to an app.
What is the best column structure depending on guest count?
Choose a structure that keeps the file fast and readable.
- Small weddings (≤100 people in France, indicative): one row per person or household works. Include contact fields and dietary details. Use columns for Table and Seat if you plan to assign places.
- Medium weddings (100–200 people, US/UK indicative): one row per invited unit (household) with a "Number attending" column scales better. Keep separate detail sheets for individual meal choices and plus-ones if needed.
- Large weddings (>200 people, indicative): use a database-style layout: one Master guest table, one RSVP log as a separate tab and a seating table. Consider a proper guest-management app to avoid manual errors and slow spreadsheets.
Always include a Unique ID column: it prevents duplicates when importing, allows safe edits and keeps timelines consistent across tools.
Which fields should I add for seating plans and meal management?
For seating and catering you want these extra fields:
- Table number (integer)
- Seat number (optional)
- Place card name (free text)
- Group/Block (e.g. family, friends, colleagues)
- Starter/Main/Dessert choice if your caterer needs course-level counts
- Allergy flag (Yes/No + notes)
- Meal confirmed (Yes/No) — useful when guests change their mind
Use filters or pivot tables to produce per-table guest lists and per-meal totals for the caterer. The Summary tab in the template already aggregates meal totals by dietary type.
How to avoid common errors and keep the list up to date?
Common mistakes and how to avoid them:
- Duplicate rows: always use the Unique ID and search before adding new entries.
- Inconsistent status labels: use dropdowns (data validation) for RSVP and meal choices.
- Lost history: keep the RSVP log tab and never overwrite the date fields — append new rows when you record a change.
- Broken imports: before importing to a third party, export a CSV and test with 10 rows. Use UTF-8 to preserve accents.
- Simultaneous editing: Excel files on a shared drive can create conflicts. If multiple people edit, use Google Sheets as the collaborative master or use versioned copies.
Practical tip: keep a single "master" file and a dated archive copy each time you do a major change (e.g. after sending reminders). This keeps a rollback point.
Printable guest list template: practical tips
If you need printed lists for the registrar, caterer or check-in desk:
- Use the Summary tab for a one-page per-table printout.
- Create a separate print-friendly tab with larger columns for names and meal choices.
- For check-in, print a packet of pages alphabetical by last name with columns for "Checked in" and "Notes."
- Use landscape orientation for name + meal + table columns to avoid wrapping.
Advantages and limits of using Excel alone vs a dedicated app
Excel advantages:
- Full control and privacy (data stays in your files).
- Flexible layout for printing and bespoke reports.
- No subscription cost for one-off weddings (software cost of Office may apply).
Limits of Excel:
- Manual reminders and no built-in RSVP forms or automated follow-ups.
- Risk of duplicate records and human error when multiple editors work at once.
- No guest check-in QR scanning or wallet passes without additional tools.
If you want automated reminders, RSVP forms, check-in scanning and AI seating help, consider a purpose-built app; read Wedding guest management app: free guide to RSVPs, +1s and diets and our comparison of apps in Best wedding planning apps 2026 — compare features & price.
Example workflow for a small wedding (~80 people) — France, indicative
- 9–6 months before: build the Master list in Excel. Add households and tentative plus-ones.
- 3 months before: send save-the-dates and record invitations sent (date column).
- 8–6 weeks before: send invitations and start tracking RSVP status in the RSVP column.
- 4 weeks before: finalise meal choices with a cut-off date and lock the Summary meal counts for the caterer.
- 2 weeks before: export a final CSV for your seating chart tool and print check-in sheets. If using an app, import the CSV and enable check-in features.
Costs: catering meal counts and place cards vary by country; for France (indicative, 2026) caterers commonly charge EUR 50–180 per head depending on menu and location. Always confirm final numbers and special-diet counts with your vendor.
For more on managing RSVPs and reminder strategy see Wedding RSVP: how to collect, chase and manage guest confirmations.
Conclusion
A clean, importable wedding guest list template in Excel gives you precise control for printing and early planning. Use a Unique ID, consistent dropdowns and a separate RSVP log to avoid mistakes. When you need automation — reminders, QR check-in or AI seating — consider moving the data into a guest-management app for time savings. If you start in Excel, keep it as your master and test imports carefully.
For help deciding whether to stay in spreadsheets or switch to an app, read Spreadsheet or wedding planning app: which should you use? and our overview of guest-focused tools in Wedding app: 2026 guide to guests, budget & seating.