📖 Speakers | Stage 4

Speakers: Import & export speakers

Learn how to import and export speakers through a csv file.

To be covered

Intro

We understand, that updating speaker by speaker will be a time taking task if there are many speakers at the event. This is why the Brella application supports .csv file upload. You can easily put together a list through excel and import this file to add multiple speakers within a couple minutes.

Prepare .CSV file

  • Download or set up the excel template as guided below

    • External ID - optional - This code helps your track these speaker details from another software.
    • First name - mandatory
    • Middle name - optional
    • Last name - mandatory
    • Honorific - optional
    • Job title - optional
    • Company name - optional
    • Bio - optional

Import Speakers (steps)

  1. Navigate to the Admin Panel - People - Speakers
  2. Click on Import Speakers.
  3.  Refresh the page.
  4. Now you can start adding additional details, including speakers profile images.
    • A default avatar image will be added if the speaker doesn't have a profile image added

Export speakers list:

By exporting the speakers list, you can easily update multiple speaker profiles through the file. Remember when updating the Speakers list, that it must include the existing ID (not the external ID) aligned with the right speaker details, so you don't create duplicates. 

  1. Navigate to the Admin Panel - People - Speakers.
  2. Click on export the Speakers list.
  3. From the file, remove the profiles you don't want to update and leave only the profiles to be updated.
  4. Make the respective changes, and save it as in csv format.
  5. Go back to the Admin Panel, and import the file. The changes should reflect on the panel; if not, please refresh your page.

Resolving .csv file issues 

    If the system gives and error when trying to upload the CSV file please check these details :

      1. When saving a spreadsheet in Excel as a CSV file, it may separate the values with semi-colons ( ; ) instead of commas (,). Brella only recognizes comma-separated (,) CSV files, so if you import a CSV that separates the values with a semi-colon, you will not see the number of assigned seats. Unfortunately, as this is an Excel issue that can't be changed, we strongly recommend using Google Sheets or OpenOffice, with which you can choose what the separator (comma instead of the semi-colon) is.
        • CSV files saved with semi-colons will not be uploaded and will receive this error. To change semicolons to commas, see point 4.

      2. If you exchange lists with colleagues located in different countries, we highly recommend using Google Sheets or Open Office to import/export, as some countries use (.) instead of (,). 
      3. Ensure that none of the CSV file fields include commas or other signs within the speaker information! If an attendee's title is "Customer Success Manager, EMEA," these attendees will not be imported nor generate join codes for them. Change the attendee's title from "Customer Success Manager, EMEA" to "Customer Success Manager - EMEA" to import to work optimally.
      4. Make sure the speaker's information does not contain commas. Since the CSV file separates the different fields with commas, commas can cause errors. Before uploading the CSV file to Brella, double-check if you have commas (,) within your attendee information fields. It can be done in Google Sheets by going to Edit > Find and replace > then replacing the "," (commas) with a "_" (space).
      5. If you cannot use any of the software mentioned above, there is another workaround! 👍 Follow the next instructions:
        • Open the CSV file in Text Editor. Check text edit to ensure that there are no semi-colons by clicking right-click > Open with Text Edit. App> then Ctrl/Cm+F > then click Replace like in the image below. If there are semi-colons instead of commas, replace them. Now you will be able to import the file

      6.  If the CSV has logos to be added and the file doesn't get imported, make sure the logo URLs added on the CSV contain only image files (png, jpeg, etc.).

      Download the speakers template .csv file here 

       

      We look forward to your event and wish you a successful event!


      Last updated - July 2022. 

      Written by Natasha Santiago. 

      natasha-rounded

      If you didn't find an answer to your questions, please get in touch with the Support Team here.

      👇