How to add and connect users to projects via Excel?

This article explains how to add new users in bulk and connect them to the relevant Panaya projects, as well as connecting existing users to projects and assign them with relevant Roles.

  1. Click on the Setting button to open up the Settings panel, then select Users

  2. Select to Import from Excel
  3. Select the Add and Connect Users option and click Next
  4. Click on Download our template to download the template for importing.

  5. Open the file and begin filling the details for all users you wish to import - First and Last Name, Email, Status, SAP User Name (where relevant).
    • To connect existing users to projects and assign them with roles - 

      • First, export the list of users as described in this article
      • Proceed with the import process as described below
  6. To define Roles for each user (optional)
    • Fill in one or more Roles for each user in the Roles column.
      You can select from Predefined Roles 
      To learn more about how to customize Roles, click here

      For multiple Roles, separate each Role with a comma.
      Roles are case sensitive.
      Undefined Roles will be ignored. 
    • For the Roles Action column, select one of the following options for each user - 

      • Add
        To add the role(s) defined, in addition to any existing user roles

      • Remove
        To remove the role(s) defined, from existing assigned roles

      • Replace
        To replace all existing roles with the list of provided roles

      • Clear all
        To clear all existing roles

      • Don't Change
        To avoid making any changes to currently assigned roles

    • Panaya will only make changes to Roles if -

      • The Roles exist in the current Panaya account.

      • If you have more than one Panaya account, verify that the relevant account is selected using the Switch Accounts button.

      • The user is associated with Projects you can edit

  7. Save the template file locally.
  8. Click on Browse and select the template file.
  9. Select the project(s) to connect users.
  10. Click on Import Users