Entra Import Generator
Create an import-ready CSV in Entra ID format ("Bulk create users") for user accounts.
Add rowThese columns follow the "Bulk create users" CSV template in the Microsoft Entra Admin Center. Please verify against the current template before importing, as Microsoft occasionally adjusts the format.
| User principal name [UPN] | Display name | Password | Block sign in | Usage location | |
|---|---|---|---|---|---|
How it works
Enter accounts
Add UPN, display name and password.
Set options
Set sign-in block and usage location.
Export CSV
Upload directly in the Entra Admin Center.
Benefits
Good to know about this tool
Creates a CSV file in the "Bulk create users" format for direct import in the Microsoft Entra Admin Center.
Because Entra ID (formerly Azure AD) uses its own CSV format with specific column names, different from the classic M365 Admin Center format.
- Create test users for an Entra ID pilot project
- Prepare a bulk import for a migration from another IdP
- Prepare user accounts with a defined usage location for licensing
- Usage Location is mandatory for license assignment
- Force a password change at first login
- Always upload a small test group before the bulk import
Frequently Asked Questions
What does Usage Location mean?
The two-letter country code (e.g. DE) that determines which licenses and services can be assigned to the account — without this value, no license can be assigned.
Is my data stored anywhere?
No, everything stays in the browser and is only downloaded as a file on export.
The information, templates, scripts, calculations and recommendations provided are intended for educational and assistance purposes only. Always review and test any generated result before production use. IT Smart Service accepts no liability for misuse, data loss, outages, security incidents, or legal, financial or technical damages arising from incorrect or improper use. Responsibility for validation, testing and deployment decisions rests with the user.
Related Tools
Multi Platform Generator
Enter one employee list and export matching import CSVs for 7 platforms at once.
Exchange Import Generator
Create an import-ready CSV in Exchange Online format for mailboxes and distribution lists.
Microsoft 365 Bulk User Generator
Create multiple Microsoft 365 users at once — UPN, alias and password generated automatically.
Network problems? We come on-site in Magdeburg and the surrounding area.
Learn more →Need professional IT support?
Our team can help if the free tool is not enough for your project.