Import a guest list from a spreadsheet
Bring in a whole guest list from a CSV or Excel file in two steps, with a check before anything is added. It is free and no account is needed.
What you need
- A file ending in .csv, .tsv, .txt or .xlsx, up to 5 MB. For an Excel file only the first sheet is read.
- If your list is in Google Sheets, download a CSV or Excel copy first.
Import it
- Go to Guests and choose Add guests.
- Under Names, choose Choose a spreadsheet file. Pasting two or more columns into Names opens the same import.
- On the Columns step, check what each column is. Set each to Name, First name, Last name, Group, Tags, Attendance, Invited, Email, Phone or Don’t import. Event Handled guesses from your first row, so headings such as “household” or “family” become Group.
- Choose Next: check N rows.
- On Check and add, read the three lists: New guests to add, Already on your list · not added and Rows we can’t read · not added. A note says how many new Groups and Tags it will make.
- Choose Add N guests.
How it treats your data
- First and last name columns are joined into one name.
- A Tags cell can hold several tags, separated by commas or semicolons.
- Duplicates are found by name, ignoring capitals and extra spaces. Guests already on your list are not changed.
- Attendance and Invited cells are read as yes or no. A value Event Handled does not understand is left as Unconfirmed or not invited, with a note.
- Rows with no name are not added.
Limits and mistakes
You can import up to 1,000 rows at a time. For a longer list, split the file in two and import each part. Guests from the first part will not be added twice.
To take an import back, choose Undo once. The whole import goes back in one step. The imported guests move to the archive, and their email and phone stay with them there.