Wedding Guest List & RSVP Tracker Spreadsheet
Manage your whole guest list in one sheet: who's invited, who has replied, meal choices, tables, gifts and thank-you notes. The counts update themselves.
★ WHAT YOU GET
• 1 spreadsheet (.xlsx) with 5 tabs: Start here, Dashboard, Setup, Guests, Tables
• Guests tab for up to 400 people (one row per person): household, side, group, A/B list, child, email, phone, address, save-the-date sent, invite sent, RSVP, meal, dietary needs, table, gift, thank-you sent, notes
• Drop-downs for side, group, list, RSVP (Yes / No / Pending), meal (up to 6 options you name) and child Y/N
• Dashboard: totals attending / declined / awaiting, split by side, A/B list, children and group; meal counts; households; gifts and thank-yous outstanding; guests without a table
• Tables tab: up to 40 tables with seats per table, number assigned and an over-capacity warning
• Attending rows turn green, declined rows grey
★ COMPATIBILITY
Made for Google Sheets (free Google account; upload the .xlsx to Google Drive, then open it with Google Sheets), Microsoft Excel 2010 or later, and LibreOffice Calc. Formulas were checked for Google Sheets and Excel compatibility (standard functions only, no macros, no add-ins) and tested in LibreOffice Calc. Unzip the download first (double-click on most computers). Best used on a computer or tablet. Enter dates as real dates (e.g. 3/15/2027 or 15/03/2027).
★ GOOD TO KNOW
• It doesn't draw a seating chart. It counts guests per table number.
• The file will hold personal contact details, so only share it with people helping you plan.
• Demo guests are included; delete them before you start.
★ Personal use only: for your own wedding. Please don't share, resell or redistribute the files.
★ Digital download: nothing physical is shipped. You get one .zip file; unzip it to get the files.
★ 14-day promise: if a file is faulty or not as described, contact me within 14 days and I'll fix it or refund you.
Made with the help of AI tools (drafting text, layouts and formulas); I chose the content and reviewed and edited every file.