Import users into BIMcollab Cloud from a CSV file

Import users into BIMcollab Cloud from a CSV file

In some cases you may wish to import a list of users from another source into BIMcollab Cloud. In that case the easiest way is to save your user data into a CSV file. Creating a CSV file can be done using a spreadsheet application such as Microsoft Excel, Google Sheets or Numbers.
  1. Start by downloading the template file 'Template to import users' from the Example projects and templates article
  2. Open the template file in your spreadsheet software of choice, and start editing the list of users to import

  3. When entering your data, you must take into account the following conditions: 
    1. Each row must represent a single individual user 
    2. Column names must remain in the same order as the template file and must not be alternated 
    3. Additional columns will not be taken into account (If you add additional columns, they will simply be ignored during the import) 
    4. All cells must be in TEXT format
    5. Column names are not case sensitive 

  4. Once all of the data is entered, you can now save the file as a CSV file:
    1. In Numbers, go to File > Export to > .CSV
    2. In Excel, go to File > Save as > .CSV (Read the more detailed article on the Microsoft site)
    3. In Google Sheets, go to File > Download > Comma Separated Values (.csv, active sheet)

  5. After your list is ready in CSV format, go to the "Users" page in your administration area, and click on Import users > Browse > Import 

The following points are also important to make a successful import of users from a CSV file: 
  1. Users in the list are mapped to existing users in BIMcollab based on email address
  2. When a new user is found in the list then that user will be created in BIMcollab. They will then need to be set to active by the space administrator and added to projects before they can log in and use BIMcollab Cloud
  3. Microsoft Excel is not able to create CSV files using Unicode encoding. Therefore any special characters or non-latin characters may be lost

    • Related Articles

    • Import issues into BIMcollab Cloud from a BCF or CSV file

      Import issues from a BCF file Follow these steps to import a BCF file in BIMcollab Cloud: In BIMcollab Cloud, choose the project in which you want to import issues Go to the Issues tab of the project Click on 'Import' Click on 'Browse', and choose ...
    • Set your language of your BIMcollab account

      My BIMcollab ID / Go directly to the My BIMcollab ID page. Or on, click on your avatar, and choose 'My account', which redirect you to the My BIMcollab ID page Select the language you prefer under 'Preferences' ...
    • Manage a BIMcollab Cloud

      Administrators can reach the administration page by clicking on the gear icon in the top right corner. If you do not see the gear icon, you do not have administrative rights in the space. The administration page is easily recognizable by the red ...
    • Import user names that contain special characters

      BIMcollab Cloud does support special characters, but it depends on the encoding of the file that you want to import. Like most web applications, BIMcollab Cloud uses Unicode encoding to ensure that all special characters are supported and can be ...
    • My name contains question marks in BIMcollab Cloud

      BIMcollab Cloud is designed to support most character sets. However when your Cloud administrator imports users from a file, if the encoding used in the source file is not recognized by BIMcollab Cloud then any special characters your name may ...