How to format csv file to bulk add users in Entra ID

Question

I've been trying to add users with the bulk functionality for several hours but I can't, I'm following all the steps in the documentation and I always get the same error.

"Unknown CSV header found"

Answer 1

@Gabriel Boettcher

Thank you for your post!

Error Message:
Unknown CSV header found

Based off your error message and referencing the Bulk create users in Microsoft Entra ID documentation, can you make sure that you didn't add any additional headers?

For more info - 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.

I wasn't able to reproduce your issue within my tenant, but I'll share the steps I took below to hopefully help point you in the right direction and resolve your issue.

1. Within MS Entra ID -> Users
2. Select Bulk Operations ->Bulk Create
3. Download the csv template.
4. Filled in user information starting at line 4 within the CSV file. Note: If you are adding only one entry using the CSV template, you must preserve row 3 and add your new entry to row 4.
5. Uploaded the CSV file to bulk create the users.

For more info - Bulk create users in Microsoft Entra ID

• If you're still having issues, can you share some more details as to the steps you took when creating your CSV file?

I hope this helps!

Thank you for your time and patience throughout this issue.

---

If the information helped address your question, please Accept the answer. This will help us and also improve searchability for others in the community who might be researching similar information.