Creating an Event Speakers File

In this topic you will learn how to create an event speakers file that can be uploaded to initially populate speaker information for a Virtual Event Experience.

You may have created a list of event speakers in a third-party tool, for example, Microsoft Excel or Google Sheets. The Agenda module provides the ability to upload a .csv file of event speakers. Once the speakers file is uploaded, speaker information can be edited using the Agenda module.

Column naming requirements

When creating the speakers file, you can download a sample speakers template from the Speakers page and edit it or use an existing speakers file you may have created. The Agenda module looks for the existence of specific column names. These columns will be mapped to the appropriate speaker fields. Other columns that may be in your speaker file will be ignored during import. In order to upload a speaker file, the following columns are required:

  • first_name - Speaker first name
  • last_name - Speaker last name

The following columns are optional, but if they exist in your speakers file, they will also be imported:

  • id - Cannot be user defined. This is the ID that would be populated if the user exported a list of speakers as a CSV. This is used to update existing entries in the database.
  • email - Speaker email address
  • title - Speaker title
  • company - Speaker company
  • bio - Speaker bio
  • image - Speaker image

When you are ready to import your speakers into the Agenda module, export it as a .csv file. The Agenda module can only import a .csv file. For information on how to upload your speakers file into the Agenda module, see Managing Event Speakers.