Export the attendee list

The export gives you a CSV file with all the event’s attendees: to prepare a paper door list, send it to a partner, do your own counts or keep a record before deleting an event.

Download the file

1. Open the event, Participants tab.

2. To the right of the “Search for a participant…” field, click the button with the download icon.

The file downloads right away. It is named after the event, for example SUBSOL Opening Night.csv.

If the event has no attendees yet, the button does nothing.

Reload the page before exporting

The export uses the list as it was loaded when the event opened. Reload the page just before to include the latest sales, the latest door scans and the ticket of attendees you have just added or edited.

The export ignores the search

The file always contains all the event’s attendees, even if you typed a search above the table.

What the file contains

One row per attendee, with these columns:

Column	Content
firstname, lastname, email	First name, last name and email, for an event with ticketing.
Your fields	One column per custom field, or per column of your file for an event created by import, with the exact field name.
ticketName	The name of the attendee’s ticket, or “undefined” if they have none (the case in an event created by import).
sign	“true” if the person is present, “false” otherwise. See Check attendees in.
createdAt	Date and time the attendee was added: for a buyer, when their order was confirmed. French date format, Paris time.
updatedAt	Date and time of the attendee’s last change. French date format, Paris time.

The data columns are those of the first attendee in the list, and their order may differ from the table. If some attendees have fields the first one does not, for example a field filled in by an extension, those fields may be missing from the export.

Open the file in a spreadsheet

The file is a comma-separated CSV, encoded in UTF-8.

• Google Sheets: use “File”, then “Import”, and choose the file.
• Excel: if accented characters or columns look wrong when you open the file with a double click, import it from the “Data” tab (import from a text or CSV file), choosing UTF-8 encoding and comma as the separator.

Before deleting an event

Export the list: once the event is deleted, its attendees cannot be recovered. See Duplicate or delete an event.

See also

• View and manage your attendees
• Turn attendees into an audience, to reach them again in your next campaigns.