Bulk user create and group assignment ?

Question

Every now and then i need to create bulk users in my office 365 tenant, and then i need to manually add these users into their respective departmental office 365 groups.

I was just thinking is there a possibility of doing both at once? like if i am adding 50 users with a csv file is it possible to add them to a particular group at the same time ?

Kind Regards

Faisal Gillani

Answer 1

Dear Faisal Gillani,

Thanks for choosing Microsoft Community.

As you mentioned like if i am adding 50 users with a csv file is it possible to add them to a particular group at the same time, I would like to share some information with you.

To create users in bulk

1. Sign in to your Azure AD organization with an account that is a User administrator in the organization.
2. In Azure AD, select Users > Bulk create.
3. On the Bulk create user page, select Download to receive a valid comma-separated values (CSV) file of user properties, and then add users you want to create.

1. Open the CSV file and add a line for each user you want to create. The only required values are Name, User principal name, Initial password and Block sign in (Yes/No). Then save the file. Note: The value Department

1. On the Bulk create user page, under Upload your CSV file, browse to the file. When you select the file and click Submit, validation of the CSV file starts.
2. After the file contents are validated, you’ll see File uploaded successfully. If there are errors, you must fix them before you can submit the job.
3. When your file passes validation, select Submit to start the Azure bulk operation that imports the new users.
4. When the import operation completes, you'll see a notification of the bulk operation job status.

To bulk import group members

1. Sign in to the Azure portal with a User administrator account in the organization. Group owners can also bulk import members of groups they own.
2. In Azure AD, select Groups > All groups.
3. Open the group to which you're adding members and then select Members.
4. On the Members page, select Import members.
5. On the Bulk import group members page, select Download to get the CSV file template with required group member properties.
6. Open the CSV file and add a line for each group member you want to import into the group (required values are either Member object ID or User principal name). Then save the file.
7. On the Bulk import group members page, under Upload your csv file, browse to the file. When you select the file, validation of the CSV file starts.
8. When the file contents are validated, the bulk import page displays File uploaded successfully. If there are errors, you must fix them before you can submit the job.
9. When your file passes validation, select Submit to start the Azure bulk operation that imports the group members to the group.
10. When the import operation completes, you'll see a notification that the bulk operation succeeded.

For conference:

Bulk create users in the Azure Active Directory portal - Microsoft Entra | Microsoft Learn

Bulk upload to add or create members of a group - Azure Active Directory - Microsoft Entra | Microsoft Learn

I hope that information can help you. Thanks for your precious time. Have a good day!

Sincerely,

Tammy | Microsoft Community Moderator