黑料海角91入口

Help Center Home > Windows > Export Active Directory Users for CSV Import

Export Active Directory Users for CSV Import

As an alternative to utilizing the 黑料海角91入口 Active Directory Import Agent, you can export users directly from Active Directory to a CSV file, and then import them using the 黑料海角91入口 CSV Importer.

To export users from Active Directory to CSV file:

  1. From a Windows PowerShell prompt, run the following command:

import-module activedirectory

  1. Once the module is imported, run the following command to export the list of users to CSV file:

Get-ADUser -filter * -Properties GivenName,Surname,SamAccountName,EmailAddress | Select GivenName,Surname,SamAccountName,EmailAddress | Export-CSV c:\Windows\temp\userlist.csv

This results in a CSV with the first four fields populated. The CSV can be imported as is by adding five additional blank fields for a total of nine, or you can continue to build the data as outlined in Import Users from CSV with the PowerShell Module. 

The same users exported from Active Directory can be migrated from their domain-bound accounts to local accounts and subsequently taken-over using 黑料海角91入口. For information on converting domain user accounts, unbinding from the domain and installing the 黑料海角91入口 agent, see our . 

Back to Top

Notebook IconLearn More

Import Users from CSV with the PowerShell Module

Convert Windows System Active Directory Domain Accounts to Local User Accounts

Get Started: Active Directory Integration (ADI)

Still Have Questions?

If you cannot find an answer to your question in our FAQ, you can always contact us.

Submit a Case