Bulk importing users into active directory

This is a quick spreadsheet i have made up to bulk import users into active directory.
Most organization's run Microsoft windows, most using active directory for there user management. Prior to there I.T setup, i am sure there is some form of "payroll" or admin type machine containing all the details of the people you want in your Active Directory User import. Grab this raw information, and manipulate it in a way that can be used in my spreadsheet.


I am hoping it is pretty straight forward, There is some dummy data already in the spreadsheet, so just swap and change to suit your particular setup.

Use the different sheet tab to bulk create the home drives, then apply the correct permissions using calcs.

Spreadsheet available here