Hot Downloads



The forum is in read only mode.
Welcome, Guest
Username: Password: Remember me
  • Page:
  • 1

TOPIC: Need to get 200 users into AD

Need to get 200 users into AD 9 years 4 months ago #31973

I have an excel spreadsheet with 200 names that I need to import into my AD w/ email addresses? What's the easiest way....don't say start creating IDs!

The spreadsheet has the following fields: Last name, first name, email.

Any suggestions?


Re: Need to get 200 users into AD 9 years 4 months ago #31975

Look into CSVDE - Comma Separated Value Data Exchange. Described as "CSVDE is the type of program that you learn for a specific task and then forget about."




Re: Need to get 200 users into AD 9 years 4 months ago #31979

I actually used the above site a few months ago when I wanted to learn how to do this. It was quite fun. I spent hours importing users with all sort of AD fields populated. It made me realize how sophisticated it makes your directory when most of the objects' attributes are populated.

A few other bits of advice:
Familiarize yourself with some basic Excel formulas so you can concatenate and split information when needed. If you don't have a strategy on how to approach the task from point A (organizing the spreadsheet) to point B (executing the import command), then you may find yourself spending more time messing with the spreadsheet than if you had manually started with the IDs

Keep in mind that CSVDE does not create a password for the users that you import. By default, it'll create the users with blank passwords, and if your domain security policy prohibits blank passwords, then the accounts will be disabled by default. To set passwords for them, you'll need to use a VBScript or some other method to set the users' passwords.

If you want to see a list of all the available AD attributes, export your existing directory to a CSV file and isolate the user accounts. Keep in mind that although the exported CSV file will contain all attributes, not all of them can be imported with CSVDE (some area automatically created by AD)

There's also LDIFDE, but because of its format and difficulty of use, CSVDE is preferred for this kind of task.

Re: Need to get 200 users into AD 9 years 4 months ago #31980

KiLLaBeE is a close friend of mine, and has helped me with Microsoft side troubleshooting and implementations on numerous occasions. He is definitely the man to talk to about this kind of stuff.


  • Page:
  • 1
Time to create page: 0.160 seconds


Cisco Routers

  • SSL WebVPN
  • Securing Routers
  • Policy Based Routing
  • Router on-a-Stick

VPN Security

  • Understand DMVPN
  • GRE/IPSec Configuration
  • Site-to-Site IPSec VPN
  • IPSec Modes

Cisco Help

  • VPN Client Windows 8
  • VPN Client Windows 7
  • CCP Display Problem
  • Cisco Support App.

Windows 2012

  • New Features
  • Licensing
  • Hyper-V / VDI
  • Install Hyper-V


  • File Permissions
  • Webmin
  • Groups - Users
  • Samba Setup