Creating new user accounts in Microsoft 365 for onboarding users is one of the crucial bulk provisioning tasks for administrators. With Office 365 Manager’s User Management module, you can easily create new users in Azure AD from a CSV file without using a PowerShell script. When creating the user accounts, you can specify a custom or random password. Also, supports assigning a manager and license along with other user properties and settings.
- Supported User Attributes in Bulk User Creation
- Download the CSV Template file for Bulk User Creation
- How to Bulk Create Users in Azure AD using a CSV file
Supported User Attributes in Bulk User Creation
With this application, you can provide/input the following user profile attributes, and associated settings for the new users to be created from a CSV file.
- Required fields: UserPricipalName and DisplayName.
- User basic profile information (e.g., First name, Last name, Job title, Department, Company name, Employee ID, and more). A complete list of supported fields can be found in the sample template CSV file.
- Account Status: Allows to specify whether the new user’s account is enabled or set to block sign-in status. Use the ‘AccountEnabled’ field with values True or False.
- Manager: Allows to set a manager for each new user by providing the manager’s UPN value.
- Microsoft 365 License: You can assign one or more licenses to a user by providing the required license’s display name or license SKU name. If you plan to assign multiple licenses, you can input the license names as comma-separated values.
- Password: You can set a custom password for each user. If you do not provide a password, the tool will generate a random password and assign it to the user.
- ForceChangePasswordNextSignIn: By default, this flag is set to True, requiring users to change their password upon their first sign-in, whether a custom or random password is used. However, if you wish to allow users to reset their password at their own convenience when using a custom password, you can include this field in your CSV file and set it to False.
Download the CSV Template file for Bulk User Creation
Within the application’s user interface, you’ll find a link to download a sample CSV template file. Utilize this option to obtain the sample CSV template file. The CSV template file includes most of the supported fields. If you wish to include additional attributes or implement custom functionality in user creation, please get in touch with our support team for assistance.
How to Bulk Create Users in Azure AD Using a CSV file
Here are the steps to create multiple user accounts in Azure Active Directory by importing user details from a CSV file:
- Launch the Office 365 Manager app‘s user interface console.
- Navigate to the Azure AD page, which is the default page when you open the application.
- Inside the Office 365 Users tab, click on Create and then select Create Bulk Users.
- Within the UI for the “Create Bulk Users” action, click on the Download sample CSV file link to obtain a CSV template file.
- Replace the user details in the sample CSV file with the information of your new users, or modify your existing CSV file to match the format of the template CSV file.
- 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 initiate the bulk user creation process.
- Monitor the progress and status of the action in the result window. You can then export the action results, which include the new user details along with their passwords.
