365 Pro Toolkit User Guide
- Welcome
- Getting Started
- Tools
- Create Users
- Update Users
- OneDrive Copy
- Cleanup
- Update Groups
- Reports
- Schedule Reports
- Settings
- Knowledge Base
- Troubleshooting
Update 365 Users
This page contains the requirements and steps on how to bulk update Microsoft 365 user accounts using the 365 Pro Toolkit. This tool uses a csv template to bulk update accounts in a 365 tenant.
Requirements:
- UserPrincipalName – This column is required in the template and is used to identify the accounts to update.
- Cloud Users only – This tool is for update cloud users only; it will not update on-prem synced accounts. To update on-prem accounts refer to the AD Pro Toolkit.
- Support Attributes – Refer to the list of user attributes that are included in the template.
Steps
Step 1. Download and modify template
Click on “Download CSV template” to download the included CSV template.
Open the template and add the user information. In this example, I’m going to update the phone numbers, city, company, department and display name for several users.
Save the template and move to step 2.
Step 2. Select Template and Run
To start the update click browse and select your CSV template. Then click the run button.
Supported Attributes:
Below are the fields included in the template. If you need more fields, please contact support.
| User Field (Column Header) | Example Value | Description |
|---|---|---|
| UserPrincipalName | test.user@activedirectorypro.com | User Principal Name field |
| accountEnabled | TRUE | Enable or disable the account. (TRUE or FALSE). |
| BusinessPhone | 1-888-214-3802 | Business phone field (Contact Information) |
| City | Springfield | City field (Contact information) |
| CompanyName | Active Directory Pro | Company name field (Job Information) |
| Country | US | Country or region field (Contact information) |
| Department | IT | Department field (Job Information) |
| DispayName | Test User | The users display name (Identity) |
| EmployeeID | 123 | Employee ID field (Job Information) |
| FaxNumber | 1-888-214-3802 | Fa Number field (Contact information) |
| FirstName | Test | The users first name (Identity) |
| JobTitle | IT Manaager | The users job title (Job information) |
| LastName | User | The users last name (Identity) |
| Manager | user2@activedirectorypro.com | The users manager, must be in UPN format. |
| test.user@activedirectorypro.com | The users Email address. | |
| MobilePhone | 1-888-214-3802 | Mobile phone field (contact) |
| OfficeLocation | 4the floor | Off location field (Job information) |
| PostalCode | 65802 | Zip or postal code (contact information) |
| StreetAddress | 1234 W. EagleCrest LN | Street address field (Contact Information) |
| State | MO | State or province field (Contact information) |