Is it possible to Create users in AD from an xls spreadsheet?

Posted on 2006-05-31
Last Modified: 2012-05-05
I work in a high school and every year we get about 400 new students. When I create the new user accounts in AD, is there a way to create the users in AD from an xls spreadsheet? It is very tedious making 400 accounts by hand and I want to avoid it if possible. Are there any tools or articles I can look at to see how to do this?

Question by:dsheltzel
    LVL 30

    Expert Comment

    Here is a SystmProg solution from PAQ

    You can use LDIDE...its very easy to use and can modify according to ur need..:-

    With Video :-)


    Do you want to create a lot of User Accounts at one time?

    Or perhaps you want to migrate a large list of User Accounts into your Active Directory Domain?

    In Windows Server 2003, we use Active Directory Users and Computers to create User Accounts. A User Account is what Windows uses to identify and authenticate the user and grant them access to resources inside the domain.

    User Accounts can also be used by Windows Services to allow the Service access to specific resources on the computer or network.

    In this video we show you how to use LDIFDE to create user Accounts Automatically. LDIFDE is a command line utility that enables you to import a text file containing User Accounts. LDIFDE is incredibly flexible and powerful. Once you use LDIFDE, you'll wonder why you never found it sooner!

    CSVDE is a utility similar to LDIFDE, except CSVDE uses a CSV file as the basis for importing new User Accounts. CSVDE is the weapon of choice for many as you can use the more flexible approach of importing a spreadsheet containing user accounts and have CSVDE do the work.

    The DS Commands, consisting of DSADD, DSGET, DSMOVE, DSRM, DSQUERY and DSMOD are Active Directory commands that you can use to automate and manipulate User Account Creation and Modification. They are very powerful and show be part of every Active Directory Administrators Toolkit.

    Finally, theres the good old NET USER command. This is a legacy command, but its still useful for pumping out a few quick User Accounts.

    ***End Quote***

    Create User Accounts from Information in an Excel Spreadsheet

    USING WSH :-

    Introduction - Creating new users with WSH
    In active directory, when you need to create one or two users, Active Directory User's and Computers is the classic tool.  However, there may be times when you prefer to use WSH (Windows Scripting Host) to generate new user accounts.

    WSH Topics
    Creating a new OU
    Creating a new user
    Setting the password
    Disabling the account
    Error Messages
    Creating a new OU
    LVL 20

    Accepted Solution

    Hi dsheltzel,
    This is worth checking out. Be careful to test scripts first and always ensure a good backup prior to running any against your ad.
    Tutorial for Creating User Accounts from a Spreadsheet

    Deb :))

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Suggested Solutions

    Title # Comments Views Activity
    Disk Full of Space 6 53
    CA Certificate 2 33
    SSIS package failing 3 64
    How to virtualize old server? (2003) 7 63
    The HP utility "HP Lights-Out Online Configuration Utility for Windows Server 2003/2008" could be of great use when it comes to remotely configure a HP servers ILO WITHOUT rebooting the server. We would only need to create and run scripts using thi…
    Setting up a Microsoft WSUS update system is free relatively speaking if you have hard disk space and processor capacity.   However, WSUS can be a blessing and a curse. For example, there is nothing worse than approving updates and they just have…
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
    This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor ( If you're looking for how to monitor bandwidth using netflow or packet s…

    759 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

    7 Experts available now in Live!

    Get 1:1 Help Now