How to export participant data from Agora on Event
- Go to event and open “Attendees”.
- Sort by registration date/time so that the list starts with the first registration.
- Select all registered persons by clicking on the box next to “Registration Date”.
- Click on “Action” and select “Export”.
- Remove any additional fields by clicking on the trash can and export data for fields “Attendee name”, “Created on” and “Email” by clicking on “Export” in the bottom left corner of the pop-up.
- Copy the participant names, registration dates and email addresses from the generated Excel file and paste to the participant overview on Google Sheets.
- Add the session number in column B for the participants. E.g. 05 for the fifth session of the Unite! Networking Hub.
- To be able to export the additional information from the registration form, go back to the event overview and select the tab “Questions”.
- Now you can see all questions from the registration form. Click on the symbol for “Answer Breakdown”
- Change to “List” view in the top right-hand corner.
- Select all registered persons by clicking on the box next to “Registration”.
- Click on “Action” and select “Export”.
- Export suggested fields for answers for the selected question.
- Copy and paste information from generated Excel file to the participant overview on Google Sheets.
- Repeat steps for each of the answers that are required for the participant overview on Google Sheets.
Type
Rich text
User
Admin
Level
Advanced
Acceleration Service
Events
Description
- Go to event and open “Attendees”.
- Sort by registration date/time so that the list starts with the first registration.
- Select all registered persons by clicking on the box next to “Registration Date”.
- Click on “Action” and select “Export”.
- Remove any additional fields by clicking on the trash can and export data for fields “Attendee name”, “Created on” and “Email” by clicking on “Export” in the bottom left corner of the pop-up.
- Copy the participant names, registration dates and email addresses from the generated Excel file and paste to the participant overview on Google Sheets.
- Add the session number in column B for the participants. E.g. 05 for the fifth session of the Unite! Networking Hub.
- To be able to export the additional information from the registration form, go back to the event overview and select the tab “Questions”.
- Now you can see all questions from the registration form. Click on the symbol for “Answer Breakdown”
- Change to “List” view in the top right-hand corner.
- Select all registered persons by clicking on the box next to “Registration”.
- Click on “Action” and select “Export”.
- Export suggested fields for answers for the selected question.
- Copy and paste information from generated Excel file to the participant overview on Google Sheets.
- Repeat steps for each of the answers that are required for the participant overview on Google Sheets.