Add multiple users with bulk import


You can import multiple user accounts into Microsoft Office 365 for enterprises from a single file source. The file must be a comma-separated values (CSV) file and adhere to the required format.

What do you want to do?

  • Learn about CSV files

  • Add users with bulk import

About CSV files

A CSV file is an easy way to transfer a large amount of data between programs. It is a plain-text file that stores database-style information in a special format. The format requires one record on each line. Fields within records must be separated by commas.

You can use the Bulk add users wizard to upload an existing CSV file, or you can use the provided blank CSV template and edit it in a text editor, such as Notepad. The template contains user data column labels under which you enter information about the users that you want to import. The wizard also includes a sample CSV file that provides a correctly formatted example containing sample user data.

When you create a CSV file, you can enter user data column labels in any language or characters, but the order of the labels as shown in the sample is important for the correct fields to be populated. You can then make entries into the fields, using any language or characters, and save your file in a Unicode or UTF-8 format.

The minimum number of rows is two, including the first row of user data column labels (the second row is a user). The maximum number of rows is 251, including the first row of user data column labels. Only the user name and display name are required entries. If you need to import more than 250 users, create multiple CSV files. The following table shows the user data column labels and maximum character length for each in the sample CSV file.


When you create or edit a CSV file, use Notepad or another simple text editor to avoid potential file processing problems.

User data column label Maximum character length

User Name (Required)

The maximum total length of the user name is 79 characters (including @ symbol), in the format name@domain.<extension>. The user’s alias cannot exceed 30 characters and the domain name cannot exceed 48 characters.

First Name


Last Name


Display Name (Required)


Job Title




Office Number


Office Phone


Mobile Phone








State or Province


ZIP or Postal Code


Country or Region


Add users with bulk import


  • If you are importing users from different countries or regions, we recommend creating a separate CSV file for each country or region and performing a bulk import operation for each CSV file. This is because you will be indicating the location of the users in the CSV file as part of this import process, and only one location can be selected per bulk import operation.

  • Make sure that the User Name column of your CSV file contains the full email address (for example, for each of your users, or you will receive an error when you upload the file.

To add multiple users using a CSV file, do the following.

  1. In the header, click Admin.

  2. In the left pane, under Management, click Users.

  3. On the Users page, click the arrow next to New, and then click Bulk add.

  4. On the Select a CSV file page, do one of the following, and then click Next.

    • Click Browse to specify an existing CSV file on your computer.

    • Click Download a blank CSV file to create a CSV file using the template provided. Save the file to your computer when you have finished, and then click Browse to specify the file that you just created.

    • Click Download a sample CSV file to open a correctly formatted example containing sample user data. If you create your CSV file from this sample file, save the file to your computer when you have finished inserting your data, and then click Browse to specify the file that you just created.


    Do not add, change, or delete column labels in the CSV template or sample file, and make sure that you save the file with a .csv extension, or the file may not upload correctly.

  5. On the Verification results page, confirm that there are no errors in your CSV file and that the number of users to import is correct. To review errors in the log file, click View. If you have errors in your CSV file, click Back. Open your CSV file and make the corrections, and then perform step 4 again. Once your CSV file has passed verification, click Next.


    • This is a verification step only. Users are not added at this point.

    • If you must perform step 4 again to correct the CSV file, click Browse again to reattach the updated CSV file, even though the file is still selected under path and file name.

  6. On the Settings page, under Set sign-in status, select Allowed to allow users to sign in to Office 365 and access licensed services, or Blocked to block users from signing in to Office 365 and accessing licensed services. Under Set user location, select the users’ work location, and then click Next.

  7. On the Assign licenses page, select the licenses that you want to assign to all of the users being imported, and then click Next.

  8. On the Send results in email page, select Send email to send a user name and temporary password for the added users to yourself and/or recipients of your choice. Enter email addresses separated by semicolons (;), and then click Create.


    You can enter a maximum of five email addresses.

  9. On the Results page, a list of successfully imported users and their temporary passwords is displayed, as well as any errors that occurred during the import process. If a user was not imported, there will be a status message indicating the reason. If you chose not to send yourself this information by email, you can click View to open the log file, and then print or save the information.

  10. When you have finished reviewing the results, click Close.


    Changes may take time to apply across multiple services.

See Also

Activate synced users
Create or edit users