Read this whole article!
It's only going to annoy you if you upload and discover that some data did not upload.
Import Attendees to Accelevents Through CSV Upload
Suppose you're using a different platform to sell tickets, or you already have a list of attendees in your Google Sheet, you can add these attendees to your event in one go by uploading a CSV file. If you just have a handful of attendees, you can also add them manually.
Before You Begin
Before you begin make sure you've already done the following:
✅ The ticket type or add on is already created and the quantity is enough for the attendees you will upload
✅ The Ticket Buyer and/or Ticket Holder fields that will be included in the upload are "Active" in order form
✅ The Order Confirmation Email is disabled if you don't want them to receive an email after uploading
✅ Before uploading your file, ensure that the data format is correct and you understand what will happen if your data format is incorrect.
IMPORTANT NOTES BEFORE UPLOADING
Check all your formats before uploading.
Do not add multiple attendees with add ons to the same order, this will cause issues and you may have to delete and re-upload.
Do a couple of test imports before you upload your final list to ensure that all the fields populate.
There shouldn't be any extra spaces before or after the email address, it will give you a success message after you upload, but no orders will be created.
CC email addresses can also be included in the import
1. Prepare Your CSV Column Headers
🟢 Transaction ID, First Name, Last Name and Email Columns
When uploading attendees, you're required to upload at least 4 columns. You'll need the Transaction ID, First Name, Last Name and Email.
The Transaction ID value can be left blank, it just needs to be mapped in the upload.
🟢 Transaction ID Column for Uploading Attendees to the Same Order
If you want attendees to appear in the same order after they are uploaded, you can add the same value for all the attendees in the same group. The Transaction ID value should only be numbers with a maximum of 45 digits.
Important Note: This will not work if if you're uploading tickets and add ons at the same time - this will cause issues, just leave it blank.
🟢 Column For Attendee Profile Picture
You can include the Profile Image URL in the CSV upload. You’ll need a direct image URL that ends in a file type like .jpg, or .png just like in the example below.
IMPORTANT NOTES:
Google Drive Links will not work. Google Drive links don’t work as direct image URLs because they’re not actual file paths — they’re view links that require authentication or page loading.
The image dimensions should be minimum 200 x 200 pixels in JPEG format. If the image is rectangular, it will appear stretched when uploaded. Make sure to make it a square before you upload.
🟢 Columns For Other Order Form Fields
If you want include more information in your upload like Job Title or Organization, you can add more columns to your CSV. Make sure that these fields are also Active in the Order Form.
Suggestion: Name your columns exactly the same as the order form field labels, this way it will automatically map identical fields. If they're not identical, you'll have to manually map them.
2. Enter the Correct Data Format
Please ensure to follow the correct format as stated below. Read the third column to know what happens if your format is incorrect. Take note of the ones highlight in red.
Field | Format | Will it upload the attendee if I enter the incorrect format? |
Transaction ID | Transaction ID can only be numbers, with a maximum of 45 digits or you can leave it blank if not needed.
| ❌ No, the attendee will be excluded from the upload, the rest will be uploaded. |
First Name and Last Name | First Name and Last Name should have a maximum of 50 characters | ❌ No, the attendee will be excluded from the upload, the rest will be uploaded. |
Email should contain one email address with a maximum of 75 characters
⚠️ Ensure that there are no extra spaces before or after the email address. If at least 1 email has an extra space, it will allow you to upload, but no orders will be created. | ❌ No, the attendee will be excluded from the upload, the rest will be uploaded. | |
Profile Image URL | You’ll need a direct image URL that ends in a file type like
| ✅ Yes the attendee will be uploaded. ❌ The profile picture will be left blank. |
Cell Phone |
Sample acceptable formats: 19175825511 +19175825511 +1(917)5825511 +1-917-5825511 | ❌ No, the attendee will be excluded from the upload, the rest will be uploaded. |
Country | The Country should be displayed in full and not abbreviated, and should follow the same values found in Accelevents. | ❌ No, the attendee will be excluded from the upload, the rest will be uploaded.
|
State | You cannot upload just States, you must include the Country.
Both should be displayed in full and not abbreviated, and should follow the same values found in Accelevents. | ✅ Yes the attendee will be uploaded. ❌ This field will be blank.
⚠️ You will NOT get a warning that this attendee will be uploaded with this field left blank. |
Billing and Shipping Fields | This field is composed of 6 fields.
Address|Address 2|City |State|Zipcode|Country
Example:
2 Franklin Road|Apartment 6|Beverly Hills|California|90210|US | ✅ Yes the attendee will be uploaded. ❌ The field will be blank.
⚠️ You will NOT get a warning that this attendee will be uploaded with this field left blank. |
Upload Field | ⚠️ This cannot be uploaded.
| ✅ Yes the attendee will be uploaded. ❌ The field will be blank.
⚠️ You will NOT get a warning that this attendee will be uploaded with this field left blank. |
Image Field | You’ll need a direct image URL that ends in a file type like
⚠️ Google Drive Links will not work. Google Drive links don’t work as direct image URLs because they’re not actual file paths — they’re view links that require authentication or page loading. | ✅ Yes the attendee will be uploaded. ❌ This field will have errors.
⚠️ When you open the order or the report, the image and URL will be broken, and you will NOT get a warning that this attendee will be uploaded with errors in this field. |
Birthday / Date Question | The Birthday / Date should be MM/DD/YYYY format (e.g. 12/25/1995) | ❌ No, the attendee will be excluded from the upload, the rest will be uploaded. |
Number Question | Numbers cannot contain commas | ❌ No, the attendee will be excluded from the upload, the rest will be uploaded. |
Dropdown Question | The value should be identical in the order form field | ❌ No, the attendee will be excluded from the upload, the rest will be uploaded. |
Multiple Choice Question | Multiple answers for a Multiple Choice question should be separated by a | without any extra spaces. (e.g., Answer 1|Answer2|Answer3)
The answer must be identical to the choices in Accelevents | ❌ No, the attendee will be excluded from the upload, the rest will be uploaded. |
Single Checkbox question | The Single Checkbox value should be | ❌ No, the attendee will be excluded from the upload, the rest will be uploaded. |
3. Upload Your CSV File
When your CSV is ready, you can start uploading.
Suggestion: Do a test import before uploading your real file to see if all the data will upload.
Go to Attendees > Add Attendees
Click Import Attendees
Upload your CSV File
Select the ticket type to assign to the registrants
You can select an add-on if these registrants also purchased an add-on
Click Upload & Review
Check the mapping and make adjustments if needed.
Click Next
Review your data before importing. If there's invalid data, that attendee will be excluded from the import.
Click Confirm Import
You should receive an email confirmation after uploading.
Check the Attendees > Orders tab to see the newly imported attendees
Note: If you have required fields, you can bypass those fields when uploading a CSV.
Upload Add-ons Only
If you're uploading add-ons only, only those with Accelevents tickets can be imported. If there are add-ons for users in your list who don't have a ticket yet, you will see them in the Invalid Rows and they will be excluded from the upload.
Add Attendees Manually
If you need to add just one or a handful of attendees, you can manually add them instead of uploading a CSV.
Go to the Attendees tab
Click Add Attendees
Select the number of tickets for the order
Click Register
Enter the ticket buyer and holder information
Click Submit
Note: If you have required fields, you can bypass those fields when registering attendees through the add attendees tab.
Add Attendees in Attendee Management
The Add Attendees option in Attendee Management allows event admins to quickly add participants to an event without going through the standard registration process. Instead of completing the full set of registration steps, admins only need to provide basic details such as the attendee’s name and email address. The ticket type can be easily selected from a dropdown, and the same payment options available in the Add Attendees tab are accessible here as well. The option to upload attendees through CSV is also available in this menu.
