Frequently Asked Question

How does the employee data import via CSV list work?

Last Updated 3 years ago

Step 1:

Create or export a CSV employee list (using MS Excel or from HR software).

The first row must contain the column labels.
Possible fields (mandatory fields marked with *):

User name* (e.g.: code, personnel number, unique key, etc.)
Password (initial)
First name
Last name
* (e.g. employees, multiple assignments possible, comma separated)

Step 2:

Save / Export the list as a CSV file.

Step 3:

Select Employees -> Import/Codes.

Step 4:

Select the CSV file and click Upload and review.


Step 5:

Select the appropriate columns and click Check.

Step 6:

Click Import Now and the actual import will take place.
You can add or remove rows in your CSV file at any time (employee departures and arrivals) and re-import them. The entries will be compared and synchronized. If an employee has already logged in for the first time from the CSV data, data (e.g.: name / position / groups) will not be overwritten when re-importing. If you want data to be overwritten when importing again, activate the checkbox Overwrite active in the respective line.


Step 7:

Employees can now log in (with code / email and password). Employees will not appear under "Employees" until the employee actually logs in. If an email address was specified, the employee will receive an email to confirm (double opt in). If no password was specified, employees can assign one when they log in for the first time (alphanumeric code only recommended). Employees will not count regarding licenses until they have logged in at least once. The number of entries in the CSV import is insignificant for billing purposes.

Step 8 (optional):

After employees have been imported, you have the option to automatically send invitations for the just imported employees. Attention: Invitations will only be sent to those employees who have a valid e-mail or phone number. Corresponding texts can be customized under Settings.


To invite individual employees by e-mail or SMS (additional information for SMS), click Check imported list.


Now you can send individual invitations by clicking on the SMS or @ icon.


Note 1:

If an initial password is assigned during the CSV import, this must be used for the initial login.

If you want to send invitations by e-mail for the imported employees, please keep in mind that you cannot send the password as plain text, because passwords are only stored "encrypted" (=hash) in the database for security reasons and are not available as plain text.

We therefore recommend choosing a password that is easy to communicate (e.g.: social security number, date of birth, etc.).

Note 2:

Since an employee is only actually created in LOLYO after the initial login and is thus subject to licensing, no password forget function can be used beforehand.

Note 3:

You are now shown how many records were changed, check if these numbers seem plausible.


Please Wait!

Please wait... it will take a second!