Check-in Reports - downloading to Excel

1

Open Check-in by clicking the green tick next to the Event title

Open

2

Click Reports on the top menu. A list of reports appears

Open

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

1. The Text Import Wizard commences, select Fixed width and click Next.

2. Adjust the column width (black arrow) in the data preview if necessary, click Next

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

1. Set the column data form to General (usually is the default), click Finish.

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