CSV Import & Export Attendees

Note: This guide is outdated. Click here to read our updated version on how to import attendees.

The Import and Export area allows you to manage your attendees data in bulk.  You can mass-create attendees with CSV imports, and you can mass-edit attendees by doing a CSV export, editing the CSV file, and then re-importing the CSV file with the changes.

Depending on which operation you need to perform, you select the appropriate tab:

Import tab

NOTE: Be sure to use the CSV template -it’s much easier than typing it from scratch and helps avoid common errors.

 

How to import your data

To import attendees via CSV, you must do the following:

• Provide a CSV file that is of the correct format. We highly recommend that you use the CSV Template file to avoid column naming errors!
• CSV import file need to use UTF-8 encoding to properly work.

Common Errors to Avoid During Import

• Your CSV file must have every column from the sample file, named exactly the same as shown in your grid on this configuration page. Don’t delete any of them, especially the OPTIONAL ones.
• Your CSV file should have data in every column that is required. Optional columns/fields can be left empty below the header, but you cannot remove the column!

CSV label definitions and required fields

Label	Explanation	Required
email	email address of attendee	Yes
firstname	attendees first name	Yes
lastname	attendees last name	Yes
type	type of attendee, use one of the following: attendee, exhibitor, sponsor, speaker or organizer	Yes
affiliation	organisation or company of the attendee	No
title	company title of the attendee	No
badgtype	additional text that you want to print on the badge	No

Export Tab

How to export your data

• Click on export. 

Open CSV with Excel 

• Open CSV File
• Go to the Data tab
• Select text to columns under data tools
• Select delimited and hit next.
• Select comma as the delimiter and hit finish