Bulk user import

How to Bulk Import users via Excel Spreadsheet

If you choose to import new users in-bulk via an excel spreadsheet, please take time to read this tutorial carefully.

To make the process straightforward, we created an excel template. To begin the bulk user import, you first need to download the spreadsheet.

The upload only accepts CSV files, so remember to save your template as a CSV file — it's easy if you stick to the tutorial.

  1. Go to your Admin area > App settings > User management > Import users.

  2. Download the excel spreadsheet from the Import users page. Make sure to always download the latest version.

  3. Open the excel template and add the users you want to import. The following columns are mandatory:

  • First name
  • Last name
  • Email

🚧

Please note:

  • There are three options for the column titled Gender: m, f, or u (for undefined)
  • Country codes should be a valid country code
  • Gender and country codes should be written in lowercase
  • Use the following date format for the column Employment Start: yyyy-mm-dd (see chapter How to format the Employee Start Date in Excel)
  • Every knowledge space has its own unique ID. For a correct "user to knowledge space" assignment, you need to add that ID in the template in one of the available knowledge space columns. You can find the ID of the knowledge space in the URL when editing it in the admin section (e.g. https://{yourNetwork}/admin/content/knowledge-spaces/{ID}/)
  1. When all required user information is filled in, make sure to save the file as CSV (UTF-8 formatted). To do this, click on File.
16001600
  1. Next click on Save As
16001600
  1. For the last step, make sure to select CSV UTF-8 (Comma delimited) (*.csv) as the file format. This step is crucial for the user import to work. Finally, click on Save.
16001600
  1. Now select and upload your CSV file on the Import users page.

  2. In the final step, confirm the selected file by clicking on Import File.

  3. You’ll be able to see the import’s progress as it uploads. Please note, if you accidentally close your browser window, you won’t cancel the import.

13021302

How to format the Employee Start Date in Excel

Formatting dates in Excel can be tricky. To ensure that you entered the Employee Start date in the right format, please do the following:

  1. Right click on the Employee Start date field
  2. You will see a context menu where you need to click on Format Cells...
453453
  1. In the next view select Date and then the type yyyy-mm-dd.