Bulk Password Reset of Microsoft 365 Users using CSV File

You can use the Microsoft 365 admin center to reset passwords for users. While the admin center offers various management tasks, it may not always be suitable for performing actions in bulk. Specifically, setting custom passwords for multiple Azure AD users can be a complex task, and often need to use PowerShell script to achieve the desired custom functionality.

Specmasoft’s Office 365 Manager is a desktop-based user management tool that helps you reset passwords for both individual and multiple users. Also, it provides the capability to set custom passwords for each user individually by importing the necessary users and their corresponding new passwords from a CSV file.

Steps to Set Custom Password for Multiple Users using CSV File

To import users along with their new passwords from a CSV file and reset their passwords in bulk, please follow the steps below:

  • 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.
  • This action is designed to update all properties and settings of Azure AD users in bulk, so the sample template CSV file might not include fields related to passwords. You can download the CSV template file from this link: Bulk Password Reset CSV Template.
  • Replace the user details (UserPrincipalName) and assign a custom password to each user in the CSV template file you’ve downloaded, or adapt your existing CSV file to match with the template CSV file.
  • After the password change, users will be forced to reset their password during their first sign-in. However, if you prefer to allow users to reset their passwords at their own convenience, you can include the ForceChangePasswordNextSignIn field in your CSV file and set it to False.
  • Click the Browse button to choose your CSV file, which will then import the CSV file details into the grid.
  • Finally, initiate the bulk password reset process by clicking the Update button.
  • Monitor the progress and status of the action in the result window. Once the action is completed, you can then export the action results, which include the user details along with their new passwords.
Steps to Reset Password for Bulk Microsoft 365 Users using CSV File

How to Set Random Passwords for Bulk Users

The steps above assist you in setting custom passwords for each user individually by importing their details from a CSV file. If you prefer to assign auto-generated random passwords to multiple users, whether by selecting users from the report grid or through a CSV file, the tool provides another feature: Reset Password for Multiple Users in Microsoft 365