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

Open the event, Participants tab.
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.

What the file contains

One row per attendee, with these columns, in this order:

Column	Content
firstname, lastname, email	First name, last name and email, for an event with ticketing.
Your fields	One column per field, with its exact name and in the order of the table: your custom fields and those added by your extensions, or the columns of your file for an event created by import.
Ticket	The name of the attendee’s ticket. Empty for an event created by import.
Checked in	“Yes” if the person is present, “No” otherwise. See Check attendees in.
Created at	Date and time the attendee was added: for a buyer, when their order was confirmed.
Updated at	Date and time of the attendee’s last change.
Refunded	Date and time of the refund if the ticket was refunded, empty otherwise. See Refund a ticket or an order.

Every field has its column, even if it is only filled in for some attendees: the cell is then left empty for the others.

Checkboxes show as “Yes” or “No”. Dates follow the format of the language chosen in the dashboard, and times are those of your computer.

Open the file in a spreadsheet

The file is a comma-separated CSV, encoded in UTF-8: accented characters display correctly, including in Excel.

Google Sheets: use “File”, then “Import”, and choose the file.
Excel: open the file with a double click. If all the values appear in a single column, import it instead from the “Data” tab (import from a text or CSV file), choosing comma as the separator.