Issue with creating users in bulk

[lipalath-ms]

Hi,

I'm trying to create users in bulk by following this documentation.

I logged into Azure Portal with the following account:

I created a csv file with the following details:

I see the following error message:

The user name in the uploaded file is not valid. Change the user name in the uploaded file to be a valid user name in your Azure AD. Ensure the domain portion of the user name is verified in your Azure AD or is the initial domain name (like *.onmicrosoft.com). Then resubmit your request.

What am I missing? Am I using an account that is a User administrator in the organization? How do I verify that? Could you please help me with this issue?

---

Document Details

⚠ Do not edit this section. It is required for docs.microsoft.com ➟ GitHub issue linking.

• ID: 277a5d8f-7fce-bf5d-1ebd-2061e9ac8a69
• Version Independent ID: 02d2bc44-dc9f-a23a-9c60-facf7e0c1a41
• Content: Bulk create users in the Azure Active Directory portal
• Content Source: articles/active-directory/users-groups-roles/users-bulk-add.md
• Service: active-directory
• Sub-service: users-groups-roles
• GitHub Login: @curtand
• Microsoft Alias: curtand

[amanmcse]

@xyz92 Thank you for your feedback . We will investigate and update the thread further.

[krish-gh]

@xyz92 Can you check if there is any whitespace before or after the "User name [userPrincipalName]" field values? I could reproduce your error by adding an whitespace. After removing that it was all fine.

[krish-gh]

@xyz92 We have now updated the doc explicitly mentioning to check whitespace. The update should get published within few hours. Please feel free to revert if it does not solve your problem or have any further issue.

[lipalath-ms]

@krish-gh Thank you! I don't have any whitespaces in the username. I still see the issue. Could you reopen this issue? Just to confirm the values in Name, Username, Initial password can be test values correct?

[krish-gh]

From the screenshot you shared above, it looks like you have space in the beginning of UPN. That's why I suspected it.

[krish-gh]

@xyz92 During troubleshooting over chat, it was found you had blank space at the end of UPN and after cleaning it, it worked.

[steph409]

Hi @krish-gh,
ran into the same issue, removing the whitespaces also fixed it for me. The template "UserCreateTemplate.csv" you can download in azure contains a whitespace:

Example: Chris Green, chris@contoso.com, myPassword1234, No

Removing the whitespace in the template would be good.