How to Add multiple users with a CSV file to Office 365

Add multiple users with a CSV file:

You can add multiple user accounts to Office 365 at the same time with a CSV (comma-separated values) file.

1.      Click Admin > Office 365 > Users and groups.

2.      Click Bulk add 

3.      On the first page of the Bulk add users wizard, click download a sample CSV file.

4.      Open the file with notepad

5.      Change the user name of all the users from @contoso.com to @yourdomain.onmicrosoft.com (where yourdomain is the domain name you had created).

6.      Save the file.

7.       Now click next in the Bulk add users wizard and upload the file and click next

8.     Verify whether the check completes without any errors and click Next.

9.      In the Settings page, Select the User location and click next.

     

10.Assign the required licenses and Click Next

11. Click Create. 

Note

You can assign the “password administrators” role to designated individuals. Password administrators can reset passwords but do not have the authority to make other changes in the Office 365 administration portal.