This page lists all supported CSV headers for bulk management actions in M365 Manager Plus that can be carried out by importing CSV files as a data source.
| Header in CSV file |
Description |
| General user attributes |
| UserPrincipalName* |
Specifies the object's User Principal Name. This value is used to identify the user object that needs to be modified. |
| FirstName |
Specifies the first name of the user. The maximum length is 64 characters. |
| LastName |
Specifies the last name of the user. The maximum length is 64 characters. |
| DisplayName |
Specifies the display name of the user. The maximum length is 256 characters. |
| Initials |
Specifies the user's middle initials. The maximum length is 6 characters. |
| Country |
Specifies the country to which the user belongs. The maximum length is 128 characters. |
| State |
Specifies the state to which the user belongs. The maximum length is 128 characters. |
| City |
Specifies the user's city. The maximum length is 128 characters. |
| StreetAddress |
Specifies the physical address of the user. The maximum length is 1024 characters. |
| PostalCode |
Specifies the postal code of the user. The maximum length is 40 characters. |
| PostOfficeBox |
Specifies the user's post box number. The maximum length is 40 characters. |
| Department |
Specifies the department to which the user belongs. The maximum length is 64 characters. |
| Office |
Specifies the name of the user's physical office name. The maximum length is 128 characters. |
| Company |
Specifies the name of the company the user belongs to. The maximum length is 64 characters. |
| DirectReports |
Specifies the UserPrincipalNames of the employees reporting to this user. The user is also set as the manager for these employees. You can enter
multiple values separated by a comma for DirectReports. |
| EmployeeId |
Specifies the user's employee ID. The maximum length is 16 characters. |
| EmployeeType |
Specifies the employee type of the user. The maximum length is 64 characters. |
| Manager |
Specifies the User Principal Name of the user's manager. |
| Title |
Specifies the user's job title.The maximum length is 128 characters. |
| PasswordNeverExpires |
Specifies whether the user's password expires or not. True: The password will never expire. False: The password will expire as per the user's
domain password policy. |
| ForceChangePassword |
Specifies if the user must change the password during their next sign in. True: The user must change the password. False: The user need not
change the password. |
| Fax |
Specifies the fax number of the user. The maximum length is 64 characters. |
| OtherFax |
Specifies the alternate fax number of the user. The maximum length is 64 characters. |
| PhoneNumber |
Specifies the office phone number of the user. The maximum length is 64 characters. |
| MobilePhone |
Specifies the personal mobile number of the user. The maximum length is 64 characters. |
| OtherTelephone |
Specifies the alternate phone number of the user. The maximum length is 64 characters. |
| HomePhone |
Specifies the home phone number of the user. The maximum length is 64 characters. |
| OtherHomePhone |
Specifies the alternate home phone number of the user. The maximum length is 64 characters. |
| Pager |
Specifies the pager number of the user. The maximum length is 64 characters. |
| Notes |
Specifies additional information about the user. The maximum length is 1024 characters. |
| WebPage |
Specifies the URL of the user's webpage. The maximum length is 2048 characters. |
| PhoneticDisplayName |
Specifies an alternate spelling of the user's name that is used for text to speech in Unified Messaging (UM) environments. You can use this parameter when the pronunciation and spelling of the user's name do not match. The maximum length is 256 characters. |
| SimpleDisplayName |
Specifies an alternate description of the user when only a limited set of characters is permitted. The maximum length is 256 characters. The
valid characters are: a - z A - Z 0 - 9 space " ' ( ) + , - . / : ? |
| AddToAdministrativeUnits |
Specifies the ObjectIDs of the administrative units in which user will be added as a member. You can specify multiple values separated by a comma. Note: To modify this attribute, please enable REST API access in the product as it is supported only for REST API access enabled product accounts. Click here to know how to enable the REST API. |
| AssistantName |
Specifies the name of the user's assistant. The maximum length is 256 characters. |
| Mailbox permission changes |
| Permissions delegated over this mailbox |
| DelegateSendAsPermissionTo1 |
Specifies the mailboxes or groups that are to be delegated the Send as permission over the mailbox specified in the UserPrincipalName header.
|
| RevokeSendAsPermissionFrom1 |
Specifies the mailboxes or groups for which the Send as permissio n has to be revoked over the mailbox specified in the UserPrincipalName
header. |
| DelegateMailboxPermissionsTo 1
|
Specifies the mailboxes or groups that are to be delegate d mailbox permissions over the mailbox specified in the UserPrincipalName header. |
| RevokeMailboxPermissionsFrom1
|
Specifies the mailboxes or groups for which mailbox permissions will be removed over the mailbox specified in the UserPrincipalName header.
|
| DelegateMailboxPermissions 1
|
Specifies the mailbox permissions that are to be delegated to the objects specified in the DelegateMailboxPermissionsTo header :
- FullAccess: The specified mailbox can view, add, and remove the contents of its delegated mailboxes.
- ExternalAccount: External users who are assigned this permission can manage the permissions of the delegated mailboxes.
- DeleteItem: The specified mailbox can delete the contents of its delegated mailboxes.
- ReadPermission: The specified mailbox can view the permissions assigned to its delegated mailboxes.
- ChangePermission: The specified mailbox can change the permissions assigned to its delegated mailboxes.
- ChangeOwner:The specified mailbox can change the owner of its delegated mailboxes.
|
| RevokeMailboxPermissions1 |
Specifies the mailbox permissions that are to be removed from the objects specified in the RevokeMailboxPermissionsFrom
header:
- FullAccess: The specified mailbox can view, add, and remove the contents of its delegated mailboxes.
- ExternalAccount: External users who are assigned this permission can manage the permissions of the delegated mailboxes.
- DeleteItem: The specified mailbox can delete the contents of its delegated mailboxes.
- ReadPermission: The specified mailbox can view the permissions assigned to its delegated mailboxes.
- ChangePermission: The specified mailbox can change the permissions assigned to its delegated mailboxes.
- ChangeOwner: The specified mailbox can change the owner of its delegated mailboxes.
|
| DelegateSendOnBehalfPermissionTo1 |
Specifies the mailboxes or groups that are to be delegated the Send on behalf permission over the mailbox specified in the UserPrincipalName header. |
| RevokeSendOnBehalfPermissionFrom1 |
Specifies the mailboxes or groups for which the Send on behalf permission has to be revoked over the mailbox specified in the UserPrincipalName header. |
| Permissions delegated to this mailbox |
| AssignSendAsPermissionFor1 |
Specifies the mailboxes over which the Send as permission will be assigned to the mailbox specified in the UserPrincipalName header. |
| RemoveSendAsPermissionFor1 |
Specifies the mailboxes over which the Send aspermission will be removed from the mailbox specified in the UserPrincipalName header. |
| AssignSendOnBehalfPermissionFor1 |
Specifies the mailboxes over which the Send on behalf permission will be assigned to the mailbox specified in the UserPrincipalName header. |
| RemoveSendOnBehalfPermissionFor1 |
Specifies the mailboxes over which the Send on behalfpermission will be removed from the mailbox specified in the
UserPrincipalName header. |
| AssignMailboxPermissionsFor1 |
Specifies the mailboxes over which the mailbox permissions mentioned in the AssignPermissions header will be assigned. |
| RemoveMailboxPermissionsFor1 |
Specifies the mailboxes over which the mailbox permissions mentioned in the RemovePermissions header will be removed. |
| AssignPermissions1 |
Specifies the permissions that the mailbox specified in the UserPrincipalName header has over the mailboxes mentioned in the As signMailboxPermissionsF or header:
- FullAccess: The specified mailbox can view, add, and remove the contents of its delegated mailboxes.
- ExternalAccount: External users who are assigned this permission can manage the permissions of the delegated mailboxes.
- DeleteItem: The specified mailbox can delete the contents of its delegated mailboxes.
- ReadPermission: The specified mailbox can view the permissions assigned to its delegated mailboxes.
- ChangePermission: The specified mailbox can change the permissions assigned to its delegated mailboxes.
- ChangeOwner:The specified mailbox can change the owner of its delegated mailboxes.
|
| RemovePermissions 1 |
Specifies the permissions that the mailbox specified in the UserPrincipalName header will lose over the mailboxes mentioned in the RemoveMailboxPermissionsFor header:
- FullAccess: The specified mailbox can view, add, and remove the contents of its delegated mailboxes.
- ExternalAccount: External users who are assigned this permission can manage the permissions of the delegated mailboxes.
- DeleteItem: The specified mailbox can delete the contents of its delegated mailboxes.
- ReadPermission: The specified mailbox can view the permissions assigned to its delegated mailboxes.
- ChangePermission: The specified mailbox can change the permissions assigned to its delegated mailboxes.
- ChangeOwner: The specified mailbox can change the owner of its delegated mailboxes.
|
| Auto-reply configuration |
| AutoReplyState |
Specifies if auto-reply is to be enabled or disabled for the mailbox specified in the UserPrincipalName header:
- Enabled: Auto-reply will be enabled for the specified mailbox.
- Disabled: Auto-reply will be disabled for the specified mailbox.
|
| InternalMessage |
Specifies the message that is to be sent using auto-reply to users inside the organization from the mailbox specified in the UserPrincipalName header. |
| ExternalMessage |
Specifies the message that is to be sent using auto-reply to users outside the organization from the mailbox specified in the UserPrincipalName header. |
| SendExternalAutoReplyOnlyToContacts |
Specifies if external auto-reply is to be enabled only for contacts of the mailbox specified in the UserPrincipalName header:
- True: Auto-reply will only be enabled for external contacts of the specified mailbox and disabled for other external email addresses.
- False: Auto-reply will be enabled for all external mail addresses.
|
| DelegateSendAsPermissionTo |
Specifies the mailboxes or groups that are to be delegated the Send As permission over the mailbox specified in the UserPrincipalName header. |
| RevokeSendAsPermissionFrom |
Specifies the mailboxes whose Send As permission will be removed from the mailbox specified in the UserPrincipalName header. |
| DelegateMailboxPermissionsTo |
Specifies the mailboxes or groups that are to be delegated mailbox permissions over the mailbox specified in the UserPrincipalName header. |
| RevokeMailboxPermissionsFrom |
Specifies the mailboxes or groups for which mailbox permissions will be removed from the mailbox specified in the UserPrincipalName header. |
| DelegateMailboxPermissions |
Specifies the mailbox permissions that are to be delegated to the objects specified in the DelegateMailboxPermissionsTo header.
- FullAccess: The specified mailbox can view, add and remove the contents of its delegated mailboxes
- ExternalAccount: External users who are assigned this permission can manage the permissions of the delegated mailboxes.
- DeleteItem: The specified mailbox delete the contents of its delegated mailboxes.
- ReadPermission: The specified mailbox can view the permissions assigned to its delegated mailboxes.
- ChangePermission: The specified mailbox can change the permissions assigned to its delegated mailboxes.
- ChangeOwner: The specified mailbox can change the owner of its delegated mailboxes.
|
| RevokeMailboxPermissions |
Specifies the mailbox permissions that are to be removed from the objects specified in the RevokeMailboxPermissionsFrom header
- FullAccess: The specified mailbox can view, add and remove the contents of its delegated mailboxes.
- ExternalAccount: External users who are assigned this permission can manage the permissions of the delegated mailboxes.
- DeleteItem: The specified mailbox delete the contents of its delegated mailboxes.
- ReadPermission: The specified mailbox can view the permissions assigned to its delegated mailboxes.
- ChangePermission: The specified mailbox can change the permissions assigned to its delegated mailboxes
- ChangeOwner: The specified mailbox can change the owner of its delegated mailboxes.
|
| DelegateSendOnBehalfPermissionTo |
Specifies the mailboxes or groups that are to be delegated the Send On Behalf permission over the mailbox specified in the UserPrincipalName header. |
| RevokeSendOnBehalfPermissionFrom |
Specifies the mailboxes or groups whose Send On Behalf permission has to be revoked over the mailbox specified in the UserPrincipalName header. |
| AssignSendAsPermissionFor |
Specifies the mailboxes over which the Send As permission will be assigned to the mailbox specified in the UserPrincipalName header. |
| RemoveSendAsPermissionFor |
Specifies the mailboxes whose Send As permission will be removed from the mailbox specified in the UserPrincipalName header. |
| AssignSendOnBehalfPermissionFor |
Specifies the mailboxes over which the Send On Behalf permission will be assigned to the mailbox specified in the UserPrincipalName header. |
| RemoveSendOnBehalfPermissionFor |
Specifies the mailboxes over which the Send On Behalf permission will be removed from the mailbox specified in the UserPrincipalName header. |
| AssignMailboxPermissionsFor |
Specifies the mailboxes over which the mailbox permissions mentioned in the AssignPermissions header will be assigned. |
| RemoveMailboxPermissionsFor |
Specifies the mailboxes over which mailbox permissions mentioned in the RemovePermissions header will be removed. |
| AssignPermissions |
Specifies the permissions that the mailbox specified in the UserPrincipalName header has over the mailboxes mentioned in the AssignMailboxPermissionsFor header.
- FullAccess: The specified mailbox can view, add and remove the contents of its delegated mailboxes
- ExternalAccount: External users who are assigned this permission can manage the permissions of the delegated mailboxes.
- DeleteItem: The specified mailbox delete the contents of its delegated mailboxes.
- ReadPermission: The specified mailbox can view the permissions assigned to its delegated mailboxes.
- ChangePermission: The specified mailbox can change the permissions assigned to its delegated mailboxes.
- ChangeOwner: The specified mailbox can change the owner of its delegated mailboxes.
|
| RemovePermissions |
pecifies the permissions that the mailbox specified in the UserPrincipalName header will lose over the mailboxes mentioned in the RemoveMailboxPermissionsFor header.
- FullAccess: The specified mailbox can view, add and remove the contents of its delegated mailboxes
- ExternalAccount: External users who are assigned this permission can manage the permissions of the delegated mailboxes.
- DeleteItem: The specified mailbox delete the contents of its delegated mailboxes.
- ReadPermission: The specified mailbox can view the permissions assigned to its delegated mailboxes.
- ChangePermission: The specified mailbox can change the permissions assigned to its delegated mailboxes.
- ChangeOwner: The specified mailbox can change the owner of its delegated mailboxes.
|
| AutoReplyState |
Specifies if auto reply is to be enabled or disabled for the mailbox specified in the UserPrincipalName header.
- Enabled: Auto reply will be enabled for the specified mailbox.
- Disabled: Auto reply will be disabled for the specified mailbox.
|
| InternalMessage |
Specifies the message that is to be sent using auto reply to users inside the organization from the mailbox specified in the UserPrincipalName header. |
| ExternalMessage |
Specifies the message that is to be sent using auto reply to users outside the organization from the mailbox specified in the UserPrincipalName header. |
| SendExternalAutoReplyOnlyToContacts |
Specifies if external auto reply is to be enabled only for contacts of the mailbox specified in the UserPrincipalName header.
- True: Auto reply will only be enabled for external contacts of the specified mailbox and disabled for other external email addresses.
- False: Auto reply will be enabled for all external mail addresses.
|
| Header in CSV file |
Description |
| InvitedUserEmailAddress* |
Specifies the email of the user. This value is used to send an invitation.The maximum length is 256 characters. |
| InviteRedirectUrl * |
Specifies the redirecting URL when the user accepts the invitation. |
| UserType * |
Specifies the type of the user. The accepted values are "Guest" and "Member". |
| Message |
Specifies the body of the invitation mail that is sent to the user. |
| CcRecipient |
Specifies the cc recipient of the invitation mail that is sent. The maximum length is 256 characters. |
| DisplayName |
Specifies the display name of the user. The maximum length is 256 characters. |
| FirstName |
Specifies the first name of the user. The maximum length is 64 characters. |
| LastName |
Specifies the last name of the user. The maximum length is 64 characters. |
| UsageLocation |
Specifies the usage location of the user. |
| Office |
Specifies the location of the user's office. The maximum length is 64 characters. |
| PhoneNumber |
Specifies the office phone number of the user. The maximum length is 64 characters. |
| Title |
Specifies the user's job title.The maximum length is 128 characters. |
| State |
Specifies the state to which the user belongs. The maximum length is 128 characters. |
| MobilePhone |
Specifies the personal mobile number of the user. The maximum length is 64 characters. |
| StreetAddress |
Specifies the physical address of the user. The maximum length is 1024 characters. |
| City |
Specifies the user's city. The maximum length is 128 characters. |
| Country |
Specifies the country to which the user belongs. The maximum length is 128 characters. |
| Department |
Specifies the department to which the user belongs. The maximum length is 64 characters. |
| Fax |
Specifies the fax number of the user. The maximum length is 64 characters. |
| AlternateEmailAddresses |
Specifies the other mails of the user. The maximum length is 256 characters. |
| PostalCode |
Specifies the zip or postal code of the user. The maximum length is 40 characters. |
| PreferredLanguage |
PreferredLanguage |
| Manager |
Specifies the User Principal Name of the user's manager. |
| EmployeeID |
Specifies the employee ID of the user. The maximum length is 16 characters. |
| EmployeeType |
Specifies the employee type of the user. The maximum length is 64 characters. |
| CompanyName |
Specifies the name of the company the user belongs to. The maximum length is 64 characters. |
| MailNickName |
Specifies the nickname of a user's mail id. The maximum length is 64 characters.
The valid characters are:
|
| Name |
Description |
| DisplayName * |
Specifies the name of the team |
| Description |
Specifies the description of the team. |
| Visibility |
Specifies if the team is public or private. Users can join a private team only when the owner adds them to the team. |
| Owner * |
Specifies the owner of the team. |
| AllowGiphy |
Enabling this setting will allow the team members to share GIFs in the team chat. |
| GiphyContentRating |
The GiphyContentRating can be set to strict or moderate. If set as strict, they will be fully restricted from adult content GIFs. |
| AllowStickersAndMemes |
Enabling this setting will allow the team members to share stickers and memes in the team chat. |
| AllowCustomMemes |
Enabling this setting will allow the team members to upload photos and create custom memes to share in the team chat. |
| AllowUserCreateUpdateChannels |
Enabling this setting will allow the team members to create and update team channels. |
| AllowCreatePrivateChannels |
Enabling this setting will allow the team members to create private team channels. |
| AllowUserDeleteChannels |
Enabling this setting will allow the team members to delete team channels. |
| AllowAddRemoveApps |
Enabling this setting will allow the team members to add or remove applications in the team. |
| AllowCreateUpdateRemoveTabs |
Enabling this setting will allow the team members to manage tabs in the team. They can create, update or remove tabs in the team. |
| AllowCreateUpdateRemoveConnectors |
Enabling this setting will allow the team members to manage connectors in the team. They can create, update or remove connectors in the team. |
| AllowUserEditMessages |
Enabling this setting will allow the team members to edit the messages that they have posted. |
| AllowUserDeleteMessages |
Enabling this setting will allow the team members to delete the messages that they have posted. |
| AllowOwnerDeleteMessages |
Enabling this setting will allow team owners to delete the messages that they or other members of the team have posted. |
| AllowTeamMentions |
Enabling this setting will allow the team to be mentioned (@team name) in the team chat. All the team members will be notified when mentioned. |
| AllowChannelMentions |
Enabling this setting will allow channels in the team to be mentioned (@channel name) in the team chat. All the team members who follow the channel will be notified when mentioned. |
| AllowGuestCreateUpdateChannels |
Enabling this setting will allow guests to create and update channels in the team. |
| AllowGuestDeleteChannels |
Enabling this setting will allow guests to delete team channels. |