Guest lists start out scattered: your parents write names in a notebook, one of you keeps notes on a phone, the other messages a list of university friends. By the time you print cards or book tables, you are merging five sources and it is easy to miss someone or invite them twice. A single spreadsheet fixes that, and the same file can feed your online invitation so every guest gets a personal link.

Why a spreadsheet works

  • Almost everyone in the family can open Excel or Google Sheets.
  • Filter and count instantly: how many guests each side invited, who still has no invitation.
  • Share it with the person seating guests, the welcome team or the venue.
  • Import it straight into your invitation's guest list.

The columns to set up

One row per guest, or per household invited together. Row one holds the headers. A layout that works well:

  1. name: the name shown on the card, written the way your family addresses them, such as “Aunt Lan and Uncle Hung”.
  2. phone and email: for sending invitations and reminders.
  3. category: groom, bride, friends, family, colleagues or other.
  4. greeting: the salutation before the name, such as “Dear”.
  5. party size: how many people this invitation covers.
  6. sent: Sent or Not sent.
  7. RSVP: Attending, Not attending or Pending.
  8. table: the table number for your seating plan.
  9. gift: amount or item, for thank-you notes later.
  10. notes: vegetarian, needs parking, and so on.

Writing guest names

  • Write names exactly as they should appear on the card; with personal links they show word for word.
  • Invite a whole family on one row and put the number of people in party size.
  • Avoid line breaks inside a cell. They can shift columns when you save as CSV.

Build the file step by step

  1. Create one shared file with the headers above and freeze the top row (View, Freeze, Top row).
  2. Turn the range into a table (Ctrl + T in Excel) so every column gets a filter and new rows extend it.
  3. Add dropdowns for category, sent and RSVP with Data Validation, so everyone spells values the same way and the counts stay correct.
  4. Let each family fill in its own section rather than everyone editing the same rows.
  5. Highlight duplicates in the name column with Conditional Formatting, then check them.
  6. Put the summary formulas on a separate sheet so you can read totals without counting by hand.

Formulas you will actually use

These assume the column order above (A to J) with data in rows 2 to 500. Some regional settings use semicolons instead of commas between arguments.

  • Total invitations: =COUNTA(A2:A500)
  • Total people expected: =SUM(E2:E500)
  • Invitations from the groom's side: =COUNTIF(C2:C500,"groom")
  • Invitations not yet sent: =COUNTIF(F2:F500,"Not sent")
  • People confirmed attending: =SUMIFS(E2:E500,G2:G500,"Attending")
  • Bride's side confirmed: =SUMIFS(E2:E500,G2:G500,"Attending",C2:C500,"bride")
  • Tables needed at 10 per table: =ROUNDUP(SUMIFS(E2:E500,G2:G500,"Attending")/10,0)
  • Flag duplicates: =COUNTIF($A$2:$A$500,A2)>1

COUNTIF counts rows; SUMIFS adds up party sizes. One invitation can be a family of four, so always book tables with SUMIFS, never by counting rows.

From spreadsheet to table count

  • Seats per table: many venues seat 10, some 8 or 12. Ask, then change the 10 in the ROUNDUP formula.
  • No reply by the deadline: call or message those guests directly, and agree a few standby tables with the venue instead of guessing.
  • Welcome team lists: filter by category, hide phone and gift columns, then print one copy per side.

Importing the list into your online invitation

One general link is convenient, but it does not tell you who opened the card. The guest list at /dashboard/guests gives each person a personal link that shows their name, and shows you who has viewed and who has replied.

  1. Open /dashboard/guests and pick the invitation.
  2. Choose Import list. Either upload a CSV file (UTF-8, up to 1 MB) or copy cells from Excel or Google Sheets and paste them. The header row is optional; without it, columns are read in order.
  3. Check the import preview, then import. Up to 500 rows go in at a time.
  4. Copy each guest's personal link and send it in Messenger or WhatsApp, then mark the guest as Sent.
  5. Near the wedding, use Export CSV. The file includes each guest's category, sent and viewed status, RSVP, gift notes and personal link, ready for your table formulas.

Common mistakes

  • Each person keeps their own copy, so totals never match. Use one shared file.
  • Categories spelled several ways. Use dropdowns.
  • Counting rows instead of people. Add party size and use SUMIFS.
  • Importing the same file twice. Next time import only new guests, and remove duplicates from the list.
  • Sharing a file full of phone numbers publicly. Share it only with the people who need it.

Excel or Google Sheets?

If both families are filling in the list, Google Sheets is easier because sharing and simultaneous editing are built in, and its phone app is quick for small edits. If only the two of you manage it on a laptop, Excel is perfectly fine. Both support COUNTIF and SUMIFS with the same syntax. Update the file weekly while invitations go out, and daily in the last week before you confirm numbers with the venue. For deciding who makes the list in the first place, see /blog/wedding-guest-list-management.