Managing and Understanding your Guest List CSV
When an attendee completes an order to one of your events, the details of the order are collected in a handy .CSV spreadsheet document that can be downloaded from your event dashboard, edited if desired and used as a guest list.
The default information that is collected such as the attendee's name, email address and order number will be included but the document will also include any answers to additional ticket options/questions you have added to your tickets, discounts received, even the order time. And when your event is over, if you have used our Scanner App, you can download the document again and this will show you which tickets were scanned and those that weren't.
- 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 simply 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 (mentioned above)
- Columns may be condensed to fit to screen, this can be changed by highlighting the columns you want to resize and using the programs 'Format' options to resize to fit data or expand single columns by dragging or double clicking on the column divider
- Columns can be organised depending on your preference - this can be alphabetically by attendee name, order date or even ticket type. To do this, ensure the title row is "frozen" so that it isn't included when organising the data. Then 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 ensure all is okay and matching as it should be
- To remove unwanted columns and information, simply click on the corresponding letter of the column to highlight it, right click and select 'Delete Column"
- Some information may look as though it is duplicated, such as ticket purchaser names and ticket holder names. Before removing any of these, it's best to ensure the names aren't different and the ticket holder may have had the ticket bought for them by the purchaser - the ticket holder is usually the person attending the event!
- When you have completed your editing and you have the information you need, just save and/or print the document and you're ready to use it!