Bulk Importing Users

Add users in bulk to Microsoft 365

Microsoft 365 allows users to be added in bulk through multiple methods. They can be added via CSV file, through PowerShell, Active Directory, or as part of an Exchange migration.

Adding users via CSV

Users can be added in bulk to Microsoft 365 by using a CSV file. A maximum of 249 users can be added in a single CSV file, and each user must have a unique email address.

Fill out the CSV using the provided template, then upload it and choose any licenses to assign to the users.

Repeat the process for adding more than 249 users.

Adding users with PowerShell

Microsoft 365 PowerShell is an advanced method for adding users in bulk and should only be attempted by users familiar with Windows PowerShell. Individual users as well as multiple users can be added in this method by following Microsoft's PowerShell guide for adding users.

Adding users using Active Directory

If ActiveDirectory is already being used, directory synchronization can replicate Active Directory accounts to Microsoft 365. Note that this method copies users only, and does not assign any licenses.

Adding users as part of an Exchange migration

When migrating email accounts from Microsoft Exchange to Microsoft 365 through the cutover, staged, or hybrid Exchange methods, users are created automatically. This does not assign licenses, and users added through this method will need to be assigned a license within 30 days or their mailbox will be disabled.