Export Active Directory Users for CSV Import

As an alternative to utilizing the JumpCloud Active Directory Import Agent, you can export users directly from Active Directory to a CSV file, and then import them using the JumpCloud CSV Importer.

To export users from Active Directory to CSV file:

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

import-module activedirectory

2. 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](./import-users-from-csv-with-powershell-module.md).

The same users exported from Active Directory can be migrated from their domain-bound accounts to local accounts and subsequently taken-over using JumpCloud. For information on converting domain user accounts, unbinding from the domain and installing the JumpCloud agent, see our [Active Directory Migration Utility](https://github.com/TheJumpCloud/jumpcloud-ADMU/wiki).