Pathable can read Excel and CSV spreadsheets and create user accounts automatically. From your Dashboard:
- Click Data Import
- Download the "Speakers / Attendees Template" from the top of the page and prepare your data (see below for tips)
- Click Start New Import Excel / CSV Spreadsheet
In the Import data type menu, choose People.
Select your file
Choose the invitation email you would sent to new attendees. (see below for more information)
Click Map Columns
Match the fields from your spreadsheet to the fields in the app. Check the "overwrite" checkbox on any fields where you would like the imported data to overwrite existing data. (see below)
Click Start Import.
- You are not required to use Pathable's template, if your spreadsheet is in the same column-type format. Our system can parse a spreadsheet, determine the columns of data available and give you the option of matching them up to Pathable's fields. Our template is a convenience because it has all the "correct" fields.
- Pathable will only offer you the option of sending an email invitation to your staff, not regular attendees, until after you have "launched" your app, to prevent the possibility of mistakenly inviting people to an unfinished experience. You will have the opportunity to email them when you launch.
- You may import the same spreadsheet repeatedly and Pathable will use either the "external id" field (if present) or the "email address" field to match records. Agenda sessions external IDs can not contain any blank spaces. By default, it will ignore records for users that you have previously imported, but you may use the Overwrite checkbox on the Map Columns to tell Pathable to update existing records with the information you are importing.
- The Overwrite function does not overwrite existing data for Label attributes - it adds the new data, in addition to the existing data.
- If you want to import responses to questions from your registration provider beyond the standard name, title, company and email, be sure to configure the Profile Questions in Pathable first, then set up your data feed integration second.