Results 1 to 8 of 8

Thread: Does anybody know if you can copy members of a Active Directory folder into Excel

  1. #1
    Registered User
    Join Date
    Jul 2011
    Posts
    2
    Thanks
    0
    Thanked
    0 times in 0 posts

    Does anybody know if you can copy members of a Active Directory folder into Excel

    I have about 150 members of a Active Directory folder. Within Active Directory you find the group folder. Go to properties. Then the member tab. Then you see the members. I want to move those members into a spreadsheet without manually typing them in. Is there anyway to do this? Thanks.

  2. #2
    Senior Member
    Join Date
    Jan 2004
    Location
    Cambridge
    Posts
    283
    Thanks
    13
    Thanked
    24 times in 23 posts
    • timread's system
      • Motherboard:
      • MSI B450 Tomahawk Max
      • CPU:
      • AMD Ryzen 5 3600
      • Memory:
      • 16GB (2x8GB) Corsair DDR4 Vengeance LPX
      • Storage:
      • 1x WD Blue SN550 500GB M.2 NVMe SSD, , 1x Crucial MX500 1TB SSD, 2x WD 1TB HDD in RAID1
      • Graphics card(s):
      • Gigabyte GeForce GTX 1660 Ti WINDFORCE OC 6G
      • PSU:
      • EVGA SuperNOVA 750W Gold Gen2
      • Case:
      • Fractal Design Define R3 Arctic White
      • Operating System:
      • Windows 10 Pro
      • Monitor(s):
      • AOC 2590 G4, Dell U2412M
      • Internet:
      • VirginMedia

    Re: Does anybody know if you can copy members of a Active Directory folder into Excel

    Assuming you're talking about dumping the membership of an AD Group to a spreadsheet, the easiest way is to use PowerShell, and the following command:

    get-adgroupmember "group name" | select-object logonname, firstname, lastname | export-csv c:\filename.csv

    Caveats: the command pipes its output into a CSV file. You can select additional properties of the user accounts if you need them in your spreadsheet (e.g. sAMAccountName if you want the user's actual AD user account name). Search technet.microsoft.com for more examples on usage etc.

  3. #3
    Senior Member
    Join Date
    Feb 2008
    Posts
    925
    Thanks
    4
    Thanked
    161 times in 148 posts
    • smargh's system
      • Motherboard:
      • Gigabyte GA-EP45-UD3P
      • CPU:
      • Xeon E5450 with 775-to-771 Mod
      • Memory:
      • 16GB Crucial
      • Storage:
      • Intel X25-M G2 80GB/Adaptec 3405 4x 2TB Ultrastar RAID1 / 1x 6TB Hitachi He6 / Dying 2TB Samsung
      • Graphics card(s):
      • GTX 750 Ti
      • PSU:
      • Seasonic X-560
      • Case:
      • Lian-Li PC-A71
      • Operating System:
      • Windows 7 Ultimate 64bit
      • Monitor(s):
      • BenQ G2400WD
      • Internet:
      • Really Crap ADSL2 <3Mbit

    Re: Does anybody know if you can copy members of a Active Directory folder into Excel

    What do you mean by "Active Directory folder" ? Do you mean an OU?

    Learn Powershell - it's awesome. With the Quest ActiveRoles cmdlets:

    Get-QADGroupMember "group name here" -Indirect -SizeLimit 0 | Select SamAccountName,Email,DisplayName | Export-Csv -NoTypeInformation c:\blah.csv

    Note that "indirect" also gets the members of nested groups. Remove that if you just want the members of that group, even if it includes other groups, but you might need to change the output selection to make it look sensible.

  4. #4
    Registered User
    Join Date
    Jul 2011
    Posts
    2
    Thanks
    0
    Thanked
    0 times in 0 posts

    Re: Does anybody know if you can copy members of a Active Directory folder into Excel

    Thanks for the respones. But I was hoping for easier. Sorry, way over my head. I'll get busy typing.

  5. #5
    Splash
    Guest

    Re: Does anybody know if you can copy members of a Active Directory folder into Excel

    Scratch that, I obviously didn't read your post...

    If you have the option to install PowerGUI you can do it through this once you have the AD management powerpack installed. Select group>click "members" or "members (recursive)" as required, click export to CSV.
    Last edited by Splash; 23-07-2011 at 07:21 AM.

  6. Received thanks from:

    Apex (29-07-2011)

  7. #6
    Chaos Monkey Apex's Avatar
    Join Date
    Jul 2003
    Location
    Huddersfield
    Posts
    4,706
    Thanks
    1,139
    Thanked
    284 times in 203 posts
    • Apex's system
      • Motherboard:
      • Asus Z87M-PLUS
      • CPU:
      • Intel i5-4670K
      • Memory:
      • 32 GiB
      • Storage:
      • 20 TiB
      • Graphics card(s):
      • PowerColor Radeon RX 6700 Fighter 10GB OC
      • PSU:
      • 750
      • Case:
      • Core View 21
      • Operating System:
      • Windows 10 pro
      • Monitor(s):
      • Dell S2721DGFA
      • Internet:
      • 200Mb nTL Cable

    Re: Does anybody know if you can copy members of a Active Directory folder into Excel

    Thats rather handy

  8. #7
    Senior Member
    Join Date
    Aug 2005
    Location
    Surrey
    Posts
    299
    Thanks
    3
    Thanked
    4 times in 4 posts

    Re: Does anybody know if you can copy members of a Active Directory folder into Excel

    In AD Users and Computers just right click the OU and select the Export list and save as CSV.

    Mark

    p.s. Powershell is awesome, definatly learn it

  9. Received thanks from:

    Apex (29-07-2011)

  10. #8
    Senior Member
    Join Date
    Aug 2005
    Location
    Surrey
    Posts
    299
    Thanks
    3
    Thanked
    4 times in 4 posts

    Re: Does anybody know if you can copy members of a Active Directory folder into Excel

    Quote Originally Posted by mark19632 View Post
    In AD Users and Computers just right click the OU and select the Export list and save as CSV.

    Mark
    Ahh must read the whole thread, you're talking about a group!

    Defiantly use Powershell

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 9
    Last Post: 04-11-2012, 10:46 AM
  2. Guild Wars active members list
    By Ferral in forum PC
    Replies: 59
    Last Post: 14-01-2006, 11:25 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •