Need to export data from AD to Excel

Posted on 2006-05-08
Last Modified: 2010-08-05
I need to be able to export user data from AD into Excel.  Specifically, I need the account ID, user name, and email address.  Can anyone tell me how to do this?  If I can't go directly to Excel, a csv file would be ok.

Question by:afytech1
    LVL 87

    Accepted Solution

    use the commandline tool ldifde to export AD data to a text file, and then import that into excel. With ldifde /? you get the syntax

    Author Comment

    Can you tell me what the attribute for the user's email address is?  I can't seem to find that.  

    And one final can I only export users that have an email address?  ie ignore all users where no email address is found.

    LVL 10

    Assisted Solution

    by:Walter Padrón
    Hi afytech1,

    Not as powerfull as ldifde but you can use the Saved Queries under Active Directory User & Computers, it lets export to csv and have a graphical interface. Create a new query and on the "Exchange Recipients" custom query select the mail enabled users.


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Why You Should Analyze Threat Actor TTPs

    After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

    Suggested Solutions

    NTFS file system has been developed by Microsoft that is widely used by Windows NT operating system and its advanced versions. It is the mostly used over FAT file system as it provides superior features like reliability, security, storage, efficienc…
    If you're not part of the solution, you're part of the problem.   Tips on how to secure IoT devices, even the dumbest ones, so they can't be used as part of a DDoS botnet.  Use PRTG Network Monitor as one of the building blocks, to detect unusual…
    This video discusses moving either the default database or any database to a new volume.
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    761 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    13 Experts available now in Live!

    Get 1:1 Help Now