Create Bulk Users in Office 365 (from CSV File)

SharePoint Online training courses

This Office 365 tutorial explains, how to create bulk users in Office 365 from a CSV file. This way we can able to add more users in the Office 365 admin center. This is one efficient way to create more than one user is Office 365 from a CSV file or Excel spreadsheet.

Add multiple users to Office 365 – Video tutorial

Subscribe to EnjoySharePoint YouTube channel for more videos.

Now we will see at a time how to add the bulk amount of the users in Office 365. Follow the below process to add multiple users to the admin center of Office 365.

Go to office 365 Admin center. Under the Home option, we can able to see Users option. In the user option, click on “Active users“, which will display all the active users in Office 365.

In the “Active users” click on More -> “Import multiple users”.

import csv to office 365
import CSV to office 365

It will open the Import multiple users page, where you have to download a CSV file. Add all your user’s details and then you can upload here on the same page.

Here there are two CSV files are there:

  • Download a CSV file with headers only
  • Download a CSV file with headers and sample user Information

The second file contains some sample user Information also which you download to check how you should enter user information.

Download “download the CSV file with headers only” file.

how do I add another user to office 365 office 365 bulk user import csv
create bulk users in office 365 admin center

Add all your user details in the CSV file and save the file and upload it again.

create bulk users in office 365
create bulk users in office 365

Come to the Import multiple users page. Go to Browse the csv from the computer and click on verify to check the error. Here there is no error. Click on Next.

create bulk users in office 365
create bulk users in office 365

Now in the “Set user options” two radio buttons are there “Sign-in-allowed” and “Signed-in-blocked”. If we blocked the signed in then created user could not able to log in. Here I have chosen the Sign-in allowed option. Now enable the license which you want to give. Here I have enabled the office 365 enterprise E3 developer.

create bulk users in office 365 admin center
create bulk users in office 365 admin center

We can able to see the message “2 users created”. Click on Send and close.

create bulk users in office 365 admin center
create bulk users in office 365 admin center

You may like following Office 365 tutorials:

In the above article, we were discussed how to add or create a bulk amount of user to Office 365 admin center.

>