Update users from a file

Make changes to user accounts based on the property values in an Excel or CSV file. Note: Only the first sheet of a workbook is recognized.

This feature allows you to make specific bulk changes to users properties using an CSV or Excel file.

How to update users from a file

How to prepare your Excel or CSV file for update

Use filters in the Users module grid to only show the users and attributes (include Username or GUID attribute for a mapping key) that you wish you to modify, and export it.

Make your changes in the file, save it and close it.
sapio365 will try to automatically match header names to the grid columns, and prefill mapped data in the mapping dialog.

Hybrid tenants

The ‘Update on-premises’ sub menu item is enabled only after loading on-prem users. For synced accounts, it’s your choice where you want to make changes. sapio365 does not recognize the direction of the sync.

Similar to the 'Import users from file' feature, 'Update users from file' lets you map the columns in your file to the columns in the sapio365 grid. The only difference is that you are asked which property to use as the criteria used to match file data to that of the grid: Username or Graph ID (GUID).

Step-by-step instructions

Choose to update in the cloud or on-prem.
Select an Excel or CSV file to use.

Only the first sheet of a workbook will be used.
Columns may be auto-mapped to the grid if the file contains:
• the same column IDs or column titles used in the grid
• recommended column headings from the Microsoft 365 admin center's CSV template (for cloud-only accounts)

INPUT: Review and set how the file should be read.
Select the matching column and property: Choose a matching key by mapping Name (on-prem), ID or Username to a column in the file. The value must be unique.
Select the columns for the the properties: Map the other attributes you want to update from the file by choosing a column in the file.
- Make sure that all other attributes are set to “-- Please select a column --“ (TIP: use the Reset button next to OK in the dialog box to reset all the columns to “-- Please select a column --“).
- Click OK.

Save: Review changes flagged by pencil icon in one of the status columns on the left, and the changed values in green, and Save.

Which user attributes can be edited from a file?

The table below lists the properties that can be edited.

Update users in cloud

List of editable user attributes

Attribute	Note
User Display Name
Username	If provided values have a missing or invalid domain, you will be asked to decide what to do later.
Sign-in status	Accepted values include: 'Allowed' or 'True' or '1', and 'Blocked', or 'False' or '0'.
First name
Last name
Preferred language	Accepted values include either the ISO 639-1 code (e.g. 'en-US') or the language fullname (e.g. 'English (United States)').
Location for License Usage	Accepted values include either the ISO 3166 two letter country code (e.g. 'US') or the country fullname (e.g. 'United States').
Email	If provided values have a missing or invalid domain, you will be asked to decide what to do later.
Email nickname
Employee ID
Job title
Company Name
Department
Office Phone
Mobile phone
Fax Number
Office location
Street Address
City
State
Postal Code
Country
Password policies	Accepted values include: 'None', 'DisablePasswordExpiration', 'DisableStrongPassword' or 'DisablePasswordExpiration, DisableStrongPassword'.
Immutable ID - On-Premises
Resource Capacity	Accepted values include any positive integer.
Custom Attribute 1
Custom Attribute 2
Custom Attribute 3
Custom Attribute 4
Custom Attribute 5
Custom Attribute 6
Custom Attribute 7
Custom Attribute 8
Custom Attribute 9
Custom Attribute 10
Custom Attribute 11
Custom Attribute 12
Custom Attribute 13
Custom Attribute 14
Custom Attribute 15

Update users on-premises

List of editable user attributes (on-premises)

Attribute	Note
User Principal Name
Account Password
Change Password At Logon	Accepted values include: 'True' or '1', and 'False' or '0'.
Enabled	Accepted values include: 'True' or '1', and 'False' or '0'.
Password never expires	Accepted values include: 'True' or '1', and 'False' or '0'.
Password not required	Accepted values include: 'True' or '1', and 'False' or '0'.
Cannot Change Password	Accepted values include: 'True' or '1', and 'False' or '0'.
Email Address
Display Name
Given Name
Surname
Initials
Other Name
Title
Manager	Only Distinguished Name or SAM Account Name values are accepted.
Employee ID
Employee Number
Company
Division
Department
Office Phone
Mobile Phone
Fax
Office
PO Box
Street Address
City
State
Postal Code
Country
Organization
Account not delegated	Accepted values include: 'True' or '1', and 'False' or '0'.
Allow Reversible Password Encryption	Accepted values include: 'True' or '1', and 'False' or '0'.
Description
Home Directory
Home Drive
Home Page
Home Phone
Logon Workstations
Profile Path
Script Path
Smartcard logon required	Accepted values include: 'True' or '1', and 'False' or '0'.
Trusted for delegation	Accepted values include: 'True' or '1', and 'False' or '0'.
msDS-cloudExtensionAttribute1
msDS-cloudExtensionAttribute2
msDS-cloudExtensionAttribute3
msDS-cloudExtensionAttribute4
msDS-cloudExtensionAttribute5
msDS-cloudExtensionAttribute6
msDS-cloudExtensionAttribute7
msDS-cloudExtensionAttribute8
msDS-cloudExtensionAttribute9
msDS-cloudExtensionAttribute10
msDS-cloudExtensionAttribute11
msDS-cloudExtensionAttribute12
msDS-cloudExtensionAttribute13
msDS-cloudExtensionAttribute14
msDS-cloudExtensionAttribute15
msDS-cloudExtensionAttribute16
msDS-cloudExtensionAttribute17
msDS-cloudExtensionAttribute18
msDS-cloudExtensionAttribute19
msDS-cloudExtensionAttribute20