Export ticket sales to Excel

Updated on

On the Ticketing page you can export your ticket sales to Excel. You can do this for all events in a period you choose, for example a quarter for your treasurer, or for a single event when you want that event's buyers.

Step 1: Open the export window

Go to Ticketing and click Export at the top of the page. The Export ticket sales window opens.

Step 2: Choose the period

Pick a period with the date field, or click a shortcut: This quarter, Last quarter or This year. An event falls in the period on the day it starts. The start and end date both count.

Below the period you immediately see which events fall in it, with the revenue and number of tickets per event, and the total at the top. If no event falls in the period, there is nothing to download.

Step 3: Include the buyers (optional)

Want to know who bought tickets as well? Switch on Include the buyers per event. The file then gets an extra sheet listing all buyers.

Step 4: Download the file

Click Download. You get an Excel file with:

  • Overview: per event the date, the online revenue, the revenue at the door, the total revenue, the number of paid and free tickets, the capacity, the occupancy and how many people checked in. A total row sits at the bottom.
  • Buyers (only if you switched it on): per order the event, the date, the ticket type, the name, the email address, the number of tickets, the amount, the payment method and whether the buyer checked in.

The revenue and amounts are what was actually paid, including extras sold. Test payments are not counted.

The buyers of one event

Next to the name of each event in the table there is a download button. It downloads the buyer list of just that event, with a sheet per ticket type and the answers to your ticket questions. You will find the same button, Export ticket sales, in the statistics that open when you click an event in the table.

Frequently asked questions

Who can export? The Ticketing page is for system administrators. Any system administrator can download the overview for a period. You only see the buyers, in the period export and per event, if you are also an admin, because they include names and email addresses.

Why are the answers to ticket questions not in the period export? Every event has different questions, so the columns would differ per event. Use the download per event for the answers.

Does an event spanning two days fall in the period? Yes, as long as its first day falls in the period.

Was this helpful?

Related articles