Modifying user account attributes, roles, and settings within Microsoft 365 is a crucial task for any organization, especially when an employee is assigned to a new role, relocates to a different place, or for other reasons.
Office 365 Manager’s User Management module allows you to update or modify multiple attributes for bulk users in Azure AD from a CSV file, eliminating the need for a PowerShell script. In addition to updating user properties and settings, you can also set a new manager and assign a new license.
- Features Supported in Bulk Users Update
- Download a CSV Template file for Bulk Users Update
- How to Update or Modify Bulk Users in Azure AD with a CSV file
Features Supported in Bulk Users Update
The application provides support for modifying the following user profile attributes and associated settings using a CSV file.
- Required fields: UserPricipalName – This field serves as the unique identifier for the user to be modified.
- Modify user profile information: Supports the updating of user profile attributes, including job title, department, company name, office location, phone number, address, and more. You can refer to the sample template CSV file for a complete list of supported fields.
- Assign/Reset Manager: Allows to set a new manager for each user by supplying the manager’s UPN value.
- Assign License: You have the option to assign a new Microsoft 365 license to users by specifying either the desired license’s display name or license SKU name. If you intend to assign multiple licenses, you can enter the license names as comma-separated values.
- Remove License: You can remove the previously assigned license(s) from users.
- Re-assign/Replace License: Allows to replace an existing license with a new one without impacting any of the licensed features. For example, you can replace the Microsoft E3 license with the Microsoft E5 license in a single operation.
- Change Account Status: Modify the user account’s enabled status (Allow or block sign-in) by setting the ‘AccountEnabled‘ field to either True or False.
- Bulk Password Reset: You can reset custom passwords for multiple users. After the password change, users are prompted to reset their password upon their next sign-in. However, if you wish to permit users to reset their passwords at their own convenience, you can include the ForceChangePasswordNextSignIn field in your CSV file and set it to False.
- Clear Property or Set Null value: In addition to assigning a new value to the required attribute field, the application also allows you to remove or clear a property or set it to NULL.
Download a CSV Template file for Bulk Users Update
You can download the sample CSV template file from the application UI console. This CSV template file includes most of the supported fields. If you want to include additional attributes or implement custom functionality for bulk user updates, please contact our support team for assistance.
How to Update or Modify Bulk Users in Azure AD with a CSV file
Follow the below steps to update multiple user accounts in Microsoft Office 365 by importing new attributes and settings from a CSV file:
- Open the UI console of the Office 365 Manager app.
- Go to the Azure AD page, which is the default page when you open the application.
- Inside the Office 365 Users tab, click on Edit User and then select Modify Bulk Users using CSV.
- In the next UI pop-up, click on the “Download sample CSV file” link to download a CSV template file.
- Replace the user details in the provided sample CSV file with your users’ information, or modify your existing CSV file to match the format of the template CSV file.
- In the CSV file, leaving a field value empty will retain the existing value for that specific field and user. The application will not make any changes if the field value is empty. If you wish to intentionally remove or clear a property value, set the text to NULL.
- Click the Browse button to select your CSV file. This action will load the CSV file details into the grid.
- Finally, click the Update button to start the bulk user update process.
