How to Bulk Create Microsoft 365 Users and Add Them to Groups
Question details
The user needs to know how to create multiple Microsoft 365 user accounts simultaneously using a CSV file and how to assign these newly created users directly into specific Microsoft 365 groups.
- Product
- Microsoft 365
- Device & OS
- not provided
- Scenario
- Enterprise administration and user onboarding
- Observed behavior
- Administrators require an efficient, automated method for provisioning new user accounts and managing group assignments via CSV imports instead of manually creating accounts one by one.
Ensure you have administrative privileges, such as the Global Administrator or User Administrator role, in your Microsoft Entra ID (formerly Azure AD) or Microsoft 365 admin center before attempting to execute bulk operations.
Use the Azure Portal to Bulk-Create Users and Import Group Members
Since group assignment cannot be done in the same step as user creation, you must first bulk create the users and then run a separate bulk import to add them to a group.
Microsoft 365 (via Azure Active Directory / Microsoft Entra ID) splits this process into two separate tasks. You will need to download and fill out two different CSV templates provided by the portal: one for creating the accounts, and another for adding members to the target group.
Sign in to the Azure AD / Entra portal. Navigate to 'Azure AD', select 'Users', and then click on 'Bulk create'.
Click 'Download' to get the CSV template for user creation. Open it and fill in the required user details, including Name, User Principal Name, Initial Password, and Block sign in (Yes/No). Save the file when done.
Return to the Azure portal, upload your completed CSV file, wait for the data to validate successfully, and click 'Submit' to create the user accounts.
Navigate to 'Azure AD', select 'Groups', and click on 'All groups'. Find and open the specific group you want to add your new users to.
Inside the group profile, select 'Members' from the left menu, then click 'Import members'. Download the group member CSV template, add the newly created users' object IDs or user principal names, upload the completed file, and submit.
Equip Your New Users with WPS Office Instead of Expensive M365 Licenses
After bulk-creating user accounts, providing expensive Microsoft 365 licenses to every individual can severely strain your IT budget. WPS Office is a lightweight, fully compatible free alternative that provides powerful Word, Excel, and PowerPoint replacements.
- 1. Download WPS Office: Visit the official WPS Office website to download the free installation package for your team's operating systems.
- 2. Deploy to Workstations: Distribute and install the lightweight software on the newly provisioned users' devices.
- 3. Start Working Instantly: Users can immediately open, edit, and share standard Microsoft Office document formats without needing an active Microsoft 365 subscription.
Frequently Asked Questions
Can I assign users to groups directly within the bulk create user CSV file?
No, Azure AD does not support assigning group memberships directly in the bulk user creation CSV file. You must first successfully create the users, and then use the separate bulk import members feature in the Groups section.
What fields are mandatory in the Azure AD bulk user creation CSV?
The minimum required fields are Name, User Principal Name (UPN), Initial password, and Block sign-in. Be sure not to alter or remove the template headers.
Is there a maximum limit for bulk importing users at one time?
Yes, Microsoft limits bulk operations via CSV in Azure AD to 50,000 records per file. For larger deployments, you will need to split the data into multiple CSV files.
How can I check if the bulk user creation and group import were successful?
You can monitor the status of your bulk requests by navigating to 'Users' > 'Bulk operation results' in the Azure portal. This dashboard displays the progress, success rate, and any specific error logs for each row in the uploaded CSV.
