Managing and understanding your guest list CSV

When an attendee buys a ticket to one of your events, the details of the order are collected in a handy .CSV spreadsheet that you can download from your event dashboard, edit, and use as a guest list.

The information that's collected includes the attendee's:

  • Name
  • Email address
  • Order number
  • Any answers to additional ticket options/questions you've added to your tickets
  • Discounts received
  • Order time 

When your event is over, if you've used our scanner app, you can download the document again and this will show you which tickets were scanned and which weren't.

If you've included a lot of additional options, this could make the CSV appear confusing very quickly! This help article runs through a few ways to organise the CSV, and explains what the columns mean.
Downloading your guest list .CSV: 
  • From your event dashboard, in the 'Tools' section, click 'Download guest list CSV'
  • If you have a multiple date event you can download date specific CSVs by selecting the date you want it for, using the dropdown menu at the top of the 'Options & Info' box

  • Now your CSV is downloaded, you can open it with Excel, Google Sheets or similar programs

Managing and editing your guest list .CSV: 

  • Import your document to your chosen program 
  • Columns may be condensed to fit to screen, you can change this by highlighting the columns you want to resize and using the program's 'format' options to resize to fit data or expand single columns by dragging or double clicking on the column divider 

  • You can organise your columns depending on your preference - alphabetically by attendee name, order date, or even ticket type. To do this, make sure the title row is "frozen" so it isn't included when organising the data. Select the entire sheet by typing Ctrl + A (Windows) or Cmd + A (Mac) and then select the ‘sort & filter menu’ and choose which order you’d like the sheet to be organised by 

  • It's best to check over the data on your CSV when sorting is complete to make sure all is okay and matching as it should be
  • To remove unwanted columns and information, click on the corresponding letter of the column to highlight it, right click and select 'Delete Column"

  • Some information may look as though it's duplicated (such as ticket buyer names and ticket holder names). Before removing any of these, it's best to make sure the names aren't different and the ticket buyer may have bought the ticket for the ticket holder- the ticket holder is usually the person attending the event! 
  • When you've completed your editing and you have the information you need, just save and/or print the document and you're ready to use it!
Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.

Still need help? Contact Us Contact Us