Download event guest list csv file/spreadsheet

On the event settings page there are a couple of ways of downloading the guest list and seeing all the guest data.  

On the main event settings dashboard you can choose to view or download your guest list directly to a spreadsheet/csv:

If you choose to view the guest list you can then also filter the list to see different categories of tickets and download a list of purchasers.

You can also look at any purchaser on Classlist and see the details about each of their ticket holders:

What info will you get?

• When you create your event you can ask as many questions as you like about guests
• Each question you ask will appear in a separate column in the spreadsheet/csv download.
• Each ticket is a single line in the spreadsheet so you can see all the details for each guest
• (Whereas in some systems the purchaser can only add one set of comments for a total purchase, not per guest.  That means in other systems that it may not be easy to specify exactly which guest has a nut allergy or wants vegan food etc).
• If the purchaser is not a Classlist member their email address appears in the spreadsheet and on the Classlist guest list.  Guest checkout purchasers get e-tickets and reminders automatically. 
• The classes of the children of Classlist members are autofilled in the spreadsheet to make it easy for you to know who is coming.  For guest checkout purchasers we don't have this information so it will not show in the spreadsheet unless they registered after buying a ticket.
• Ticket value and transaction total are shown
• NB As each ticket is a single line in the spreadsheet the total shows several times for each 'purchaser' if they bought several tickets.  That is due to the way csvs are generated.
• The guest list on Classlist itself shows each purchaser listed in date order, newest at the top, with all details for every ticket there as well.

The columns in the spreadsheet are as follows.  3 questions were asked here but you could ask as many as you like:

Stripe - A few things to note:

• Stripe does take fees from the ticket price - i.e. the transaction values in Stripe will be lower than the amounts shown in the downloaded spreadsheet. The total purchase value for a transaction in Stripe will relate to the total for each purchaser on the spreadsheet, less the Stripe fee
• In Stripe each purchase will be listed as a transaction, and it states the event name too.  So it is easy for you to see which list of transactions in Stripe relate to which event and transfer them out.  
• The guest list on Classlist itself shows each purchaser listed in date order, newest at the top for cross reference if you need it
• If you click on a transaction in Stripe you can see the fees taken for that transaction so it is very clear what you are receiving.
• Tickets are only issued on Classlist if payment is confirmed by Stripe or Paypal.  ie Purchasers will not have tickets if they didn't pay!

Our new and improved guest checkout process means that after buying a ticket guest checkout purchasers are asked if they are a parent and then given the option of registering for Classlist directly.  {Previously they were not asked if they wanted to register after guest checkout as it was aimed mainly at you selling tickets members of the public}.

Now this means that if you are just starting out on Classlist and don't have any members yet you can just share details of the event across your other comms systems and ask parents to register after they buy a ticket. 

ie we are integrating the two processes of guest checkout and Classlist registration so that you can launch an event without needing any Classlist members!

See - Setting up Stripe to take event payments

Troubleshooting: My csv file downloads as html

We had another couple of reports of csv files downloading as html files in Safari - and when you open them it is a jumble of letters and numbers.

This is because Safari is sometimes adding .html after .csv in the file name.

If this happens you can  open the file without issue if you go to Finder and edit the file name to remove .html from after .csv 

On investigation our developers found this issue relates to Safari and we can't fix it the issue - i.e. it is a Safari bug not a Classlist bug.  It isn't happening on the latest version of Safari, only on earlier versions and so it shouldn't happen after you upgrade Safari.