How do I import guests from a spreadsheet?

A guest list usually starts life in a spreadsheet. Import it once and every row becomes a guest with their own personal link.

Prepare the file

Save the list as a .csv, .xlsx or .xls file with a header row. Nimanto reads these columns, in any order and in any capitalisation:

• Name (required): also accepted as guest, guest name, full name.
• Email: also e-mail, email address, mail.
• Phone: also mobile, whatsapp, phone number, contact, number. Include the country code, for example +1 512 555 0100.
• Passes: also seats, guests, count, headcount, party size. The most people that guest can reply for.
• Group: also side, tag, category, family.

Rows without a name are skipped. Only the first sheet of an Excel file is read.

Import the file

1. 1Open the invitation from your dashboard and choose Guests & RSVPs.
2. 2Choose Import.
3. 3Pick your file.
4. 4On a published invitation, tick E-mail the invitation now if you want everyone e-mailed as they land.
5. 5Confirm. The toast reads "Imported N guests".

Re-importing is safe

Existing guests are matched on e-mail or phone and updated: the name, e-mail and phone are refreshed, the group changes only when the row gives one, and passes set by hand are kept when the row has no passes value. Nothing is duplicated, so you can fix the spreadsheet and import it again.

Addresses that cannot receive mail

The toast lists any address whose domain does not exist or looks mistyped ("[email protected] (did you mean [email protected]?)"). Those guests are still imported; fix the address in the list, or reach them on WhatsApp. More in guest e-mail checks.

If the import fails

• "Choose a CSV or Excel file": the file type was not recognised.
• "Couldn't read that file": export it again as CSV or .xlsx and retry.
• "No rows with a Name column were found": check the header row.