Can you use Excel to manage Active Directory?

Can i use Excel as a list of users and then import the users to Active Directory?
A example of how Excel might look like:
http://i.imgur.com/Jzx8f.png

And also if anyone is hardcore to Excel, how do i make a random password generator?

Martin Hansen

Tags: windows, it management, it support

martinohansen

5th Jun 2011

Clarifications

gliugil

zertyuiop 6th Jun 2011

Flag

Answer the Question

Answers (3)

Preferences

0 Votes

+ -

excel passwd generator

Paste the below into a cell and span across as many as you like.
=CHAR(RANDBETWEEN(33,126))
This will randomly generate a character from the alphanumeric+special key.
string the result and you get your random password.

dr_shivan

5th Jun 2011

Replies

I wont it to give me a 8 characters long password with lower case and upper case letters + numbers
I cant get =CHAR(RANDBETWEEN(33,126)) to that

martinohansen 7th Jun 2011

Flag

1 Vote

+ -

One of the easiest ways to do this

You could put you user information in a spreadsheet like your picture and save it as a csv file. Then with LDAP in a batch, vb or powershell script you could create the accounts.

This should help get you started:
http://blogs.technet.com/b/heyscriptingguy/archive/2008/10/20/how-can-i-create-users-from-a-csv-file.aspx

There are many other examples of this method online.

waynemeat

5th Jun 2011

Replies

Sounds good i will take a look at it!

martinohansen 7th Jun 2011

Flag

1 Vote

+ -

i use excel for importing ad accounts

Hi,

not sure if this fits what your looking for, but i have our sales system export new client account to a XLS file, then user VBscript to import and populate the system we use for our clients with the information, as well as setup a home folder, prepopulate it with required files (its a TS /Citrix type envirnment. if you want to see that let me know.

markp24@...

6th Jun 2011