Export attendee data
Use this article when you need an attendee file for an event day, a caterer, a partner, or a reconciliation — as CSV or Excel.
Before you start
- You need a role that allows viewing attendees and creating data exports (the Data exports permission).
- Decide which event, date range, and attendee states the file should cover.
- Decide whether the recipient needs customer contact details and question answers, or only ticket-level data.
Filter the list first
- Open Sales > Attendees.
- Use the filter to narrow the list. You can filter by events, event templates, admissions, orders, tags, points of sale, and order channels, and by attendee state with Checked in / Not checked in, Counts toward capacity / Does not count toward capacity, and Signed waiver / Has not signed waiver.
- Add a Date filter and choose the date basis: Visitor date, Booked, Created, or Ticket scan, with presets such as Today, This week, or Custom.
Export the file
- Select the download icon in the attendee list header.
- Select Export data (Excel) or Export data (CSV).
- The export is prepared in the background. When it is ready, select Download export to save the file.
What the file contains
The export has one row per attendee. Columns include:
| Group | Columns |
|---|---|
| Service | Service number, Service name, Start time, End time, Time zone, UTC times, Service tags |
| Ticket | Price name, Ticket numbers, Attendee name, Check-in status, Capacity impact |
| Order | Order Number |
| Customer | Columns prefixed with "Customer:", such as customer number, first and last name, email, mobile, telephone |
| Waiver | Signatory name and, for minors, the minor's name |
When your account collects questions during checkout, the answers appear as additional columns prefixed with "Attendee:", "Booking:", or "Customer:" depending on where the question is asked. On accounts without the questions feature, booking answers appear in an "Additional information" column instead.
Expected result
You have a CSV or Excel file containing only the filtered attendees, with ticket, check-in, customer, and answer columns.
Troubleshooting
| Problem | What to check |
|---|---|
| No export option visible | Your role's Data exports permission. |
| Export contains too many rows | Active filters — clear the search text and re-apply the event and date filters before exporting. |
| Customer columns are empty for some rows | POS sales without a linked customer, and personalized tickets where only attendee data was collected. |
| Question columns are missing | Whether the question is asked for this event, and whether any filtered attendee answered it. |
| Counts differ from a report | Date basis (Visitor date versus Booked), check-in and capacity filters, and canceled orders. |