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

  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 JumpCloud. For information on converting domain user accounts, unbinding from the domain and installing the JumpCloud agent, see our Active Directory Migration Utility

Still Have Questions?

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

Submit a Case