Active Directory Bulk
User Updater Tool
Bulk update/modify existing Active Directory User
accounts with this easy-to-use tool.
- Mass update user accounts
- Bulk add users to groups
- Save hours of time
Key Features
Here are the advantages of using the bulk updater tool.
Update Active Directory Users
Mass update or remove user account properties with this easy-to-use GUI tool. Update single or multiple attributes all at once, update the title, state, manager, employee id, and more.
No Scripting Required
Bulk update users in just a few clicks (seriously). No scripting or coding is required.
Bulk Update User Passwords
Do you need to bulk update user’s passwords? This task is very easy to do with the bulk updater tool. Very easy for quick bulk password resets.
Update Group Membership
Included with the toolkit is the AD group management tool that allows you to mass add or remove users to groups.
Save Hours of Work
Updating Active Directory user account properties is a common task. If you have many accounts to update this can be very time-consuming. This tool saves you hours of manual work.
Task Scheduler (Automation)
The built-in task scheduler enables you to run the bulk updater on a daily, weekly, or monthly schedule.
Bulk Update ProxyAddresses
The bulk update tool supports updating or removing the proxyaddresses field. You can also set the primary SMTP addresses for users.
Export Users to CSV
Also included with the toolkit is the user export tool. Quickly export all domain users, users from groups, and OUs to a CSV file.
Customer Feedback
Very easy to use
“I like the ease of use, it has helped me complete bulk uploads and bulk updates into our AD.”
Sr. IT Lead
Education
Amazing software!
“We utilize the tools in Active Directory Pro for importing new students. A great product and we’re absolutely stoked!”
IT Manager
Education
Saved me a lot of time
“I used the tool to import and update users when moving to a new domain. That saved me a lot of time.”
IT Specialist
Professional Services
Administrator Guide
Bulk User Updater Tool
Description
The bulk user updater tool is used to bulk update active directory user account attributes. You can
choose to remove or update multiple users attributes at once. A CSV template is included that you fill
out with the user accounts and attributes you want to update.
Table of contents
- Read First
- Step 1: Generate CSV Template
- Step 2: Bulk Update Options
- Step 3: Run Bulk Updater
- How to remove user account properties
- CSV Template Setup
- Update proxyaddresses
- Adding additional user fields to the CSV
- Task Scheduler
- Support
READ FIRST:
- Run a small test first – Run a small test to ensure the accounts are being updated as expected. This is a powerful tool and you can mess up a lot of accounts if you don’t test first.
- sAMAccountName Column – This field is used to identify the account that you want to update. Do not remove this column from the CSV.
- DO NOT modify the CSV headers – The tool may not process correctly if you remove or move around the CSV headers.
- CSV Template – The CSV template includes 32 attributes. You can add additional attributes to the CSV. If you add additional attributes and it doesn’t work, please let me know.
- Existing values – If an attribute already has a value, the tool will replace the value. If the attribute is blank the tool will add that value.
- Remove option – Use the remove option to remove any attribute value. You can update and remove attributes at the same time.
Step 1: Generate CSV File
Make sure you read the READ FIRST section. It has important information for running this tool.
Click the CSV Template button to download the provided CSV template.

You can rename the template and save it anywhere you like.
Fill out the CSV
Now fill in the CSV with the user accounts and details you want to update. Just fill out the columns that you want to update, the rest can be left blank. You do not need to remove columns that are not used. See the CSV template section if you need help with the column names.
You must enter the user’s sAMAccountName into column A. You can use the bulk export tool to export this for all accounts or from an OU.
For this example, I’m going to update several user’s displayname, Office, department, and street addresses. Here is a screenshot of my CSV.

Again if any of these attributes have data the tool will update it, if blank it will add it.
Step 2. Bulk Update Options
Choose bulk update options or leave them as default.
Note: Changes to user proxyAddresses will only occur if you add a value to the proxyaddresses column in the CSV. See the ProxyAddress section for more details.

Step 3: Run Bulk Updater
The last step is to select your template and click run.

The log section makes it easy to verify the update was successful for all accounts. Any errors will be flagged.

All done. Now go check one of the accounts in Active Directory.
Remove User Account Properties
If you want to bulk remove user account properties then just put remove in the CSV column. In this example, I will remove the department information. Here is a screenshot of the CSV.

If any of these users had anything in the department field in Active Directory this tool will remove it.
Now check the logs and Active Directory to verify.
CSV Template Setup
The provided CSV template includes 33 user attributes you can use. You can add additional attributes if needed. Active Directory uses LDAP attribute names to store most account information. This means the user fields you see in Active Directory Users and Computers do not always match with the LDAP attribute name. To update user accounts you must use the LDAP names.
Below is a reference table that shows the LDAP name (CSV Template column) and what it maps to in Active Directory.

For example, the first name in Active Directory = giveName. The office field in Active Directory = physicalDeliveryOfficeName.
If you look at the provided CSV template the example has Test for the giveName (First name) and Nixa Office as the physicalDeliveryOfficeName (Office).

Here is a visual to help illustrate this.

If you need more visual reference refer to the LDAP Field Mappings guide.
proxyAddresses Details
If you need to update or modify proxyAddress please watch the video below.
Adding Additional User Fields to the CSV
You can add additional user attributes to the CSV file, you just need to know the LDAP name. You can find the LDAP name by opening the attribute editor in Active Directory Users and Computers. You could also use PowerShell to list all user account properties.
To see the attribute editor you first need to enable the advanced features in Active Directory Users and Computer
Click view from the top menu then select advanced features.

Now when you open an account you will see the attribute editor tab.

The attribute editor screen will show you all the user LDAP properties.
Now just find the attribute name and add it to the CSV. For example, I want to add information to the other Home telephone section for users.

In the attribute editor, I see the name is “otherHomePhone”. I will add this to the CSV.

Task Scheduler
Please refer to the Task Scheduler Guide for the steps.
Additional Tools
The AD Pro Toolkit includes 13 Active Directory management tools and over 200 built-in reports. The toolkit simplifies Active Directory administration and helps you to security your domain.

Support
If you run into any issues or need to ask a question you can contact us via our contact page.
You can also send us any additional features you would like to see added.
Try The User Updater Tool For FREE
Join 100,000+ global IT professionals and enjoy efficient, optimized, and intuitive Active Directory management that saves time and makes your job easier.
