How can I export visitor data?

CM
CM
Updated 2 weeks ago

The dashboard offers the possibility to export all your visitor data to excel.

  1. Go to Analytics > Visitors
  2. Click the download icon to export the data 
  3. You can choose to export data per attendee or per order. The difference here is that an order may contain several tickets (attendees). 
  4. You can open the downloaded CSV file in excel 

The data are currently still one line in a row. These can be converted into columns using the steps below: 

  1. Open the CSV file in Excel. 
  2. Arcade the entire A column by clicking on the letter A at the top of the column. 
  3. Click on 'Data' in the top menu bar. 
  4. In the 'Data' menu, choose 'text to columns'. 
  5. In the open window, select 'separated' and [next]. 
  6. In the next window, select 'comma' and [next]. 
  7. In the next window, choose 'Standard' and click [Finish].