How to upload a .csv file
- In Company Space, open "Batch Operations" and click "Upload .csv file".
Under "Operation", select the operation you need. Each operation comes with a short description. Use "Download sample .csv" to get a matching sample file.
- Drag your file into the upload area or click "Upload .csv file". The file can be up to 1 MB and 10,000 rows.
- The file name and size are shown under the uploaded file.
- Click "Upload .csv". The button is only active once a file is selected.
The following adjustments can be made via bulk adjustment:
Import Users
Lets you import several users at once, even without email addresses. The columns are email address or ID, user groups, department, email notification yes or no, and language code (de, en, ...), in exactly this order. Only the email address or ID is required, everything else is optional. Separate several user groups with a slash, for example groupA/groupB. Use "yes" to send an email notification, use "no" to suppress an email notification.
Edit User Details
Allows you to edit user information when updates are needed. All columns (Email/ID, First Name, Last Name, Roles) must be filled in and listed in exactly this order. If a column is left blank, the user’s existing data will be removed.
Deactivate Users
Allows you to manage the license pool and reclaim licenses from inactive users. The email address or ID must be provided.
Reactivate Users
Allows users to regain access to their account after a period of inactivity. The email address or ID must be specified.
Assign User Groups
Allows you to manage user group assignments for learners. The email or ID, user groups to assign, and user groups to remove must be specified in the exact order.
Department Assignment
Allows you to assign multiple users to departments at the same time. The email or ID and the department must be specified. If the department is empty, the user will be removed from their active department.
Which characters are not allowed in the Email, First Name, and Last Name fields?
When creating users (whether individually or via bulk upload), the email address, first name, and last name fields must not contain the following special characters, as these are not technically accepted by the underlying authentication system:
< > & " $ % ! # ? § , * = / { } \ ^ 'If a CSV file contains any of these characters in the fields mentioned above, the creation of that user will fail. Before uploading, check your data (especially for names with hyphens, apostrophes, or special characters from other languages) for these characters and clean them up beforehand if necessary.
User groups and departments are not affected: This restriction applies exclusively to the authentication fields email, first name, and last name. You can continue to name user groups or departments freely, including with special characters.