A wedding guest list template is a spreadsheet that stores every invited name alongside the data the seating chart needs later: party grouping, RSVP status, meal choice and table assignment. The guest list precedes every seating decision; no table is assigned, no head count is confirmed and no floor plan is finalized until the list exists in one structured file. The templates on this page work in both Excel and Google Sheets, and both feed directly into wedding seating chart: what to know when the RSVPs start arriving.
A spreadsheet is the right starting point for guest data because it sorts, filters and counts without any software cost. It stops being the right tool at the seating stage, where live RSVP changes, plus-one confirmations and keep-apart rules break the static grid. The sections below cover the exact columns to build, the Excel and Google Sheets setups, the RSVP tracking formulas and the one-step export that turns the finished list into a chart.
What Should a Wedding Guest List Template Include?
A guest list template includes name, party, address, RSVP status and meal choice columns as its core structure. Each row holds one person, not one household, because seating assigns individuals to chairs; a couple invited together gets two rows sharing one party value. The party column is the single most important field for seating, since guests who share a party value sit together by default.
Listed below are the columns that a seating-ready guest list uses, in machine-friendly form:
- full_name: one guest per row, first and last name in a single cell for clean alphabetical sorting.
- party: a shared label for each household or couple, such as "Nguyen Family" or "Party 14".
- side: partner A, partner B or both; this drives ceremony-side counts and reception balance.
- address: kept for the record, though invitations and addressing sit outside the seating workflow.
- rsvp_status: attending, declined or pending; nothing else.
- meal_choice: the entree selection plus a free-text allergy note.
- plus_one: yes or no, with a second row added once the plus-one's name is known.
- is_child: yes or no; child flags change table capacity math and kids-table planning.
- table: blank until the chart stage, then filled with the assigned table number.
Nine columns cover every downstream decision. Extra columns for gifts, showers or thank-you notes belong in a separate sheet; mixing them into the seating file slows the sort-and-filter work that happens weekly once responses arrive.
Free Guest List Template for Excel
The Excel guest list template is a single worksheet with the nine columns above, an Excel Table applied for automatic filtering, and data validation on the status fields. Recreating it from a blank workbook takes under ten minutes, and the structure matters more than the file: any spreadsheet with these exact headers exports cleanly at the chart stage. Format the header row bold, freeze it, and convert the range to a Table so new rows inherit the validation rules.
The rsvp_status column uses a dropdown restricted to attending, declined and pending; the meal_choice column uses a dropdown listing your caterer's entree options. Restricting these cells prevents the typos ("Attending", "yes", "coming") that break counting formulas later. A summary block above the table shows three live numbers: invited, attending and pending, each driven by a COUNTIF against the status column. The same grid logic appears across see wedding seating chart template examples, where the table column turns into a visual layout.
Free Guest List Template for Google Sheets
The Google Sheets guest list template mirrors the Excel structure and adds live sharing, which is the reason most couples end up in Sheets. Both partners edit the same file at once, parents get comment-only access to flag their invitees, and the file lives at one URL instead of five emailed versions named "final-FINAL.xlsx". Version history recovers any deleted row, which matters when three people edit one list over eight weeks.
Build the dropdowns through Data, then Data validation, with attending, declined and pending as the allowed values, and turn on reject-input for anything else. Conditional formatting earns its place here: color rows green when rsvp_status equals attending and gray when it equals declined, and the sheet becomes readable at a glance. Sheets also exports to CSV in one click from File, then Download, which is the handoff format the chart stage requires.
How Do You Make a Wedding Guest List in Excel?
Making a wedding guest list in Excel takes five steps: create the column headers, enter every invited name as its own row, assign party labels, add dropdown validation to the status columns, and build the count formulas. Start from both partners' draft lists plus each set of parents' additions, and enter everyone before any cutting happens; the sort and filter tools make trimming easier once the full picture exists. A 120-guest list takes roughly one hour to enter.
- Set the headers: type the nine column names from full_name through table across row 1, bold the row and freeze it via View, then Freeze Panes.
- Enter one guest per row: split couples and families into individual rows so seat-level assignment works later.
- Assign party labels: give each household a shared party value; this is the grouping the seating stage inherits.
- Add validation: select the rsvp_status column, open Data, then Data Validation, choose List, and enter attending, declined, pending.
- Build the counts: use =COUNTIF(E:E,"attending") and its declined and pending twins in a summary block above the table.
How Do You Format a Wedding Guest List in Excel?
Format the guest list as an Excel Table with a frozen header row, dropdown-validated status columns and conditional formatting on rsvp_status. Select the data range, press Ctrl+T to convert it to a Table, and pick a banded-row style so long lists stay scannable. Conditional formatting rules that fill attending rows green and declined rows gray give an instant visual head count without touching a formula.
Keep every cell in plain text except the two count-bearing columns, and resist merged cells entirely; merged cells break sorting, filtering and the CSV export. Column widths of roughly 22 characters for full_name and 14 for the status fields keep the sheet printable on one landscape page per 40 guests.
How Do You Create a Wedding Guest List Spreadsheet from Scratch?
Create the spreadsheet by opening a blank workbook, typing the nine seating-ready headers in row 1, and entering guests in individual rows beneath them. The same five-step build works identically in Excel and Google Sheets; only the menu paths for validation differ. A blank-file build beats downloading a decorative template with 30 columns, because unused columns hide the five fields that actually drive decisions.
Once the structure exists, set a weekly rhythm: update statuses every Sunday, re-sort by rsvp_status, and watch the pending count fall. The list is finished at the RSVP deadline, which sits 3 to 4 weeks before the wedding, and the final attending head count goes to the caterer 2 weeks out.
How Do You Track RSVPs in the Spreadsheet?
RSVP tracking in the spreadsheet runs on one column and three values: attending, declined and pending. Every response updates one cell, and the COUNTIF summary recalculates the head count instantly. Filtering rsvp_status to pending produces the exact chase list for the week before the deadline, which is when 10 to 20 percent of guests still have not replied.
The weak point of spreadsheet tracking is that it is manual: every mailed card, text and phone reply becomes a hand-typed cell edit, and a missed edit becomes a missing dinner. A dedicated wedding rsvp tracker closes that gap by letting guests submit their own responses, which then update the list without retyping. Whichever method records the responses, the three-value status column stays the single source of truth for the caterer count and the chart.
Which Columns Feed the Seating Chart Later?
Five columns feed the seating chart directly: full_name, party, rsvp_status, meal_choice and table. The chart stage filters to attending rows only, groups them by party, and assigns each group to tables; the meal column then follows each guest onto place cards and the caterer's per-table counts. How meals travel from list to layout is covered in dietary restrictions wedding rsvp.
Plus-one and child flags drive later table assignments, which is why they earn dedicated columns instead of margin notes. A confirmed plus-one adds a seat to a party and shifts its table-capacity math; a child flag routes a guest toward a kids table or a highchair count. The judgment calls behind those flags, including who receives a plus-one at all, sit in wedding rsvp plus one. Address data, gift logs and shower lists feed nothing at the seating stage and stay out of the export.
From Spreadsheet to Seating Chart
A CSV export imports directly into a seating chart maker, turning the finished list into chart-ready guest data in one step. From Excel, use File, then Save As, and pick CSV; from Google Sheets, use File, then Download, then CSV. The nine-column structure maps automatically: names become guests, party values become pre-grouped clusters, and meal choices arrive as tags. The full field mapping lives in import guest list csv seating chart.
This handoff is where SeatBloom picks up the work the spreadsheet is unable to do: dragging parties onto tables, enforcing keep-apart rules and absorbing the last-minute declines that arrive after the deadline. The free tier accepts the CSV without a card, so the spreadsheet built from this template remains useful to the final week; it just stops being the place where seats get decided.