{"id":76,"date":"2010-06-01T00:29:25","date_gmt":"2010-05-31T23:29:25","guid":{"rendered":"http:\/\/www.stevenwhiting.com\/blog\/?p=76"},"modified":"2025-04-02T09:51:04","modified_gmt":"2025-04-02T08:51:04","slug":"add-several-users-in-ad-using-excel","status":"publish","type":"post","link":"https:\/\/stevenwhiting.com\/blog\/?p=76","title":{"rendered":"Add several users in AD using Excel"},"content":{"rendered":"<p>UPDATE &#8211; I&#8217;ve changed the link below to point to GE.TT a legit file sharing site.<\/p>\n<p><a title=\"MassUserCreationScriptSource.xls\" href=\"http:\/\/ge.tt\/8CGATKV\/v\/0?c\">MassUserCreationScriptSource.xls<\/a><\/p>\n<p>Link to the script<\/p>\n<p>Taken from Train Signal AD 2008 training.<\/p>\n<p>File needs to be saved as a Formatted Text (Space delimited) file once done.<\/p>\n<p>Here&#8217;s the easy way to add a bunch of users all at once!<br \/>\n1. Copy and paste the first and last names of your users into the AddUsersInfoHere sheet<br \/>\n2. Type the ChildOU name and Autofill it down.<br \/>\n3. Type the ParentOU name and Autofill it down.<br \/>\n4. Go to MassUserCreationScriptSource and check to see if the domain name and suffix are correct. If not, fill in<br \/>\ncorrect value on the first line and Autofill down.<br \/>\n5. On the SaveThisSheetAsTextFile sheet, make sure to autofill for all required user names.<br \/>\n6. Go to File&#8211;&gt; Save As and save the sheet in a convenient place, making sure to select Formatted Text (Space Delimited)<br \/>\nas the file type.<br \/>\n7. Take your .prn file, rename it to something.bat.<br \/>\n8. Post to your server and run it at the command line!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>UPDATE &#8211; I&#8217;ve changed the link below to point to GE.TT a legit file sharing site. MassUserCreationScriptSource.xls Link to the script Taken from Train Signal AD 2008 training. File needs to be saved as a Formatted Text (Space delimited) file &hellip; <a href=\"https:\/\/stevenwhiting.com\/blog\/?p=76\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7],"tags":[64],"class_list":["post-76","post","type-post","status-publish","format-standard","hentry","category-it-notes","tag-ad"],"_links":{"self":[{"href":"https:\/\/stevenwhiting.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/76","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/stevenwhiting.com\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/stevenwhiting.com\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/stevenwhiting.com\/blog\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/stevenwhiting.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=76"}],"version-history":[{"count":9,"href":"https:\/\/stevenwhiting.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/76\/revisions"}],"predecessor-version":[{"id":2111,"href":"https:\/\/stevenwhiting.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/76\/revisions\/2111"}],"wp:attachment":[{"href":"https:\/\/stevenwhiting.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=76"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/stevenwhiting.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=76"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/stevenwhiting.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=76"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}