Importing Attendees
Import an attendee file by going to Data Imports > Importer > Click the Create Import button > Select Attendee Import from the dropdown
This will pop a modal up where you can download a CSV template. If you are updating existing attendees, you can also do an export from the attendee list table to pull down the existing information (along with their correct column headers).
The columns email, first_name and last_name are required in all imports.
All other columns are optional. For example, if you only need to update the bio field, your import can contain only first_name, last_name, email, and bio with all other columns removed.
This can be used to create new attendees as well as update existing attendees. If a new email address is found, the importer will create a new attendee record. If the email address is an existing one in the event, it'll update the existing record.
Tips:
- If you are importing attendees who have special characters in their name, or anywhere in their profile, save your excel sheet as a .xls or .xlsx instead of .csv to preserve the special characters.
- The password column will never export, but it is available for you to use. Simply create a new column, give it a column header of password and enter whatever passwords you want to bulk update attendee passwords.
- Sometimes, if your event contains attendees who have been added to other events in the past, and you want to start everyone with a default password that they will need to reset, you may need to wipe the password_updated_at column. You can do this via an import by leaving that column blank.