Use bulk import when adding 10 or more speakers, or when migrating a speaker list from another system.
Go to Content → Speakers and click Import.
In the Import dialog, click Sample CSV or Sample XLS to download the template.
Do not create your own spreadsheet. Always start from the downloaded template — column headers must not be changed or deleted, even if a column is left blank.
Required columns (every row must have values): Firstname, Lastname
| Column | Notes |
|---|---|
| Designation | Speaker's job title |
| Organization | Company/organisation name |
| Category Type | Must match a category name created in Manage Categories — case-insensitive, spelling must be exact |
| Required if User Permission column contains "Yes" | |
| Phone | Format: +xx xxxxxxxxxx |
| Country | Country name |
| URL — https:// auto-prepended if missing | |
| URL — https:// auto-prepended if missing | |
| URL — https:// auto-prepended if missing | |
| URL — https:// auto-prepended if missing | |
| About | Biography |
| Image | URL or file path |
| User Permission | Enter attendee email addresses (comma-separated) to link existing app users; or enter Yes to create a new user (requires Email column) |
| File1–File5 | Up to 5 file paths or URLs |
| Display Order | Lower number = higher in list |
Social media URL validation: Facebook, LinkedIn, Twitter, and Instagram URLs are validated on import. Invalid URLs are flagged per row. URLs without https:// are accepted — the system adds it automatically.
Drag and drop your file into the upload area, or click to browse. Accepted formats: CSV, XLS, XLSX.
The import dialog shows a preview of your data. Rows with errors are flagged. Click the info icon on any flagged row to see the exact error.
Common errors: Missing Firstname or Lastname · Invalid email format · Invalid phone format (+xx xxxxxxxxxx required) · Invalid social media URL format · Category name not found in Manage Categories
| Mode | What it does |
|---|---|
| Update | Matches by name — updates existing speakers, inserts new ones |
| Update + Skip blank field values | Same as Update, but blank cells in your file leave existing data unchanged |
| Insert | Skips name matches — only adds new speakers, never updates existing ones |
Use Update + Skip blank field values when doing a partial update — for example, adding categories to speakers without risking other fields being cleared.
Click Import. On success you see a message with the total number of speakers imported. Imported speakers appear immediately in the Speakers list.
Q: What are the required columns in the Eventify speaker import template?
A: Firstname and Lastname are the only required columns. All other columns are optional.
Q: What does "Skip blank field values" do during speaker import?
A: When enabled alongside Update mode, blank cells in your import file are ignored — existing data in those fields is preserved. Use this for partial updates.
Q: Are social media URLs validated in the Eventify speaker import?
A: Yes. Facebook, LinkedIn, Twitter, and Instagram URLs are validated per row. If a URL is missing https://, the system adds it automatically.
Q: What happens if a category name in my import file doesn't match any existing category?
A: The category field is left blank for that speaker — the row is not rejected. Category names are matched case-insensitively but spelling must be exact.
Q: What is the difference between Update and Insert import modes?
A: Update matches by speaker name and updates existing records (or inserts new ones). Insert skips any name matches and only adds new speakers.
