CSV Export
CSV Export
When you need attendee data outside of WordPress — for a spreadsheet, a CRM import, a printed check-in list, or an end-of-event report — the CSV export pulls exactly the data you are looking at in the admin and downloads it as a file. Filters apply to the export, so you get precisely the attendees you need without post-processing.
Exporting Attendees
- Navigate to Events > Attendees in the WordPress admin.
- Apply any filters you need: event, ticket type, status, refund status, security code, or name/email search.
- Click the Export CSV button above the attendee table.
- Your browser downloads a CSV file immediately.
The export includes every attendee that matches your current filter criteria. If no filters are active, you get all attendees across all events.
Exported Columns
Every CSV file contains the same set of columns in this order:
| Column | Description |
|---|---|
| ID | The attendee post ID |
| Name | Attendee’s full name |
| Attendee’s email address | |
| Event | The event title |
| Ticket | The ticket type name |
| Status | Current attendee status (pending, completed, checked_in, etc.) |
| Security Code | The unique security code for this attendee |
| Checked In | Whether the attendee has been checked in (Yes/No) |
| Date | When the attendee record was created |
File Naming
Downloaded files follow the naming pattern:
attendees-2025-03-15.csvThe date portion reflects the day you performed the export, not the event date. If you export multiple times on the same day, your browser handles duplicate filenames according to its own conventions (typically appending a number).
Filtering Before Export
The export is filter-aware. Whatever you see in the admin table is what ends up in the CSV. Common export scenarios:
- Single event roster — set the Event filter, then export. You get a clean attendee list for one event.
- Checked-in attendees only — set Status to
checked_inand export. Useful for post-event attendance records. - Pending payments — set Status to
pendingto export attendees who have not yet completed payment. - All VIP attendees — set the Ticket filter to your VIP ticket type and export across all events.
- Refund candidates — use the Refund Status filter to export attendees with pending refund requests for offline review.
You can combine multiple filters. For example, filtering by both a specific event and the completed status gives you only confirmed attendees for that event.
Working with the CSV
The exported CSV uses standard comma-separated formatting with UTF-8 encoding. It opens directly in:
- Microsoft Excel — File > Open, or double-click the downloaded file
- Google Sheets — File > Import > Upload, select the CSV
- LibreOffice Calc — File > Open, select the CSV
- Numbers — File > Open, select the CSV
The first row contains column headers. Data starts on row 2.
Common Questions
Can I customize which columns are included in the export? No. The export always includes the full set of columns listed above. If you need a subset, open the CSV in a spreadsheet and delete the columns you do not need.
Is there a limit on how many attendees I can export? No hard limit. The export generates the file server-side and streams it to your browser. For very large events (thousands of attendees), the download may take a few seconds longer.
Can I export attendees for multiple events at once? Yes. Clear the Event filter (or do not set one) and all attendees across all events are included. You can then sort or filter by the Event column in your spreadsheet.
Does the export include attendees in terminal states like refunded or cancelled?
Only if your current filter includes those statuses. If you set Status to refunded, the export contains only refunded attendees. If no status filter is active, all statuses are included.
Can I schedule automatic exports? Not from the admin interface. If you need automated exports, you can call the export endpoint programmatically using WordPress admin AJAX with appropriate authentication.
Why do I see different attendee counts between the table and the CSV? The table paginates by default. The CSV export includes all matching attendees regardless of pagination. The CSV count matches the total shown at the top of the attendee table, not just the current page.
Next Steps
- Attendee Management — the full admin interface where filtering and export happen
- Check-In — use exported lists as offline check-in sheets at your event
- Attendee Lifecycle — understand what each status value means in your exported data