1. Import and export data
  2. Import Data into Models
  3. Import a List of Users

Save time by importing new users into your model from a TXT or CSV file. You can update some attributes of existing users in the same way.

Note that you can manage user access to workspaces in three ways:

If a user administrator and workspace administrator input conflicting changes for a user, the most recent transaction determines the user account status. 

To avoid user status conflicts, we recommend that your organization use the user administrator role to provision user access. Workspace administrators can then refine model-level access from the Users pane within a model.

Import user attributes

The following attributes can be imported for each user:

Attribute Notes
Email Address The email address associated with the user's Anaplan account. New users receive a Welcome email, inviting them to log in to Anaplan and change their password.
First Name Required when importing new users.
Last Name Required when importing new users.
Model Role

Before you import the model role attribute, verify the role exists on the Roles tab in Model Settings > Users.

If you import a new user with a model role that does not exist in the model, the user is assigned the default role, No Access.

Selective Access Permissions

Permissions display in a comma-separated list (for example, "List Name Write", "List Name Read").

When importing selective access permissions, verify Selective Access is enabled for the list to which you want to assign Read or Write access.

Single Sign-on This is set as true or false to indicate whether the user uses Single Sign-on. For more information, see Single Sign-on.

You can identify users in an import using:

  • Email Address
  • User ID
Note: Only workspace administrators can add, delete, or edit users by performing an import. The Import function does not support updating a user's workspace administrator privileges or deleting users.

User ID

When you create a user, Anaplan automatically assigns a unique, 32-character identifier (ID). These display in the Users tab of the Users pane within a model, and and in the Details tab on Users > Internal in the Administration console.

You can map imports with the user ID to update the role, single sign-on, and selective access of users.

When you import new or existing users into your model, Anaplan treats the user ID in the User ID column you specify as the unique identifier. If the user ID corresponds to a user that already exists, the attributes of that user account update. If that user ID is not present, data from that import row does not update.

When you perform an import, you must user either the user ID or the email address to map users. However, you do not need to use both.

Note: Imports mapping on a user ID cannot update a user's existing email address, first name, or last name.

Import users from a TXT or CSV file

To import users from a TXT or CSV file:

  1. Navigate to Users within a model.
  2. Click Import. This displays the Select Source dialog.
  3. Click Upload New File.
  4. Browse for and select the .txt or .csv file containing the user details, and then click Select. This sample file contains the details of three new users:
  5. User details for three new users in a .csv file.

  6. Change the options in the File Options dialog if needed and then click Next.
  7. File Options dialog showing three new users.

  8. In the Import dialog, on the Mapping tab, check that the user attributes in the uploaded file are correctly mapped to values in the Target Identifier, Target Data, and Target Access (for Selective Access permissions) columns. You can map source fields to target identifiers if needed.
  9. Mapping tab on the Import dialog showing the attributes of three new users.

  10. Click Run Import.
  11. Review the outcome of the import in the Import Completed dialog.

To view the new or updated users, navigate to Model Settings > Users. Just like other imports, imports of users are available in Model Settings > Actions. From there, you can run, edit, and delete imports of users.

Welcome email

New users receive an email inviting them to log in to Anaplan and change their password.