SpeakerTravel Documentation

Travellers - Import

Have multiple travellers to invite? Import them from an Excel (XLSX), CSV, or tab-delimited text file. Importing from call for papers tools such as Sessionize.com is possible, too.

We can invite travellers by entering their details directly, or by importing them from an Excel (XLSX), CSV, or tab-delimited text file. Both approaches can be initiated from the travellers page.

On this page:

Step 1 - Selecting the Data Source

As a first step, we will have to upload the file containing the travellers we want to import and invite.

Supported file types are Excel files (*.xlsx, *.xls), as well as Comma-Separated Values (CSV) files (*.csv, *.txt). An example Excel file with the correct headers is available to start with.

Import conference travellers from Excel or CSV

Ideally, the import file contains column header names with the following structure:

Jane Doe;jane@example.org;LHR;250;10%;1;PremiumEconomy
John Doe;john@example.org;MUC;200;10%;1;Economy

Don't worry if the import file has different column headers, or no headers at all. We can map fields in the next step.

Step 2 - Import Settings and Field Mapping

The next step involved in importing travellers for our event, is to map fields from the imported file, and set defaults to use when data is missing.

Note: For Excel imports, we will always select the first worksheet as the data source. For Sessionize.com imports, the Accepted Speakers (or Accepted Sessions and Speakers) worksheet will be used instead.

By default, import will skip e-mail addresses that were already invited before. For example when importing data from a Sessionize.com export file, this will prevent duplicate invitations from being sent.

Next, we can map fields from our imported file to what they represent. We'll do our best to map fields automatically when possible, by recognizing column headers and data types. If needed, mappings can be updated manually.

Import settings and field mapping

All field mappings correspond to options available when manually inviting travellers. For options like budget amount, budget percentage, number of passengers allowed and highest allowed booking class, we can set defaults that will be used when the import file contains no data for them.

Step 3 - Verify Traveller Details and Send Invitations

In the next step, we'll prepare the data that will be imported, and will be used to invite travellers. If needed, options can be adjusted per traveller.

Verify traveller details and opionally adjust

If all data looks ok, we can use the Import & invite travellers button to send out invitations for your event travellers.