Skip to main content
Exporting data to .csv files

Feed data from your Bookwhen account into other systems using .csv files

Anni avatar
Written by Anni
Updated this week

CSV files organise information in a table format. You can open them with your chosen spreadsheet software like Excel or Google Sheets. This format is useful for tasks like importing lists into services such as Mailchimp.

You can export three different sections in .csv format:


Attendances

The attendance report contains all attendee information, including

To download the attendance report:

  1. Select Bookings from the left-hand menu on your account.

  2. Add any relevant search filters and select Search to generate the results.

  3. Select Options, then Export attendances (CSV):

    Bookings tab with an arrow pointing at the 'Export bookings' option

  4. This file shows all attendances from the period defined by the selected search filters (Start date and End date).


Bookings

The bookings report contains all booking details, including booking status, payment details, booker email and booking form responses.

To download the bookings report:

  1. Select Bookings from the left-hand menu on your account.

  2. Add any relevant search filters and select Search to generate the results.

  3. Select Options, then Export bookings (CSV):

  4. This file shows all bookings from the period defined in the selected search filters (Start date and End date).



Customers

The customer report contains all customer information including:

  • Email and full name

  • Child status

  • First booking and attendance

  • Latest booking and attendance

  • Total bookings and attendance

  • Pass information

  • Booking form responses

To download the customer report:

  1. Select Customers from the left-hand menu on your account.

  2. Add any relevant search filters and select Search to generate the results. To download information for all of your customers, leave the filters blank.

  3. Select Options, then Export customers:

    Customers tab with arrow pointing at the 'Options' button and the 'Export customers' option

  4. This file export shows information on all the customers that match the filters you have applied.

How schedule pages appear in reports

Sometimes, entries may appear on a different schedule page than expected in your report. This happens because baskets can include tickets from multiple pages, but the report assigns the booking to the page where checkout began—even if the customer added tickets from other pages first.

Even if you delete a schedule page, the system keeps the booking data to maintain an accurate audit trail.


💬 Any questions or feedback? There are two ways to get in touch:

Thank you! 🕺

Did this answer your question?