The Planning Edit

How to Import a Guest List From Google Sheets Into Your Wedding Planner

The list already exists, in a spreadsheet, and nobody wants to type every name a second time. How to get a sheet ready for any planner, the export that works, and exactly how the list goes into UNSTAGED.

Words · The UNSTAGED Studio5 min read
A full reception room, guests talking and laughing in warm light
Type every name once. The spreadsheet already did

Most guest lists start in a spreadsheet, because that is where a list of names goes first: a column of names, a column for whose side, a few email addresses, a note about who might bring someone. By the time you move into a planner, the list is a hundred rows long and retyping it is an evening nobody wants. You do not have to. Most planners can read a spreadsheet in, and the work is mainly in getting the sheet ready.

Get the sheet ready first

Ten minutes in the spreadsheet saves an hour in the app

One row per person

Not per invitation. A couple invited together is two rows, and each child is a row. Planners count heads, and so does the caterer.

One header row, plain names

Name (or First name and Last name), Email, Phone, Group, Notes. Delete title rows, blank rows above the headers and totals at the bottom.

One line per cell

An address written over two lines inside one cell breaks most imports. Keep every cell to a single line.

Leave out what is not decided

Replies, tables and meals are quicker to set in the planner as they happen than to get exactly right in a file now.

Remove the duplicates now

Sort by name and read down the column. A planner imports exactly what the sheet says, twice if it says it twice.

Download it as a CSV

A CSV is the plain-text version of a spreadsheet, and it is what almost every planner reads. In Google Sheets: File, then Download, then Comma Separated Values (.csv). It downloads the tab you are looking at, so if the list has several tabs, open the right one first. From Excel or Numbers, save or export as CSV in the same way.

Import the list once, from a clean sheet. Everything after that happens in one place.

Bringing it into UNSTAGED

On the web, on a computer

Open the guest list

Planning, then Guest List.

Choose “Import CSV”

At the top of the list, beside “+ Add Guest”. The question mark next to it lists the columns it recognises.

Pick the .csv file

Columns are matched by their headers: Name (or First name and Last name), Email, Phone, Group, RSVP, Meal, Allergies, Table, Plus One and Notes, and an address in Address, Postal code and City.

Check the preview

Every guest is listed with name, email, group and meal before anything is saved. If something is wrong, press Cancel, correct the sheet and pick the file again.

Import

The button says how many guests it will add. Guests without a group go into No Group, and a group you already have takes in the new guests that name it.

Plus-ones come in two ways. A Plus One column with yes gives a guest a plus-one, and a Plus One Name column names them. A plus-one with their own meal or allergy goes on a row of their own, with “+1 of” and the guest's name in Notes, and the import attaches them to that guest. There is no household field, so a couple who share an invitation stay two guests, which is also how they will be seated. The import adds every row it is given, so bring the list in once and add later names by hand or in a file of their own.

The import is on the web. Once it is done, the whole list is on both your phones, because the iPhone app reads the same guest list. New guests can be added on iPhone one at a time, and the list can go back out as a CSV from the web whenever someone needs a copy. If your wedding is connected to Claude or ChatGPT, you can also paste the names into the conversation and ask it to add them.

Once the names are in, they go straight into the seating chart in UNSTAGED.

Clean the sheet, download it as a CSV and bring it in once. The guest list has already been written. It does not need writing again.

— The UNSTAGED Studio

Planning your own wedding? Try UNSTAGED free for seven days.

Start free trial

More guides

More from The Edit