Example: Various placeholders can be used in the mails, such as the salutation (%participantGreeting%). If such placeholders are used, the corresponding information must be stored in the participant list in evenito. More about this under Emails and Placeholders.

Upload Excel File

Select "Upload Excel Participant List" under "Add participants to List", look for your list of participants and upload it. The following window will open:

1. Automatic assignment

As soon as you have uploaded the Excel, evenito automatically assigns the values to the individual columns.

The green buttons show which values are in each column.

Check the assignment. If necessary, you can change the descriptions using Drag & Drop.

2. Manual assignment

If the definition does not work properly, you can drag and drop it to the corresponding column.

Example: The "Salutation" column does not have this assignment. Now select the button "Salutation" from above and drag and drop it down to the "x".

3. Delete column or row

Click directly on the red cross

or drag the green value from the field to the top and then click on the red cross

4. Here you can perform an automatic duplicate check. Activate the checkbox "Find Duplicates". As soon as you click on "Import", a second window opens with duplicates, if there are any.

5. Click on "Import" to upload the list to your event.

Please note:

Before the import you should delete the first row, as it is not a person, but the titles of the Excel list.

In the attachment there is a demo list with the stored values in the header, which can be used to store the participant data correctly.

Correct completion of the Excel table

It's important to fill in and define all columns correctly. It is the only way to ensure a clean upload and a good availability of all placeholders in the emails. Depending on the intended use, you should fill in other columns in the table. For the use of placeholders, please check the article about placeholders.

Personal data

1. Language

If your event is multi-lingual, set the participant's language. Thus the guest will automatically receive the mail in the correct language and the event website will be displayed in the correct language.

Evenito recognizes the following values in the Excel list:

DE = German

EN = English

FR = French

IT = Italian

If no language has been defined for a guest, it is assigned to the default language.

2. Gender/Salutation

The gender can be used for the placeholder %participantGender% in the emails.

Important: You have to define the category name in Excel exactly the same as you have defined it in the menu item "Categories".

For more information, see Categories.

27. Extra fields

In these fields you can upload further individual data.

The information from the extra fields can be inserted into the mail using placeholders: %participantExtraField1%.

28. Participant code

The personal participant code, which is normally generated automatically by the system, can also be defined via the Excel upload.

This is particularly useful in two different cases:

If you want to send a number of special codes, because the guests are invited by post, e.g. JUBILAEUM1-JUBILAEUM100

In the second case, if the login status of a guest is to be reset to neutral. The email with the personal registration code has already been sent. In order for the link to still be valid, the guest must be uploaded again with the same code. The participant code cannot be uploaded by manually entering the participants.

The participant code can be inserted into the email using the placeholder %participantCode%.

29. Newsletter: Enter whether your guest wants to receive the company newsletter or not. Please enter the values with Yes or No.

30. Hidden

Define whether the guest is displayed to the public or not. To do this, store the values with Yes or No.

If a guest is stored as "hidden", he is not displayed in the participant list and his photos are not uploaded.

31. Photo email activated: If the function is activated, the Fotomail with its personal photo is automatically sent to the guest. To do this, enter Yes or No for the values.

32. Privacy Consents

Set up one column per consent for the import in the Excel list.

The column header should be the same as the consent name.

Enter Yes or No for the values, whether the customer has agreed or not.

33. Import login status: If you already know from your guests whether they will come to the event or not, you can import their registration status via Excel (not available for ticketing events)

Registered = 30: If the participant has registered, you can insert the number 30. The system automatically takes over the status "registered".

Deregistered = 40: If the invited person does not want to come, you can enter a 40 in the line.

Neutral = 0: If the status neutral should be imported, i.e. neither registered nor deregistered, then a 0 can be entered in the corresponding line.

Tip: What should I do if the Excel list is not uploaded?

Copy the data to a newly created file.

Check if two of the three information (name, first name, email) are stored.