In this blog post, I describe in detail how to import bulk user accounts to Office 365 from a CSV file.

Step 1: To begin, log into your Office 365 site using an Admin account. Next, go to the Office 365 admin center. Expand the Users section on the Dashboard and select the Active Users menu. See the image below.

Step 2: Click on the Bulk add icon as shown below.

Step 3:  Click on the Browse button and open to CSV file. If you don’t have a CSV file, you can download one by clicking the Download a blank CSV hyperlink.

Next, enter information in the CSV file as shown below. And open to file.

Step 4: Click on the Next button.

If there is no error, the CSV file is ok. However, if there are errors, you will need to check the CSV file again to make sure that the information in the CSV file is exact.

Step 5: Click on the Next button again. Configure Sign-in Status and Select User Location.  Click Next.

Step 6: Enter your email address in the field. All account information will be sent to this email after users are successfully created. Click Create.

You will get a message that the new users were successfully created.  The message will include the new user’s information.

Click Close. You will see all accounts are updated on the Active Users page.

Questions? Contact us.