Versions Compared

Old Version 2

changes.mady.by.user Former user

Saved on

compared with

New Version 3

changes.mady.by.user Former user

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

1
  1. In Events, click Reports
  2. Select an Event from the drop-down list (or leave blank to create a report for all your events)
  3. Select a Report type from the drop-down list (e.g. Registration Data Export)
  4. Click Download. A CSV file is generated.
  5. Click to open the downloaded file (screen may vary according to the browser used, Firefox shown below)

Image Modified


Reports available:

Image Modified

(info)Tip - the Registration Data Export provides all information associated with a completed registration, it is one of the most popular reports to use when managing an event

2

Open the CSV file in Excel (or other spreadsheet program).

Image Modified

3

Registration Data Export notes

  • Minimum of two lines are shown per registration (yellow highlight in screenshot above). First line shows payment details, for the whole registration. Second line shows the first attendee's name together with all of their selected tickets and responses to questions. If two or more persons have registered, their details will be shown in rows (one per attendee) under the first attendee's row.
  • IsAttending and IsPaid fields use 0 to indicate 'no' and 1 to indicate 'yes'.
  • Columns A to N show attendee contact details, columns O to V contain registration and payment details, column X onwards contain tickets from the event page (sorted alphabetically by ticket name in v2, or by form order in v1), and then questions (same sorting as tickets).
4

Excel tips for efficient use of the Registration Data Export

  • To quickly convert the data into a table, select all cells, press Ctrl+T.
  • To hide a column (e.g. blank column C), right-click over the column letter and select hide
  • Cell value shown as #### indicates the column is not wide enough to display the value, click on the right edge of the column letter and drag the column wider.