Wedding guest list template UK: columns, ranking and seating sync

A wedding guest list is more than names on paper. It drives invitations, RSVPs, catering numbers, allergens, seating and thank-you notes. This UK guide shows which columns to put in a spreadsheet (Excel or Google Sheets), how to rank an A/B/C list, how to sync with the seating plan, a short privacy note for guest data, and when to freeze numbers for the caterer. Need an event-agnostic RSVP and allergen sheet (weddings, parties, corporate, christenings)? See the RSVP tracker spreadsheet UK guide.

What to put in a wedding guest list spreadsheet

One row per person (or one row per household if you prefer, with names listed together). Useful columns:

You can start simpler and add columns as you go. The important part is one master list that invitations, catering and seating all draw from.

Template: the Wedding Invitation Suite (Editable PDF + Word) (£3.49) has an editable invitation, evening invite, RSVP card (meal choice and dietary lines), details card and save the date in three designs, plus a Word version. Free wording: wedding invitation wording UK.

A/B/C list ranking

Most couples cannot invite everyone on the first pass. An A/B/C ranking keeps the decisions calm:

Write the venue's day and evening capacity at the top of the sheet. Count A-list day guests first, then add B-list only up to the comfortable seated number. Move evening-only people to a separate filter or a clear "evening" invite type so they do not inflate the meal count. When someone on the A-list declines, promote one B-list name rather than inviting randomly.

Spreadsheet vs paper

Paper sticky notes work for a first brainstorm. A spreadsheet wins as soon as you need to sort by RSVP, filter day guests for the caterer, or hand names to the seating chart. Google Sheets is handy if both of you (and a wedding planner) edit on phones; Excel is fine if you prefer offline files. Print a filtered day-guest view for meetings with the venue if that helps.

How to sync the guest list with the seating plan

Keep the guest list as the source of truth. When most day RSVPs are in:

  1. Filter to day guests with status "accepted".
  2. Copy those names into your seating chart (or open the seating template and paste).
  3. Add meal choice and allergen columns to the seating view for the caterer — not on the public display chart.
  4. When someone drops out or a plus-one is named late, update the guest list first, then the seating chart.

For etiquette, top table options and balancing tables, see how to write a wedding seating plan. For how many rounds you need, use the free table seating calculator or the worked examples in how many tables for 100 guests. To turn the final list into a printed chart and table numbers, see our wedding seating chart template UK guide.

Illustrative layout (made-up names)

The names and details below are invented for illustration only — not a real wedding.

Name              Household     Side   Invite   RSVP      Meal     Allergens     Plus-one   Table
Sam Patel         Patel         Bride  Day      Accepted  Main A   None          Alex P.    —
Jordan Lee        Lee           Groom  Day      Accepted  Main B   Gluten-free   —          —
Casey Morgan      Morgan        Shared Evening  Invited   —        —             —          —
Riley Chen        Chen          Bride  Day      Declined  —        —             —          —

In a live sheet you would add address, contact details and thank-you columns; the short grid above is only to show the shape.

When to freeze numbers for the caterer

Ask your venue or caterer for their final-numbers deadline in writing. It is often around two weeks before the day, sometimes earlier for large menus. Work backwards:

Allergen communication matters: UK food businesses must be able to tell guests about the 14 major allergens in what they serve (Food Standards Agency). Your job is to collect clear information and pass it on accurately.

Guest data and privacy (high-level, not legal advice)

Names, addresses, emails, phone numbers and allergy details are personal information. Treat the list carefully:

This is practical hygiene, not legal advice. If you are unsure about your situation, check guidance from the Information Commissioner's Office (ICO) or get professional advice.

From guest list to wedding day timeline

Once numbers are frozen, the same list feeds the plan for the day itself: day and evening arrival times, who sits where for the wedding breakfast, and evening food numbers for the caterer. Our wedding day timeline UK guide shows how to build the running order and run sheet.

Budget and venue next steps

Guest numbers drive most of the cost. Once the day list is roughly stable, update your budget and compare venues on total and cost per guest. The free wedding budget calculator and our guides on how to budget a UK wedding and the venue booking checklist sit alongside the guest list. The UK Wedding Budget Planner (£5.50) and Venue Comparison Scorecard & Viewing Checklist (£2.99) are ready-made spreadsheets for budget and venue scoring.

For the full month-by-month plan that the guest list sits inside, see the wedding planning checklist UK.

Free tools: table seating calculator · wedding budget calculator · wedding seating plan · tables for 100 guests · budget a UK wedding · venue booking checklist · wedding day timeline · wedding planning checklist · RSVP tracker spreadsheet UK

Free tools for this

Frequently asked questions

What columns should a wedding guest list template include?

Name, household or address, side (bride/groom/shared), invite type (day or evening), contact details, RSVP status and date, meal choice, allergens or diet, plus-one, table (later), thank-you sent, and notes.

What is an A/B/C wedding guest list?

A ranking: A must invite, B invite if space and budget allow or if A-list people decline, C nice to have (often evening only). Fill A first up to your venue capacity, then add B carefully.

Should I use Google Sheets or Excel for a wedding guest list?

Either works. Google Sheets is handy for shared editing on phones; Excel is fine offline. A spreadsheet beats paper once you need to filter RSVPs or export names for seating and catering.

How do I sync the guest list with the seating plan?

Keep one master guest list. When day RSVPs are mostly in, filter to accepted day guests and copy them into the seating chart. Update the guest list first whenever someone changes, then the seating chart.

When should I freeze guest numbers for the caterer?

On the date your venue or caterer sets in writing — often around two weeks before. Set your RSVP deadline earlier, chase once, then send a clean name, meal and allergen list and only change it for drop-outs or new allergy information.

Should allergies appear on the public seating chart?

No. Give the caterer a per-table list with meal choices and allergies, and use a discreet code on place cards if staff need a cue. Keep medical detail off the display board guests read.

Is storing wedding guest details a privacy issue?

Names, contacts and allergies are personal information. Share only with people who need them, keep the file private, and do not post full details publicly. This is practical guidance, not legal advice — see the ICO for official information.

What is the difference between a day and evening guest list?

Day guests are invited to the ceremony and wedding breakfast; evening guests join later for the reception. Track invite type clearly so catering numbers only count day (and any evening food you have ordered).

How does the guest list feed the wedding day timeline?

Day and evening numbers set catering and evening food times, the seating plan sets the call to the wedding breakfast, and evening guests need an arrival time on the running order. Our wedding day timeline UK guide covers the run sheet columns and buffer time.

Is there an RSVP tracker spreadsheet for any event, not just weddings?

Yes. Our RSVP tracker spreadsheet UK guide covers guest list columns, collecting replies, chasing late RSVPs, dietary requirements and the 14 UK allergens for the caterer, for weddings, parties, corporate events, christenings and birthdays, and links the Guest List, RSVP & Allergen Tracker. This page stays wedding-focused (A/B/C ranking and seating sync).

Written with AI assistance and checked against GOV.UK guidance. General information, not financial, tax or legal advice.