{"id":85344,"date":"2023-06-05T13:09:11","date_gmt":"2023-06-05T17:09:11","guid":{"rendered":"https:\/\/jumpcloud.com\/?post_type=support&p=85344"},"modified":"2023-06-14T16:11:54","modified_gmt":"2023-06-14T20:11:54","slug":"export-active-directory-users-for-csv-import","status":"publish","type":"support","link":"https:\/\/jumpcloud.com\/support\/export-active-directory-users-for-csv-import","title":{"rendered":"Export Active Directory Users for CSV Import"},"content":{"rendered":"\n
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.<\/p>\n\n\n\n
To export users from Active Directory to CSV file:<\/p>\n\n\n\n
import-module activedirectory<\/p>\n<\/div><\/div>\n\n\n\n
Get-ADUser -filter * -Properties GivenName,Surname,SamAccountName,EmailAddress | Select GivenName,Surname,SamAccountName,EmailAddress | Export-CSV c:\\Windows\\temp\\userlist.csv<\/p>\n<\/div><\/div>\n\n\n\n
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<\/a>. <\/p>\n\n\n\n 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<\/a>. <\/p>\n","protected":false},"excerpt":{"rendered":" As an alternative to utilizing the JumpCloud Active Directory Import Agent, you can export users directly from Active Directory to […]<\/p>\n","protected":false},"author":205,"featured_media":0,"template":"","meta":{"_acf_changed":false,"_oasis_is_in_workflow":0,"_oasis_original":0,"_oasis_task_priority":"","inline_featured_image":false,"footnotes":""},"support_category":[2904,2855,2954,2852,2924],"support_tag":[],"coauthors":[2839,3011],"acf":[],"yoast_head":"\n