Checkin Reports are available according to the Action Categories and Values that have been set for a particular event.
Until further development on Checkin is undertaken to provide a direct download service, the data from Checkin can be pasted into a Wordpad note, then imported into Excel, steps are provided below.
| 1 | Open Checkin by clicking the green tick next to the Event title
|
| 2 | Click Reports on the top menu. A list of reports appears
Reports contents will be determined by the Action Categories and Values that have been set for this event |
| 3 | Click a report link
Blue link = Action Category report, shows all values (usually, attendees) within that category Green link = Action Value report, shows all attendees recorded with that value/flag |
| 4 | Select the text in the table. Open Notepade and paste the text, save the file
|
| 5 | Open Excel, open a blank worksheet. On the Data ribbon, select Get External Data, select From Text
Navigate to the text file, click Import |
| 6 |
Note the column arrow shown above appears to be incorrectly placed (too far to the right of the surname's first letter), however it yields the required result |
| 7 |
2. Import data window appears, set the data to be imported into the Existing worksheet, click OK. 3. Data is shown in the worksheet.
|
Tip - To convert the data into a table, select the active cells, press Ctrl+T