Update Speaker Details in Bulk Through CSV Upload
If you've already added your speakers to the event and you have additional information to include in their profiles, or you need to assign them to existing sessions, you can upload a CSV instead of manually updating each speaker.
1. Download the Speaker List with Speaker ID
Go to Event Content > Speakers
Click Actions > Export Speakers
2. Remove the Speaker Ticket Column from the File
The CSV format to update speakers is the same as the CSV format for importing new speakers. The file you downloaded has an extra column for Speaker Ticket, so just delete that to have the proper number of columns and labels.
Open the file for editing (Google Sheets, Excel or Numbers preferrably)
Delete the Speaker Ticket Column from the file
3. Add the Sessions IDs to the Sheet to Assign Speakers to Sessions
When you download the file and speakers are already assigned to sessions, the Sessions IDs will be included in the file.
Check and adjust the commas, sometimes it adds commas after every 3 numbers depending on which application you're using like Google Sheets.
If you want to assign them to sessions, you'll need to get the Sessions IDs and add them to the Primary Sessions and Secondary Sessions columns. To get the Sessions IDs:
Go to Event Content > Agenda
Copy the numbers in the Session ID column
Or select Actions > Export Sessions to download the CSV with all the Sessions IDs
Add the Session ID to the Primary Sessions column if you want them to be added as moderators, and if not, then add it to the Secondary Sessions column.
If they will be assigned to multiple sessions, the Sessions IDs must be comma separated. To do this properly when formatting in Google Sheets:
Select Format for the menu
Select Number
Select Plain Text
Add the Session ID to the cell, add the comma, then add the next Session ID
4. Update the Other Information to the Sheet
Enter the other new information in the sheet.
Notes:
All column headers are required.
Values are required for Speaker Id, First Name, Last Name, Email
You cannot change the existing email address
If you leave a column blank (e.g. Company) and there's already existing information in the speaker profile, the existing information will be deleted after the upload.
If you’ve created custom speaker properties, ensure that the property labels exactly match the header columns in your Speaker CSV, and they should be added after the required column headers.
5. Upload Your Speaker CSV
Convert your sheet to CSV and upload it.
Go to Event Content > Speakers
Click Actions > Import Speakers
That's it! You'll get a success message after the speakers are updated.
If your format is incorrect, you should see corresponding error messages. Review your sheet thoroughly and make adjustments to your file based on the errors.
If it's cell specific format issue, you'll be able to correct the issue directly from the upload pop-up. Just scroll to the right to see the error message and click Edit to update the format in the cell.
