Import your guest list from Excel – with a blank template

Updated:

Small celebrationBuffetEntrance123456
Small celebration

Most couples already keep their guest list in a spreadsheet. There is no need to type it again.

No list yet? The blank template

Download the blank guest list template for Excel (or as CSV for Numbers, LibreOffice and Google Sheets). It has exactly the columns the planner recognizes on its own:

Column What goes in
First name, Last name Only one of the two is required.
Group e.g. Bride’s family, Friends, Work
Meal e.g. Beef, Fish, Vegetarian, Kids
RSVP yes, no, or empty while you wait for an answer
Special needs wheelchair, high chair or allergy
Notes free text, e.g. nut allergy

For a plus-one, write “+1” after the name. A second sheet in the file explains this again. The template is free and needs no sign-up.

Option 1: paste columns

  1. In Excel, Numbers or Google Sheets, select the column with the names – several columns are fine too, such as first name, last name and group.
  2. Copy the selection.
  3. In the planner, open Guests → Paste several names and paste.

The planner recognizes tabs, semicolons and commas as separators. In the preview you decide what each column is: full name, first name, last name, group – or “do not use”.

Option 2: open a CSV file

Save your spreadsheet as CSV (UTF-8) and open it with Open CSV file. The file is read only on your device and never uploaded. Accents and special characters are kept, even if the file comes from an older Excel version.

Heading row or not?

If the first row says “Name”, “First name” or “Group”, it is treated as a heading. If it already contains a guest, that guest stays in the list. You can change this at any time with the “First row is a heading” switch – the preview shows straight away which names will be added.

Using groups

A column such as “Bride’s family” or “Work” can become the group. Groups help you filter and seat people together. They are optional and never decide on their own who sits where.

Plus-ones (+1)

If your list has “+1” after a name, such as “Anna Miller +1” or “Anna Miller (+1)”, the planner also adds “Guest of Anna Miller”. The preview marks this with a “+1” badge. Both get the seating wish “together”. For guests you type in one by one, tick “With a plus-one (+1)” and add a name if you know it.

Same names

Two guests with the same name are never merged – they stay two people. Add a note if it helps, for example “Anna Miller (aunt)”.

What you do not need

The planner does not need email addresses, postal addresses or ages. Only bring in what matters for the seating chart, the kitchen or the venue. Set columns you do not need to “do not use” in the preview.

Back to the overview: How to create a seating chart.

Try it in the planner