utility can be used in Windows Server 2003, Windows Server 2003 R2, Windows
Server 2003 with SP1, Windows Server 2008, Windows Server 2008 R2, Windows
Server 2012, Windows Server 2012 R2.
command line tool Importing and Exporting of user accounts from one Active
Directory to another can be done.
Let us see an example of how to use
1.1. This is our Windows
2012 R2 server from where we are exporting the users.
2.2. Click on start and go to Active
Directory Users and Computers.
1. 3.Right Click on users, Select New and
Click on User to create new users.
1. 4. Csvde is a command-line tool, it is
available if you have the AD DS or Active Directory Lightweight Directory
Services (AD LDS) server role installed. To use csvde, you must run the csvde
command from an elevated command prompt. To open an elevated command prompt, click Start, right-click Command Prompt,
and then click Run as administrator.
1. 5.Now in the command line type the
Csvde –f <filepath/filename> E:\output.csv
By using this command a .csv file will be downloaded with all
the information of users and groups.
1. 6.The downloaded file can be opened in
MS-Excel. In the below image you can see that we have three users alex, john,
1. 7. Now let us go to another AD DS, you
can see in the below image that we don’t have those three users here. Let us import
1. 8. Before importing the .csv file we
have to change the domain name in the csv file.
Now go to command prompt as Administrator and enter the command.
Csvde -i -f output.csv
1. 9. Now let us check the users. You can
see that all the three users have been added successfully.
can't import passwords by utilizing csvde in light of the fact that passwords
must be sent over an encrypted channel.
such as Microsoft Excel spreadsheet software are capable of reading and saving
data in the CSV format. You can also create CSV files using Notepad; separate
the values that you add to your file with commas.