Skip to Content
AutomationBulk OperationsBulk User Management

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

ColumnExampleDescription
UserPrincipalNamejohn.doe@company.comLogin email (required)
DisplayNameJohn DoeFull name (required)
PasswordTempPass123!Initial password (optional - auto-generate)
FirstNameJohnGiven name
LastNameDoeSurname
DepartmentSalesDepartment name
JobTitleAccount ExecutiveJob title
Managerjane.smith@company.comManager’s UPN
LicenseM365_BUSINESS_PREMIUMLicense SKU to assign

Note: Download the CSV template to ensure correct column headers and formatting. The template includes all supported columns.

Import Process

  1. Upload CSV — Select file or drag and drop. Max 5,000 rows per import.
  2. Validate Data — System checks for errors: duplicate UPNs, invalid data, missing fields.
  3. Review Preview — Review parsed data and fix any validation errors before proceeding.
  4. Execute Import — Create users and assign licenses. Progress shown in real-time.
  5. 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 CSV
  • POST /api/automation/bulk-users/update — Bulk update user attributes
  • POST /api/automation/bulk-users/licenses — Bulk assign/remove licenses
  • POST /api/automation/bulk-users/disable — Bulk disable users
  • GET /api/automation/bulk-users/jobs/:id — Get bulk operation status
Last updated on