User Guide Cancel

Manage multiple users | Bulk CSV upload

Search
Enterprise

Enterprise

Admin Console
  1. Adobe Enterprise & Teams: Administration guide
  2. Plan your deployment
    1. Basic concepts
      1. Licensing
      2. Identity
      3. User management
      4. App deployment
      5. Admin Console overview
      6. Admin roles
    2. Deployment Guides
      1. Named User deployment guide
      2. SDL deployment guide
      3. Deploy Adobe Acrobat 
    3. Deploy Creative Cloud for education
      1. Deployment home
      2. K-12 Onboarding Wizard
      3. Simple setup
      4. Syncing Users
      5. Roster Sync K-12 (US)
      6. Key licensing concepts
      7. Deployment options
      8. Quick tips
      9. Approve Adobe apps in Google Admin Console
      10. Enable Adobe Express in Google Classroom
      11. Integration with Canvas LMS
      12. Integration with Blackboard Learn
      13. Configuring SSO for District Portals and LMSs
      14. Add users through Roster Sync
      15. Kivuto FAQ
      16. Primary and Secondary institution eligibility guidelines
  3. Set up your organization
    1. Identity types | Overview
    2. Set up identity | Overview
    3. Set up organization with Enterprise ID
    4. Setup Azure AD federation and sync
      1. Set up SSO with Microsoft via Azure OIDC
      2. Add Azure Sync to your directory
      3. Role sync for Education
      4. Azure Connector FAQ
    5. Set up Google Federation and sync
      1. Set up SSO with Google Federation
      2. Add Google Sync to your directory
      3. Google federation FAQ
    6. Set up organization with Microsoft ADFS
    7. Set up organization for District Portals and LMS
    8. Set up organization with other Identity providers
      1. Create a directory
      2. Verify ownership of a domain
      3. Add domains to directories
    9. SSO common questions and troubleshooting
      1. SSO Common questions
      2. SSO Troubleshooting
      3. Education common questions
  4. Manage your organization setup
    1. Manage existing domains and directories
    2. Enable automatic account creation
    3. Set up organization via directory trust
    4. Migrate to a new authentication provider 
    5. Asset settings
    6. Authentication settings
    7. Privacy and security contacts
    8. Console settings
    9. Manage encryption  
  5. Manage users
    1. Overview
    2. Administrative roles
    3. User management strategies
      1. Manage users individually   
      2. Manage multiple users (Bulk CSV)
      3. User Sync tool (UST)
      4. Microsoft Azure Sync
      5. Google Federation Sync
    4. Assign licenses to a Teams user
    5. Add users with matching email domains
    6. Change user's identity type
    7. Manage user groups
    8. Manage directory users
    9. Manage developers
    10. Migrate existing users to the Adobe Admin Console
    11. Migrate user management to the Adobe Admin Console
  6. Manage products and entitlements
    1. Manage products and product profiles
      1. Manage products
      2. Buy products and licenses
      3. Manage product profiles for enterprise users
      4. Manage automatic assignment rules
      5. Entitle users to train Firefly custom models
      6. Review product requests
      7. Manage self-service policies
      8. Manage app integrations
      9. Manage product permissions in the Admin Console  
      10. Enable/disable services for a product profile
      11. Single App | Creative Cloud for enterprise
      12. Optional services
    2. Manage Shared Device licenses
      1. What's new
      2. Deployment guide
      3. Create packages
      4. Recover licenses
      5. Manage profiles
      6. Licensing toolkit
      7. Shared Device Licensing FAQ
  7. Get started with Global Admin Console
    1. Adopt global administration
    2. Select your organization
    3. Manage organization hierarchy
    4. Manage product profiles
    5. Manage administrators
    6. Manage user groups
    7. Update organization policies
    8. Manage policy templates
    9. Allocate products to child organizations
    10. Execute pending jobs
    11. Explore insights
    12. Export or import organization structure
  8. Manage storage and assets
    1. Storage
      1. Manage enterprise storage
      2. Adobe Creative Cloud: Update to storage
      3. Manage Adobe storage
    2. Asset migration
      1. Automated Asset Migration
      2. Automated Asset Migration FAQ  
      3. Manage transferred assets
    3. Reclaim assets from a user
    4. Student asset migration | EDU only
      1. Automatic student asset migration
      2. Migrate your assets
  9. Manage services
    1. Adobe Stock
      1. Adobe Stock credit packs for teams
      2. Adobe Stock for enterprise
      3. Use Adobe Stock for enterprise
      4. Adobe Stock License Approval
    2. Custom fonts
    3. Adobe Asset Link
      1. Overview
      2. Create user group
      3. Configure Adobe Experience Manager Assets
      4. Configure and install Adobe Asset Link
      5. Manage assets
      6. Adobe Asset Link for XD
    4. Adobe Acrobat Sign
      1. Set up Adobe Acrobat Sign for enterprise or teams
      2. Adobe Acrobat Sign - Team feature Administrator
      3. Manage Adobe Acrobat Sign on the Admin Console
    5. Creative Cloud for enterprise - free membership
      1. Overview
  10. Deploy apps and updates
    1. Overview
      1. Deploy and deliver apps and updates
      2. Plan to deploy
      3. Prepare to deploy
    2. Create packages
      1. Package apps via the Admin Console
      2. Create Named User Licensing Packages
      3. Adobe templates for packages
      4. Manage packages
      5. Manage device licenses
      6. Serial number licensing
    3. Customize packages
      1. Customize the Creative Cloud desktop app
      2. Include extensions in your package
    4. Deploy Packages 
      1. Deploy packages
      2. Deploy Adobe packages using Microsoft Intune
      3. Deploy Adobe packages with SCCM
      4. Deploy Adobe packages with ARD
      5. Install products in the Exceptions folder
      6. Uninstall Creative Cloud products
      7. Use Adobe provisioning toolkit enterprise edition
      8. Adobe Creative Cloud licensing identifiers
    5. Manage updates
      1. Change management for Adobe enterprise and teams customers
      2. Deploy updates
    6. Adobe Update Server Setup Tool (AUSST)
      1. AUSST Overview
      2. Set up the internal update server
      3. Maintain the internal update server
      4. Common use cases of AUSST   
      5. Troubleshoot the internal update server
    7. Adobe Remote Update Manager (RUM)
      1. Use Adobe Remote Update Manager
      2. Resolve RUM errors
    8. Troubleshoot
      1. Troubleshoot Creative Cloud apps installation and uninstallation errors
      2. Query client machines to check if a package is deployed
      3. Creative Cloud package "Installation Failed" error message
  11. Manage your Teams account
    1. Overview
    2. Update payment details
    3. Manage invoices
    4. Change contract owner
    5. Change your plan
    6. Change reseller
    7. Cancel your plan
    8. Purchase Request compliance
    9. Manage your team in Adobe Express
  12. Renewals
    1. Teams membership: Renewals
    2. Enterprise in VIP: Renewals and compliance
  13. Manage contracts
    1. Automated expiration stages for ETLA contracts
    2. Switching contract types within an existing Adobe Admin Console
    3. Value Incentive Plan (VIP) in China
    4. VIP Select help
  14. Reports & logs
    1. Audit Log
    2. Assignment reports
    3. Content Logs
  15. Get help
    1. Contact Adobe Customer Care
    2. Support options for teams accounts
    3. Support options for enterprise accounts
    4. Support options for Experience Cloud

Learn how to manage multiple users via CSV bulk upload on the Adobe Admin Console.

Navigate to the Users tab in the Adobe Admin Console. To add multiple users, select Add users by CSV. To edit users, select the More Options   icon and select the relevant option.

Sign in to the Admin Console

You can also manage users individually on the Admin Console. For Federated ID or Enterprise ID type users, you can automate the user management process using the User Sync tool, or the User Management API.

Note:

The CSV files used in the procedures described in this article, may use a comma (,) or a semi-colon (;) as the separator.

Add users

Upload a comma-separated or semi-colon-separated list to add multiple users to your organization and provision them to products (for teams) or product profiles (for enterprises) at the same time. Users will receive a welcome email when they are assigned product profiles or administrative rights.

  1. On the Users tab of the Admin Console, select Add Users by CSV.

  2. Select Download CSV template and choose Current users or Standard template. Learn how to use these CSV template options:

    The current user lists contains all the users in this organization. Which means that, you should only retain the users in the CSV whose details you need to edit, and remove all other users from the CSV file. Then, for each user, only edit the details that you need to update. Leave all other values and all other columns as they were. Also, ensure that you retain all columns from the downloaded CSV.

    All fields except User name allow multiple values. Multiple values need to be comma separated.

    Examples (for Product Profiles):

    • To assign multiple Product Profiles, you needs to put them (comma-separated) in the Product Profile column.
    • If the user already had Product Profiles assigned, you will need to add the new Product Profiles after the ones already assigned. Ensure that you do not remove the Product Profiles already in the column for that user.
    • To unassign Product Profile, you need to delete them from the available list. Which means that you can assign new Product Profiles by adding them to the list, and unassign any assigned Product Profiles by removing them from the list.

    The standard template does not include the existing list of users. It includes the header row (with the field names) and two sample rows of data. This means you will need to explicitly enter all user values, for all columns. If a user is previously assigned a Product Profile and you do not enter the value for that Product Profile, the Bulk upload process will assume that you intend to remove the Product Profile, and the user will be unassigned.

    Add users by CSV

    For a description of the fields in the downloaded file, see CSV File format.

  3. Update the downloaded CSV file with the data of users that you want to add. You can add up to 25,000 users at a time (5,000 for optimal performance).

  4. Drag the updated CSV on to the Add Users by CSV dialog box and click Upload. If you have issues uploading your CSV file to the Admin Console, here's how to Troubleshoot bulk user upload.

After the bulk operation is complete, you'll receive a notification email. You can also view a detailed report via Bulk Operation Results.

In certain cases, the users you add may be prompted to select a profile (Business or Personal) when signing in to their Adobe account. Read more on how end-users can Manage Adobe Profiles.

Edit user details

As an administrator, you only have access to update details for users who belong to a domain that your organization owns. You cannot update details for users who belong to a domain that your organization trusts but does not own.

For Federated ID or Enterprise ID type users, user details can also be changed using the User Sync tool or the User Management API. The changes take effect immediately; however, the user is not notified. If you change a user's email address, inform the user to use the new email address to sign in to the Adobe enterprise account.

For Federated ID type users, changes in the email address affect the user sign-in only if email addresses have been used as the identifier in the SAML handoff between Adobe and the organization's Identity Provider. If your organization is using email addresses in the handoff, then the change in email addresses has to be done simultaneously on both sides, or users will be unable to log in to their enterprise accounts.

You can edit user details such as products, roles, and user attributes of a set of users. For example, your IT Administrator imports many new users. As the System Administrator, you can update the product provisioning for the users in a single bulk update. You can delegate license, support, or deployment administrative privileges to members of the organization in bulk. You can also change the user groups assigned to the users.

  1. On the Users tab in the Admin Console, select the More Options  icon.

  2. Select Edit User Details by CSV from the drop-down list.

  3. Select Download CSV Template, and choose Current users (recommended) or Standard template. Learn how to these CSV template options.

    For a description of the fields in the downloaded file, see CSV File format.

    • First and last name of the user
    • Country of the user
    • Username (If specified, must be the same as email)
    • Product Profiles
    • Product Profiles Administered
    • Admin Roles
    • User Groups
    • User Groups Administered
    • Products Administered
    Note:

    Editing usernames is supported in the following scenarios:

    • Enterprise ID to Federated ID directory migration (If Email is the same as user name / NameID).
    • Federated ID Email-based to Enterprise ID user name-based directory.
    • Federated ID user name-based to Federated ID Email-based directory.

    Also, if a customer configures one of these scenarios, the Adobe user name must match the value received from the customer’s IdP.

    Caution:
    • The ID column is for internal purposes only. DO NOT change the values in this column.
    • Do not remove any column from the CSV. Also, if a column has a value, only update or remove the value if you intend to do that for the user details. Like removing a Product Profile, or removing the Product Profile column would unassign the user (or users) from that Product Profile. For more, see the details below.

  5. Drag the updated CSV on to the Edit Users by CSV dialog box and select Upload.

    After the bulk operation is complete, you'll receive an email notification. You can also view a detailed report via Bulk Operation Results.

If you have issues uploading your CSV file to the Admin Console, here's how to Troubleshoot bulk user upload.

Remove users

The organization owns and manages Adobe ID, Enterprise ID, and Federated ID type user accounts. So, when you remove a user, all permissions and access to services conferred by the organization are revoked. However, if you inadvertently remove users from the Admin Console, you can go to the Directory Users list and restore the users.

Alternatively, to revoke access to products and services, without deleting any associated data, do not delete the user, instead, remove the user from any Product Profile that confers entitlements.

Note:

Federated ID and Enterprise ID type users can also be removed using Azure Sync, Google Sync, User Sync tool, or the User Management API.

  1. On the Users tab in the Admin Console, select the More Options  icon.

  2. Select Remove Users by CSV from the drop-down list.

  3. Select Download CSV Template and choose Current users (recommended) or Standard template. Learn how to these CSV template options.

    For the description of fields in the downloaded file, see CSV File format.

  4. Open the CSV file in Excel and edit the file such that it contains only rows for the users that you want to remove.

    Note:

    If your organization uses Adobe storage for business, specify the transfer options in the CSV file for each user. If these options are not specified, the default option Transfer content later is used.

  5. Drag the updated CSV on the Remove Users by CSV dialog box and select Upload.

    After the bulk operation is complete, you'll receive an email notification. You can also view a detailed report via Bulk Operation Results.

Permanently remove users and their details from the Admin Console

Removing users from the Users section and product profiles using the bulk CSV method does not remove users from the Admin Console. These users are still retained in the Directory Users list.

You can permanently bulk-delete users from Directory users section on the Admin Console.

Caution:

If you permanently delete users, the user is removed along with all the Adobe assets belonging to that user. The user and the assets then, cannot be recovered.

Bulk Operation Results

After you perform a bulk operation, like adding or editing multiple users, you receive an email with the details of the operation. In addition, you can view these details on the Bulk Operation Results page.

  • Operation: Type of operation performed: Edit users, Add users
  • Filename: Name of the uploaded file
  • Initiated By: Admin's user name
  • Started:  Date or day the upload was initiated (Larger might not complete on the same day and take some time to process)
  • Status: Completed or failed.
Note:

If a bulk operation isn't displaying on the results page, refresh your browser page or view the audit log to check the recent changes made in the Admin Console.

To view Bulk Operation Results, follow the steps:

  1. Navigate to Users > Users in the Admin Console, and select the More Options  icon.

  2. In the drop-down list, choose Bulk Operation Results.

  3. To view the details of an operation, select the name of the operation.

    Note:

    If some of the products specified in the upload file, were purchased under the VIP program, and the licenses for these products have been consumed, these product licenses will not be assigned to the users. For details on the deficit of product licenses, click View deficit report.

  4. To download the results as a CSV file, select Download Results.

  5. To remove a result, select the checkbox to the left of the operation name and select Remove Result. You can also clear all the bulk operation results by selecting Clear All Results.

If there is bulk operation failure, see how to Troubleshoot bulk user upload. You can also ask experts or other admins in our community.

Note:

The Bulk Operation Results page displays reports that are 90 days old or less. Reports that are more than 90 days old are automatically removed.

CSV file format

The template file that you download, contains sample data that you can use as a guide.

Caution:
  • The CSV file must have only one row per email+identity type combination.
  • If you need to have user names with commas included, your CSV file must use a semi-colon as the separator. And, if you need to have user names with semi-colons included, your CSV file must use a comma as the separator.
  • The CSV file that you upload does not support user names having special characters, such as the comma (,) and the semicolon (;).

Field Name

Description

Required/Optional for identity types 

Identity Type

Enter the type of user to add.

These values control the ID type assigned to the user. Not case sensitive. The ID type must be valid for the domain.

Valid values:

  • Federated ID
  • Enterprise ID
  • Adobe ID

Optional.

If field is empty, defaults to Adobe ID

Username

Restricted to ASCII.

User name as it corresponds to the respective user ID.

For Adobe ID type users, the user name that is defined for the Adobe ID of the user.

Only used in Enterprise administered domains. Account name to be used for this user. Restrictions to an email address and same email address can be imposed by the domain owner. 

Maximum length is 255 characters.

Edit user details by CSV:

Editing user names is supported in the following scenarios:

  • Enterprise ID to Federated ID directory migration (If Email the same as user name / NameID).
  • Federated ID Email-based to Enterprise ID user name-based directory.
  • Federated ID user name-based to Federated ID Email-based directory.

Also, if a customer configures one of these scenarios, the Adobe user name must match the value received from the customer’s IdP.

To update user names, you'll need to specify the values for the ID column. To get these values for each existing user, we recommend that you download the Current user list.

Enterprise ID and Federated ID: Optional. If specified, must be same as Email or as specified as domain owner.

Adobe ID: Optional. If specified, must be same as Email.

Domain

The domain name as specified in the user's Email address.

Optional.

If field is empty, Email address domain is used.

Email

Valid email address.

60 character maximum.

If Identity type is Enterprise ID or Federated ID, the domain must be claimed, activated by the organization and linked to a directory of the type specified in the first field. For details, see Setup user identity in the Admin Console.

For Adobe ID, it is the email address used for the user and account name. 

See RFC 2822 sec 3.4.1

Required

First Name

First Name of the user.

For Adobe ID type users, the first name that is defined for the Adobe ID of the user.

Maximum length is 255 characters.

Restricted to ASCII.

Note: We support the use of the extended list of ASCII characters, which includes letters commonly used in European names such as ü, é and ß.

Optional

Last Name

Last name of the user.

For Adobe ID type users, the last name that is defined for the Adobe ID of the user.

Maximum length is 255 characters.

Restricted to ASCII.

Note: We support the use of the extended list of ASCII characters, which includes letters commonly used in European names such as ü, é and ß.

Optional

Country Code

A two-letter country code (for example, United States = "US").

For Adobe ID type users, enter the country code that is defined for the Adobe ID of the user.

If present, check to ensure that the user is from a country where Adobe does the business. It is present for Enterprise administered accounts.

To determine the Country Code, see https://www.iso.org/obp/ui/#home.

For more information, see ISO 3166-1 alpha-2 Country Codes. 

Required.
Enterprise ID, and Federated ID: 

ID

Do not make changes to the values in this column.

See details in the Username column description, above.

For internal purposes only

Product Configurations

The product profiles to which you want to assign the user.

A comma-separated list of one or more product profile names to assign to the user exactly as they appear in the Admin Console.

For example: "Adobe AudienceManager - Default Access: Audience Manager, All Apps - 100 GB - Default configuration"

Optional.

Note: If left empty, end users will not be given entitlements to apps.

Leave empty for admins who do not require app entitlements.

Admin Roles

Administrative role to assign to the user.

Valid values:

  • System
  • Deployment
  • Support

Optional.

Product
Configurations Administered

The names of the Product Profiles to grant administrative privileges to the user.

To assign administrative privileges for multiple product profiles, enter all the desired profile names in quotes, separated by commas.

Optional

User Groups

The names of the User Groups to add the user.

To add the user to multiple groups, enter all the desired group names in quotes, separated by commas.

Optional

User Groups Administered

The names of the User Groups to grant administrative privileges to the user.

To assign administrative privileges for multiple groups, enter all the desired group names in quotes, separated by commas.

Optional

Products Administered

The names of the Products to grant administrative privileges to the user.

To assign administrative privileges for multiple products, enter all the desired product names in quotes, separated by commas.

Optional

Developer Access

(For developers only)

The names of the Product Profiles of products that include API access to which the developers are added.

For details regarding developers, see Add multiple developers (in bulk) section in this document.

Optional

Auto Assigned Products

Contains the names of any auto assigned products (such as Adobe Express or Credit packs for Adobe Stock) in the exported user list.

We recommend that you do not make changes to the values in this field, or do not enter any values, if this field is blank. Any changes made to the values in this field are disregarded by the Bulk upload workflows. However, since this field is not mandatory, Bulk import will work even if the field is not included in the CSV.

Do Not Update

Field Name

Description

Required / Optional

Email

Valid email address.

60 character maximum.

See RFC 2822 sec 3.4.1

Required

First Name

First Name of the user.

Restricted to ASCII.

Maximum length is 255 characters.

 

Optional

Last Name

Last name of the user.

Restricted to ASCII.

Maximum length is 255 characters.

 

Optional

Admin Roles

Admin role to assign to the user.

Valid values:

  • System

Optional

User Groups

The names of the User Groups to add the user.

To add the user to multiple groups, enter multiple group names in quotes, separated by commas.

Optional

Team Products

The names of the Team Products to assign to the user.

To assign the user to multiple team products, enter multiple product names in quotes, separated by commas.

For example, "Audience Management: Audience Manager - Default Access, the Custom plan only - Custom plan - Design"

Optional.

Note: If left empty, end users will not be given entitlements to apps.

Leave empty for admins who do not require entitlements.

More like this

 Adobe

Get help faster and easier

New user?

Quick links

View all your plans Manage your plans
View quick links
Hide quick links
Adobe MAX 2024

Adobe MAX
The Creativity Conference

Oct 14–16 Miami Beach and online

Register Now

Adobe MAX

The Creativity Conference

Oct 14–16 Miami Beach and online

Register Now
Adobe MAX 2024

Adobe MAX
The Creativity Conference

Oct 14–16 Miami Beach and online

Register Now

Adobe MAX

The Creativity Conference

Oct 14–16 Miami Beach and online

Register Now

Legal Notices    |    Online Privacy Policy