Skip to content

Latest commit

 

History

History
106 lines (70 loc) · 5.81 KB

users-bulk-add.md

File metadata and controls

106 lines (70 loc) · 5.81 KB
Raw
title description author ms.author manager ms.date ms.topic ms.service ms.subservice ms.custom ms.reviewer
Bulk create users in the Azure portal
Add users in bulk in Microsoft Entra ID
barclayn
barclayn
amycolannino
07/01/2024
how-to
entra-id
users
it-pro
jeffsta

Bulk create users in Microsoft Entra ID

Microsoft Entra ID, part of Microsoft Entra, supports bulk user create and delete operations and supports downloading lists of users. Just fill out comma-separated values (CSV) template you can download from Microsoft Entra ID.

Required permissions

In order to bulk create users in the administration portal, you must be signed in as at least a User Administrator.

Understand the CSV template

Download and fill in the bulk upload CSV template to help you successfully create Microsoft Entra users in bulk. The CSV template you download might look like this example:

:::image type="content" source="./media/users-bulk-add/create-template-example.png" alt-text="Screenshot of spreadsheet for upload and call-outs explaining the purpose and values for each row and column.":::

Warning

If you are adding only one entry using the CSV template, you must preserve row 3 and add your new entry to row 4.

Ensure that you add the .csv file extension and remove any leading spaces before userPrincipalName, passwordProfile, and accountEnabled.

CSV template structure

The rows in a downloaded CSV template are as follows:

  • Version number: The first row containing the version number must be included in the upload CSV.
  • Column headings: The format of the column headings is <Item name> [PropertyName] <Required or blank>. For example, Name [displayName] Required. Some older versions of the template might have slight variations.
  • Examples row: We have included in the template a row of examples of acceptable values for each column. You must remove the examples row and replace it with your own entries.

Additional guidance

  • The first two rows of the upload template must not be removed or modified, or the upload can't be processed.
  • The required columns are listed first.
  • We don't recommend adding new columns to the template. Any additional columns you add are ignored and not processed.
  • We recommend that you download the latest version of the CSV template as often as possible.
  • Make sure to check there is no unintended whitespace before/after any field. For User principal name, having such whitespace would cause import failure.
  • Ensure that values in Initial password comply with the currently active password policy.

To create users in bulk

  1. Sign in to the Microsoft Entra admin center as at least a User Administrator.

  2. Select Microsoft Entra ID.

  3. Select All users > Users > Bulk create.

  4. On the Bulk create user page, select Download to receive a valid comma-separated values (CSV) file of user properties, and then add users you want to create.

    :::image type="content" source="./media/users-bulk-add/upload-button.png" alt-text="Screenshot showing how to select a local CSV file in which you list the users you want to add.":::

  5. Open the CSV file and add a line for each user you want to create. The only required values are Name, User principal name, Initial password and Block sign in (Yes/No). Then save the file.

    :::image type="content" source="./media/users-bulk-add/add-csv-file.png" alt-text="Screenshot showing an example of the CSV file containing the names and IDs of the users to create.":::

  6. On the Bulk create user page, under Upload your CSV file, browse to the file. When you select the file and click Submit, validation of the CSV file starts.

  7. After the file contents are validated, you’ll see File uploaded successfully. If there are errors, you must fix them before you can submit the job.

  8. When your file passes validation, select Submit to start the bulk operation that imports the new users.

  9. When the import operation completes, you'll see a notification of the bulk operation job status.

If you experience errors, you can download and view the results file on the Bulk operation results page. The file contains the reason for each error. The file submission must match the provided template and include the exact column names. For more information about bulk operations limitations, see Bulk import service limits.

Check status

You can see the status of all of your pending bulk requests in the Bulk operation results page.

:::image type="content" source="./media/users-bulk-add/bulk-center.png" alt-text="Screenshot showing how to check the status of the operation in the bulk operations results page.":::

Next, you can check to see that the users you created exist in the Microsoft Entra organization either in the Azure portal or by using PowerShell.

Verify users

  1. Sign in to the Microsoft Entra admin center as at least a User Administrator.
  2. Select Microsoft Entra ID.
  3. Select All users > Users.
  4. Under Show, select All users and verify that the users you created are listed.

Verify users with PowerShell

Run the following command:

Get-MgUser -Filter "UserType eq 'Member'"

You should see that the users that you created are listed.

Bulk import service limits

[!INCLUDE Bulk operations limitations]

Next steps