If you have a list of attendees in a spreadsheet, you can import them all at once instead of adding them one by one. The import flow lets you map each column in your Excel file to a field in your event’s registration form, assign a ticket and role to everyone in the file, and then upload the file to create or update the attendee records.Documentation Index
Fetch the complete documentation index at: https://docs.jointoevent.io/llms.txt
Use this file to discover all available pages before exploring further.
Opening the import page
From the attendee list, click Import attendees in the top-right corner. You can also reach this page from the Add attendee form.Configuring the import
Set up column mappings
Column mappings tell the importer which spreadsheet column corresponds to which registration field. Each mapping has two parts:Click + Add field to add another mapping row. Click the red trash icon on a row to remove it. You can configure as many mappings as you need — one for each field you want to populate from the file.If you have not set up any mappings yet, click Start configuration to add your first mapping row.
The field in your JTE Panel registration form (for example,
firstName, email). Select from the dropdown, which lists all fields configured for your event.The column in your Excel file that contains the data for that field. Columns are identified by letter:
A, B, C, and so on.Mappings are saved per event. Click Save settings at any time to persist the current mapping configuration without running an import. The next time you open this page, your mappings will already be in place.
Specify whether the file has a header row
Check the First row is a header checkbox if the first row of your spreadsheet contains column labels rather than attendee data.
When
true, the importer skips row 1 and starts reading attendee data from row 2.Assign a ticket (optional)
If you want every imported attendee to receive the same ticket, select it from the Assign ticket dropdown.
The ID of the ticket to assign to all imported attendees. Leave empty if you do not want to assign a ticket, or if your spreadsheet already contains ticket information mapped through a column.
Assign a role (optional)
If you want every imported attendee to have the same role, select it from the Assign role dropdown.
The role to assign to all imported attendees. Leave empty if no role should be assigned during this import.
Select the file
Click the file input and choose your
.xlsx file. Only Excel files in .xlsx format are accepted.The file name and size are shown after selection.Import results
When the import finishes, a notification summarises what happened based on the fields in the response:Imported
importedAttendees — the number of new attendee records created from rows in the file.Updated
updatedAttendees — the number of existing attendee records that were updated with data from the file.Omitted
omittedAttendees — the number of rows that were skipped, for example because they were duplicates or contained invalid data.Overall status
importSuccessful — whether the import completed without a critical failure. A partial result (some rows omitted) can still be reported as successful.A successful import (
importSuccessful: true) does not mean every row was imported. Check omittedAttendees to see whether any rows were skipped. If rows were omitted, review your column mappings and the data in those rows.importSuccessful is false, an error notification appears and no attendee records are created or updated. Correct your file or settings and try again.