Microsoft Entra ID

Bulk create users in the Azure portal

1 October 2026Doc update+23 / −29 lines

In brief

The documentation now requires preserving downloaded column headings, allows the examples row to remain, and identifies only Name, User name, and Initial password as required fields. The sample CSV was simplified.

What Entra admins need to know

Administrators preparing bulk-user CSV files should follow the revised template instructions, including the updated required-column guidance.

This editorial summary was generated by AI from the documentation changes. Verify important details in the full Microsoft Learn article.

Documentation change

View full page diff

View on Microsoft Learn

The comparison below shows only the changed extract. Use the full-page view for complete context.

Bulk create users in Microsoft Entra ID

Overview

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

Required permissionsPrerequisites

~~In order to~~To bulk create users in the ~~administration portal, you must be signed~~Microsoft Entra admin center, sign 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~~a bulk create CSV template with the required Name, User name, and ~~call-outs explaining the purpose and values for each row and column.~~Initial password columns.":::

CSV template structure

The rows in a downloaded CSV template are as follows:

Version number: The first row containing the version number (for example, version:v1.0) must be included in the upload CSV. If your downloaded template includes this row, don't remove or modify it.
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: The template might include a row of example values for each column. You must remove the examples row and replace it with your own entries.

[!INCLUDE bulk-operations-csv-template-note]

Additional guidance

~~Here's an example of a completed CSV file ready for upload:~~

version:v1.0
Name [displayName] Required,User name [userPrincipalName] Required,Initial password [passwordProfile] Required,Block sign in (Yes/No) [accountEnabled] Required,First name [givenName],Last name [surname],Job title [jobTitle],Department [department],Usage location [usageLocation],Street address [streetAddress],State or province [state],Country or region [country],Office [physicalDeliveryOfficeName],City [city],ZIP or postal code [postalCode],Office phone [telephoneNumber],Mobile phone [mobile]
Alain Charon,[email protected],Password1!,No,Alain,Charon,Software Engineer,Engineering,US,,,,,,,
Isabella Simonsen,[email protected],Password1!,No,Isabella,Simonsen,Product Manager,Product,US,,,,,,,
Joseph Price,[email protected],Password1!,No,Joseph,Price,Sales Representative,Sales,US,,,,,,,

CSV template structure

The rows in a downloaded CSV template are as follows:

Column headings: Preserve the column headings exactly as downloaded. The required columns are Name [displayName] Required, User name [userPrincipalName] Required, and Initial password [passwordProfile] Required.
Examples row: You can keep the examples row in the CSV file. Add the users that you want to create on the following rows.

Additional guidance

Here's an example of a completed CSV file ready for upload:

Name [displayName] Required,User name [userPrincipalName] Required,Initial password [passwordProfile] Required
Chris Green,[email protected],Example-Password-Only!1
Alain Charon,[email protected],Example-Password-Only!1
Isabella Simonsen,[email protected],Example-Password-Only!1
Joseph Price,[email protected],Example-Password-Only!1

Create users in bulk

Sign in to the Microsoft Entra admin center as at least a User Administrator.
Browse to Entra ID > Users > Bulk 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.":::
Open the CSV ~~file~~file, preserve the column headers exactly as downloaded, 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)~~Initial password. 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.":::~~
On the Bulk create user page, under Upload your CSV file, browse to the file. When you select the file and select Submit, validation of the CSV file starts.
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.

[!INCLUDE Bulk operations limitations]

Next stepsRelated content

@@ -1,43 +1,40 @@ --- title: Bulk create users in the Azure portal description: Add users in bulk in Microsoft Entra ID-ms.date: 04/02/2026+author: tafra00+ms.author: tazkiaafra+ms.service: entra-id+ms.date: 09/25/2026 ms.topic: how-to-ms.custom: it-pro, sfi-image-nochange-ms.reviewer: jeffsta+ai-usage: ai-assisted+ms.custom: it-pro, sfi-image-nochange, msecd-doc-authoring-1026++#customer intent: As a user administrator, I want to create users in bulk so that I can add multiple users to Microsoft Entra ID at once. ---  # Bulk create users in Microsoft Entra ID --## Overview- Microsoft Entra ID, part of Microsoft Entra, supports bulk user create and delete operations and supports downloading lists of users. Just fill out the comma-separated values (CSV) template you can download from Microsoft Entra ID. -## Required permissions+## Prerequisites -In order to bulk create users in the administration portal, you must be signed in as at least a User Administrator.+To bulk create users in the Microsoft Entra admin center, sign 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.":::+:::image type="content" source="./media/users-bulk-add/create-template-example.png" alt-text="Screenshot of a bulk create CSV template with the required Name, User name, and Initial password columns.":::  > [!WARNING]-> If you're 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`.+> Ensure that you add the `.csv` file extension and remove any leading spaces before `userPrincipalName` and `passwordProfile`.  ### CSV template structure  The rows in a downloaded CSV template are as follows: -- **Version number**: The first row containing the version number (for example, `version:v1.0`) must be included in the upload CSV. If your downloaded template includes this row, don't remove or modify it.-- **Column headings**: The format of the column headings is &lt;*Item name*&gt; [PropertyName] &lt;*Required or blank*&gt;. For example, `Name [displayName] Required`. Some older versions of the template might have slight variations.-- **Examples row**: The template might include a row of example values for each column. You must remove the examples row and replace it with your own entries.--[!INCLUDE [bulk-operations-csv-template-note](~/includes/bulk-operations-csv-template-note.md)]+- **Column headings**: Preserve the column headings exactly as downloaded. The required columns are `Name [displayName] Required`, `User name [userPrincipalName] Required`, and `Initial password [passwordProfile] Required`.+- **Examples row**: You can keep the examples row in the CSV file. Add the users that you want to create on the following rows.  ### Additional guidance @@ -52,18 +49,17 @@ The rows in a downloaded CSV template are as follows: Here's an example of a completed CSV file ready for upload:  ```csv-version:v1.0-Name [displayName] Required,User name [userPrincipalName] Required,Initial password [passwordProfile] Required,Block sign in (Yes/No) [accountEnabled] Required,First name [givenName],Last name [surname],Job title [jobTitle],Department [department],Usage location [usageLocation],Street address [streetAddress],State or province [state],Country or region [country],Office [physicalDeliveryOfficeName],City [city],ZIP or postal code [postalCode],Office phone [telephoneNumber],Mobile phone [mobile]-Alain Charon,[email protected],Password1!,No,Alain,Charon,Software Engineer,Engineering,US,,,,,,,-Isabella Simonsen,[email protected],Password1!,No,Isabella,Simonsen,Product Manager,Product,US,,,,,,,-Joseph Price,[email protected],Password1!,No,Joseph,Price,Sales Representative,Sales,US,,,,,,,+Name [displayName] Required,User name [userPrincipalName] Required,Initial password [passwordProfile] Required+Chris Green,[email protected],Example-Password-Only!1+Alain Charon,[email protected],Example-Password-Only!1+Isabella Simonsen,[email protected],Example-Password-Only!1+Joseph Price,[email protected],Example-Password-Only!1 ```  > [!IMPORTANT]-> Only the first four columns are required: **Name**, **User name**, **Initial password**, and **Block sign in**. All other columns are optional and can be left empty.--## To create users in bulk+> Only **Name**, **User name**, and **Initial password** are required. All other columns are optional and can be left empty. +## Create users in bulk  1. Sign in to the [Microsoft Entra admin center](https://entra.microsoft.com) as at least a [User Administrator](~/identity/role-based-access-control/permissions-reference.md#user-administrator). 1. Browse to **Entra ID** > **Users** > **Bulk create**.@@ -71,9 +67,7 @@ Joseph Price,[email protected],Password1!,No,Joseph,Price,Sales Representative,      :::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."::: -1. 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.":::+1. Open the CSV file, preserve the column headers exactly as downloaded, and add a line for each user you want to create. The only required values are **Name**, **User name**, and **Initial password**. Then save the file.  1. On the **Bulk create user** page, under Upload your CSV file, browse to the file. When you select the file and select **Submit**, validation of the CSV file starts. 1. 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.@@ -116,7 +110,7 @@ You should see that the users that you created are listed.  [!INCLUDE [Bulk operations limitations](~/includes/bulk-operations-limitations.md)] -## Next steps+## Related content  - [Bulk delete users](users-bulk-delete.md) - [Download list of users](users-bulk-download.md)