Excel templates

Are you looking to import your data into the platform in bulk? Then our pre-established excel templates will come in handy!

There is a variety of data you can import into the system which will save you time manually completing this in the platform. You can import the following information:

• Users (Speakers, attendees, exhibitors)

• Companies/ exhibitors/ sponsors

• Program

• Push notifications

• Call to Actions

• Posters

• Networking tables

How to use the Excel templates

Listed below is a short guide to how you can download and start filling the Excel templates with your data.

1. Download the Excel templates (listed below)

2. Select the relevant Excel sheet

   

3. Fill in the required and relevant fields in the Excel sheet (You can use the description in row 2 as a guide)

   
4. Save your changes

5. Import using the Import Data Tool

Templates you can use

For the app:

Other templates

For the app and the virtual event platform:

Filling the Excel-files

In the Excel sheets, all users must have a unique number assigned. This number must be truly unique and should therefore not be used more than once! Make sure this number corresponds to every Excel sheet.

Furthermore, the name of a user may only appear in one sheet. For all other sheets, the unique number can then be used. This means that a speaker who is also an exhibitor can be filled in completely in the speaker Excel sheet. Then only the corresponding unique number can be entered in the companies/exhibitor Excel sheet.

Thus, the existing data must stay the same. Even a dot or an added letter will cause duplications in the admin panel. Once you filled in the Excel sheet, please make sure that the information is correct, so the admin panel is filled with the correct data. Changing data afterwards is possible, but as soon differences in spelling etc. appear, the computer will be confused and mistakes will appear.

Overwriting QR-codes

To overwrite the LGD QR-codes in the app with the QR-codes of your lead generating system, for example, make sure you either have the link of this QR-code or the barcode of the QR-code. Follow the next steps to overwrite the QR-codes of the users in the app:

1. Add another column to the user Excel sheets and name it 'QR-code'.

2. Fill this column with the URL/barcode of the personal QR-codes of the users.

3. Import the data as explained above and connect the column QR-code to the LGD value 'Custom QR code'.

After the import is done, the custom QR codes will overwrite the LGD QR codes in the app.

Personalized column

You can also add a personalized column to the Excel sheet. This is useful if you need to include information that is not a standard value in the system, such as country or dietary preferences. To do this, first create a additional data field, then add a new column in the Excel template with the relevant information. Follow these steps to proceed:

After you have added the additional data field, you can do the import with the additional datafield column in the Excel sheet and enter the corresponding information for each user. Then, import the data and map the column to the correct value to ensure a successful import.