Excel templates

Our excel templates allow you to import your data into the platform in bulk.

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:

The Excel file below is the one you would probably need if you are filling an app and DO NOT make use of our virtual event platform.

22KB

Simplified - Excel Templates.xlsx

Excel file that is used by 85% of the event managers that use our app or badgeprinting combination only

22KB

Excel templates - Simplified - Multilanguage.xlsx

Excel file that is used for multilanguage app environments

Other templates

For the app and the virtual event platform:

The Excel file below is a more suitable option for you if you are hosting an online or hybrid event and/or if you would also like to import posters, push-notifications, virtual networking tables and/or call to actions.

31KB

Excel templates..xlsx

Excel file containing all options for advantage usage

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.

We do not support all custom QR codes, therefore it is important to test already in advance whether the LGD QR-codes can be overwritten.