OpeningClouds
Adding Bulk Users to Office 365 via Portal
Updated: Feb 8, 2019
In our previous post we went over how to get your users on Office 365 by creating users on the Portal. Well that was tedious, one at a time, that will take way to much time for you to do. Thankfully we can bulk add users to the tenant, here is how we do that.
Borrowing from the past posts lets go back to the logon page HERE.

Enter your credentials to log on

On the landing page for the tenant click Users, Active Users

In Active Users click the More box.

Click Import multiple users

Now here is the fun part. You are going to download a file from the Portal. Because you are new to this its recommended to Download a CSV file with headers only.

With the file open, you are going to have to fill in the following information for your users. The first 4 are MANDITORY while the others are optional and useful.
User Name. How do you want your users to log on to your tenant. Like the last post its your choice how to name your users as long as they are UNIQUE and includes the tenants email address, or Vanity domain.
First Name . Users First name or Given name
Last Name. Users Last name or Surname
Display Name. How you want the users name Displayed
Job Title. Users Job title
Department. Users Department
Office Number.
Office Phone. Users Office phone number
Mobile Phone. Users Mobile phone number
Fax. Office Fax number
Address. Office Street Address
City. City where the Office is located
State or Province. State or P
Province where office is located
ZIP or Postal Code. Office ZIP or postal code
Country or Region. Country or Region where office is located
The file you downloaded is a .CSV or comma delimited file. Its very basic where the data above is laid across the file in headers (top row of a column).

Fill in the info you want for your users and save it. Save it someplace you want to get it again. You will probably use it again.
Back in the portal you are now going to take the file you created and upload it into the portal.
You are going to click Browse here and locate the file you created.


Its always good to verify the file, you could have an error in it.

In this case there was an extra line in the file with no data, so it errored out. After fixing the file and a good verify you can proceed

Click Next

The process isn't completely automatic, you still have to assign users licenses. You can choose NOT to assign licenses at the bottom as well but you want your users up and running as fast as you can have them.

Results ! All users were created and an Email will be send to the admin with their automatically generated passwords. Click Send and Close

Your instance how has more users in the portal. You will either have to assign licenses or other services to the users but at least you have a starting point now for them.
Sample email from the Portal to the Admin you chose to get the mail.


Hope you see the value of bulk additions. Its a little more work in Excel but in the end its less work in the Portal. Good luck !