Bulk User Management
Perform user operations at scale. Create, update, or modify multiple users simultaneously using CSV import, templates, or bulk selection. Ideal for onboarding, offboarding, and organizational changes.
Bulk Operations
Bulk Create Users
Create multiple users from CSV file. Great for new employee onboarding, acquisitions, or seasonal hiring.
Bulk Update Users
Modify attributes for multiple users. Update departments, titles, managers, or custom attributes in bulk.
Bulk License Assignment
Assign or remove licenses from multiple users. Handle license migrations and SKU changes efficiently.
Bulk Delete/Disable
Disable or delete multiple accounts. Useful for offboarding waves or cleaning up test accounts.
CSV Import
Create users by uploading a CSV file with user details:
Required Columns
| Column | Example | Description |
|---|---|---|
| UserPrincipalName | john.doe@company.com | Login email (required) |
| DisplayName | John Doe | Full name (required) |
| Password | TempPass123! | Initial password (optional - auto-generate) |
| FirstName | John | Given name |
| LastName | Doe | Surname |
| Department | Sales | Department name |
| JobTitle | Account Executive | Job title |
| Manager | jane.smith@company.com | Manager’s UPN |
| License | M365_BUSINESS_PREMIUM | License SKU to assign |
Note: Download the CSV template to ensure correct column headers and formatting. The template includes all supported columns.
Import Process
- Upload CSV — Select file or drag and drop. Max 5,000 rows per import.
- Validate Data — System checks for errors: duplicate UPNs, invalid data, missing fields.
- Review Preview — Review parsed data and fix any validation errors before proceeding.
- Execute Import — Create users and assign licenses. Progress shown in real-time.
- Download Results — Get report with success/failure status and temporary passwords.
Bulk Selection Operations
Select multiple users from the user list and perform actions:
Reset Passwords
Reset passwords for selected users. Auto-generate or set specific password. Option to require change on next login.
Assign/Remove Licenses
Add or remove licenses from selected users. Toggle specific service plans.
Add to Groups
Add selected users to one or more groups simultaneously.
Block Sign-in
Disable sign-in for selected users. Useful for immediate access revocation.
Delete Users
Soft-delete selected users. They can be restored within 30 days.
Update Attributes
Set the same value for an attribute across all selected users (e.g., set Department = “Sales” for 50 users).
Operation Results
Each bulk operation produces results in three categories:
- Succeeded — Operation completed successfully
- Failed — An error occurred during processing
- Skipped — User was already in the desired state
Download the results CSV to see detailed status for each user including error messages for any failures.
Common Scenarios
New Hire Onboarding
HR provides CSV of new hires. Bulk create accounts with department, manager, and license. Send welcome emails with credentials.
Department Reorganization
Export users from old department, update CSV with new department/manager, bulk update to reflect organizational change.
License Migration
Moving from E3 to E5. Select all E3 users, remove E3 license, assign E5 license in two bulk operations.
End of Project
Project contractors leaving. Select project team members, remove from project groups, disable accounts.
API Reference
POST /api/automation/bulk-users/import— Import users from CSVPOST /api/automation/bulk-users/update— Bulk update user attributesPOST /api/automation/bulk-users/licenses— Bulk assign/remove licensesPOST /api/automation/bulk-users/disable— Bulk disable usersGET /api/automation/bulk-users/jobs/:id— Get bulk operation status