Evaluate Weigh the pros and cons of technologies, products and projects you are considering.

Free tool creates AD user accounts from a CSV file

Punching user accounts into AD one at a time is tedious and a waste of time. Use the free OrgBuilder tool instead to import the data from a CSV file.

Please let others know how useful this tip is via the rating scale at the end of it. Do you have a useful Exchange or Outlook tip, timesaver or workaround to share? Submit it to our tip contest and you could win a prize.

When it comes time to migrate a domain or create one from scratch, punching user accounts into Active Directory one at a time is tedious and a waste of time. A smart Exchange administrator should make use of a third-party tool to create a domain from pre-existing data.

OrgBuilder (courtesy of programmer Asaf Ganot at Daniel Petri's MCSEWorld site) is one such tool -- and definitely one of the better ones I've come across.

This tool imports data from a CSV spreadsheet (a template is provided with the program in Excel format) and automatically creates user accounts, departments, department groups, duty groups and department organizational units from the provided list.

Using OrgBuilder is simple enough once you have the spreadsheet populated and saved in CSV format. (You can also save the CSV data from your own source, provided it matches the existing format.) You just need to supply the organization's domain name, the path to the CSV file and the proper administrative password, set a few options and you're ready to go.

The program also has some advanced directory-creation settings. You can optionally create a single public directory shared among all users, separate public directories for each department, hidden shares and a private directory container (either a global one for all private folders or different ones for each department).

OrgBuilder also provides the option to preview all changes to be made before they're committed, and logs its actions to a separate file for debugging.

About the author: Serdar Yegulalp is editor of the Windows 2000 Power Users Newsletter and a regular contributor to SearchExchange.com.

Do you have comments on this tip? Let us know.

More information from SearchExchange.com:


Dig Deeper on Exchange Server setup and troubleshooting

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.