Bulk Update Microsoft 365 Users from CSV

How to bulk update Microsoft 365 users

1. Click Tools > Users, then Bulk update in the toolbar.

2. Click Download template to get a CSV with the most common columns.

3. Edit the CSV. Keep the userPrincipalName column (this matches each row to an existing account) and add a column for each property you want to change. Fill in only the users and cells you want to update, then save.

   Only the columns you include are changed, every other property on the account is left as it is. A blank cell also leaves that property unchanged.

4. Click Choose CSV and select your file.

5. Review the Preview. Rows are matched on userPrincipalName, and any column the app doesn't recognize is listed as ignored. See the full list of columns you can change in the table below.

6. Click Apply updates to N users. Each row updates to Updated, or shows the reason it failed, as it finishes.

   A row fails if its userPrincipalName does not match an existing account, or if the change is rejected (for example a value that breaks a tenant policy).

Supported columns

Column headers are matched without case sensitivity, and the aliases below are accepted too. Any column not listed here is ignored. Only userPrincipalName is required, it is the key that matches each row to an account.