Skip to content
Christmas and Valentine’s Day editions: free

Free tool

Wedding guest list template: a free spreadsheet

A wedding guest list works best with one row per person, grouped by household. Tick the columns you need (replies, dietary needs, tables, rooms) and download the spreadsheet your caterer, stationer and venue will ask for.

  • Free
  • No sign-up
  • Runs in your browser

Guest list template

The columns you need

One row per person, not per household.

A .csv file with 24 columns. It opens in Excel, Numbers and Google Sheets.

What you’ll download

The first three rows are examples, to delete or keep as a guide.

HouseholdFirst nameSurnameAdult or childSideEmailPhoneAddressPostcodeTownCountryInvitation sentReplyReply dateDietary needsAllergyChildren’s menuTableAccommodationShuttleAt the brunchGift receivedThank-you sentNotes
The WalkersTomWalkerAdultAlicetom.walker@example.co.uk07700 90012314 Mill LaneOX4 1AAOxfordUnited KingdomYesYes12/03/2027NutsNoOakThe Old MillYesYesArriving the night before
The WalkersLilyWalkerChildAliceYesYes12/03/2027YesOakThe Old MillYesYes
Hannah PriceHannahPriceAdultJameshannah.p@example.co.uk07700 9004562 Market SquareGL54 2HBStow-on-the-WoldUnited KingdomYesAwaitingVegetarianNoWillowTo findNoNoBridesmaid

Scroll the table to see every column.

Three rules that save trouble

  • One row per person, a “Household” column to group them. The caterer counts plates, the stationer counts envelopes: the Household column lets you do both without keeping two lists.
  • Children are guests. They have a seat, a menu, sometimes a bed. Don’t leave them in the notes.
  • “Awaiting” is not “No”. Keep all three states: otherwise you’ll chase people who have already replied, which is the best way to annoy them.

Or let the list fill itself in

On a Weddtap page, your guests reply themselves, with their dietary needs and where they’re staying. You follow the replies as they come in, and export the spreadsheet at the end, already filled in.

Create your page, it’s free

Did this help? Pass it on to a friend who’s getting married.

The maths, plainly

Key takeaways

1 rowper person, not per household: the caterer counts plates and the seating plan counts chairs.

  • A wedding guest list works best with one row per person, plus a “Household” column so you only send one invitation per address.
  • The useful columns are the ones your caterer (dietary needs, allergy, children’s menu), your stationer (postal address) and your venue (table, accommodation, shuttle) will ask for.
  • The template is a UTF-8 .csv file that opens with its accents intact in Excel, Numbers and Google Sheets.

How the template is built

  1. 01Seven groups of columns to tick: the essentials (household, first name, surname, adult or child, side), contact, postal address, replies, food, on the day, and your notes.
  2. 02Each group says who it’s for: you, the stationer, the caterer or the planning on the day. You only keep what you’ll need.
  3. 03The file is exported as UTF-8 with a byte order mark and a comma separator, which Excel reads correctly.
  4. 04It’s made in your browser: no data is sent to a server, and nothing is kept.

Frequently asked questions

What we get asked most

One row per person or per household?
Per person, always. The caterer counts plates and the seating plan counts chairs: both work per person. The “Household” column then lets you group people so you only send one invitation per address.
The file opens badly in Excel and the accents look wrong
Ours shouldn’t: it’s exported as UTF-8 with a byte order mark, which Excel reads correctly. If you open it again after re-saving it yourself, choose “CSV UTF-8” rather than plain “CSV”.
What about dietary needs and allergies?
Note them down, but remember an allergy is health data: share it with the caterer only, not in a document the whole family can open. On a Weddtap page, those replies are visible to you alone.
When should we freeze the list?
Caterers usually want final numbers ten to fifteen days before. Take stock three weeks before that date: it leaves time to chase the stragglers without rushing.

Another question? The team reads everything and replies personally. Write to us

The blog

Go further

The guides that go with this tool.

On the day, your guests won’t read your spreadsheet

What they look for is the time, the address, where to park and which table they’re on. Your wedding page tells them, and keeps itself up to date.

Free, no card needed.