Export your guest list
Export on the Attendees page downloads every ticket on the event as a CSV, whatever search or filter you have on, with one column per checkout question.
Export on the Attendees page downloads the event's whole guest list as a CSV file you can open in Excel, Numbers or Google Sheets. It has one row per ticket.
Export it
- 1In the event, open Guests → Attendees.
- 2Click Export. A file named after the event and today's date downloads.
The button is off until the event has at least one ticket.
Which filters it respects
None. The file always holds every ticket: Going, Pending approval and Not going, whatever search, status tab, ticket filter or sort is on screen. Filter in your spreadsheet with the Status and Checked In columns.
What's in it
| Column | What it holds |
|---|---|
| First Name, Last Name | The ticket holder. An unnamed ticket says "Unnamed ticket". |
| Email, Phone | The holder's. Blank on an unnamed ticket, which only carries the buyer's. |
| Order # | The order's id, which ties every ticket on one order together. |
| Ticket Type, Bundle | The ticket type, and the bundle it came in, if any. |
| Status | Going, Pending approval or Not going. |
| Checked In | Yes or No. |
| Date Registered, Checked in on, Not Going Since | When each happened. |
| Amount Paid | What the buyer paid for the ticket after any discount, including any part above its fair market value. |
| Fair Market Value, Tax Deductible | The ticket's declared value, and the price above it. Both blank when no value was declared. |
| Attribution | The host link or promo code the order was credited to, or Direct. |
| One column per question | Each checkout answer. An order question's answer fills every ticket on the order. |
Good to know
- Dates are in your computer's time zone.
- Accented names come through intact in Excel.
- When a buyer pays more than a ticket's fair market value, Ovante books the part above it as a gift. The export still shows the whole price in Amount Paid, and that part in Tax Deductible. See Gifts above a ticket's value.
- For money across all your events, the Transactions page has its own download, which follows that page's search, filters and columns.
Was this helpful?
Related
The Attendees pageYour door list. One row per ticket holder, status counts that filter the list, a ticket filter, seats against capacity, and Export.The Transactions pageEvery order across all your events in one table, with filters for date, amount, event, status and type, and a page for each transaction.Attendee statuses and check-inEvery ticket is Going, Pending approval or Not going. Whether it's checked in is a separate fact, shown as Yes or No.Gifts above a ticket's valueWhen a buyer pays more for a ticket than its fair market value, Ovante books the ticket at its value and the rest as a gift. The buyer still sees the full price.