You can download your bookings as a CSV file. A CSV file opens in Excel, Google Sheets, or Numbers.
There are two kinds of export:
- All bookings in a date range: for reports or bookkeeping.
- Everyone booked for one event: a guest list for a class or tour.
The Export tab shows only in List View. If you do not see it, click List View at the top of the Bookings page. Agenda View, Calendar View, and Availability View do not have it.
Export bookings for a date range
- Click Bookings in the app menu.
- Click List View, then click the Export tab.
- Under Export Bookings by Date Range, choose the first and last date.
- Click Export Bookings. The file downloads as
export.csv.
One export covers up to 30 days after the first date. After you choose the first date, later dates are grayed out. For a longer period, make one export for each month.
The export includes a booking if its appointment starts in the range, in the timezone shown next to Selected range. Cancelled bookings are included. Use the status column to find them: it says cancelled.
Columns in the date-range export
| Column | What it holds |
|---|---|
id | The booking ID |
event.name | The service name |
firstName, lastName | The customer's name |
contactEmail, contactPhone | The customer's email and phone |
price, quantity | The price before tax, and the number of people |
orderId, orderName | The Shopify order, such as #1042 |
availability | The team member or availability |
date.startDate, date.endDate, date.timezone | When the appointment starts and ends, and the timezone |
shippingAddress | The shipping address, or "n/a" |
orderProperties | The answers to your intake questions, in one cell |
details.orderDetails | More details from the order |
internalNotes | Your internal notes |
createdAt | When the booking was made |
status | cancelled for a cancelled booking. Empty for an active one |
Export the guest list for one event
- Click Bookings in the app menu.
- Click List View, then click the Export tab.
- Under Export Attendees for an Event, choose the event.
- Click Export Attendees.
This file lists each customer once, with the columns firstName, lastName, email, phone, timezone, totalBookings, firstBookingDate, and lastBookingDate. It leaves out cancelled bookings. The two date columns show when the customer made their first and last booking, not the appointment dates.
Print the guest list before a class or tour, and tick names off as people arrive. To record attendance in the app instead, see Check in customers and mark no-shows.
If the Export tab says exports are disabled
If you see "Booking Exports are temporarily disabled", exports are turned off for your store. Contact support from the chat in the app. The support team sends you the export.
Export your waitlist
The Waitlist page has its own Export button. See Let customers join a waitlist.