Create Active Directory Bulk Users from CSV using PowerShell

Create Active Directory Bulk Users from CSV

It might not be common for every server administrator to need to import a large number of users at once. However, if you do, the process can be automated and save you massive amounts of time. It requires a little bit of leg work to set things up but once the process starts it’s amazingly fast. The basic workflow of this is to create a CSV file in Excel of all your users and their attributes. You would then import that file in Active Directory using a Powershell Script. The import itself takes seconds instead of spending 5-10 minutes per user the manual way.

CSV File Format: 

Name | GivenName | DisplayName | EmailAddress | UserPrincipalName | SamAccountName | Title | Department | Company | Path | AcountPassword

PowerShell: 

Import-Csv C:\newusers.csv | foreach {New-ADUser -Name $_.name -GivenName $_.name -Surname  $_.GivenName -displayname $_.displayname -EmailAddress $_.EmailAddress -UserPrincipalName $_.UserPrincipalName -SamAccountName $_.SamAccountName -Title $_.Title -Department $_.Department -company $_.company -Office $_.Office -City $_.city -OfficePhone $_.OfficePhone -MobilePhone $_.MobilePhone  -Path $_.Path -Accountpassword  (ConvertTo-SecureString -AsPlainText $_.AccountPassword -Force) -Enabled $true -ChangePasswordAtLogon 0}

 

 

0 thoughts on “Create Active Directory Bulk Users from CSV using PowerShell

  1. Bdsepjzcc

    Your comment is awaiting moderation.

    http://www.ilesrl.com/admin/GestioneBanner/filesBanner/trackclicks.asp?Id=27&CCT=327&5779=801985&Url=http://cleantalkorg2.ru/?op-dj – fsjz
    http://www.ilovethiscourse.com/default.aspx?p=TrackHyperlink&url=http://cleantalkorg2.ru/?sl-ci – khir
    http://www.imenicka.cz/banner.php?link=http://cleantalkorg2.ru/?wz-dv – kpgc
    http://www.ilyc.org/default.aspx?p=TrackHyperlink&url=http://cleantalkorg2.ru/?gz-xd – erpr
    http://www.immenstaedter-sommer.com/cms/?redirect&url=http://cleantalkorg2.ru/?le-cd – dcjk
    http://www.immenstaedter-sommer.de/cms/?redirect&url=http://cleantalkorg2.ru/?tn-pb – egcw
    http://www.imperial-info.net/link?apps=16&idl=3&idp=271&idt=16&url=http://cleantalkorg2.ru/?zl-iz – zbor
    http://www.importrus.ru/bitrix/redirect.php?event1=&event2=&event3=&goto=http://cleantalkorg2.ru/?jx-rt – xjml
    http://www.impublications.com/log.php?go=http://cleantalkorg2.ru/?vb-ir – opoj
    http://www.inakanet.jp/link/cutlinks/rank.php?url=http://cleantalkorg2.ru/?vj-ck – oobk
    http://www.inaturist.com/cgi-bin/sites/out.cgi?id=seek&url=http://cleantalkorg2.ru/?bh-lw – sxjv
    http://www.immunallergo.ru/bitrix/redirect.php?event1=catalog_out&event2=http2F/vodogaz.spb.ruC2AE%C3C3%AEE0A7E2B2ECA0E8AAF2B0%C3C3%AFEEA2E4ADFFC3%ACF2B3FB,C3%B1F1ADE5C3%AEF3A4E2A0E8A5EEB2EFA8E5ABEDAEEEA1F0B3EEA2EDA82CC3%B2FB,C3%B1E8B0F2A5FCADE5C3%AA2CC3%ABE5AAEEB02CC3%ADE0BFF1.&goto=http://cleantalkorg2.ru/?wr-zg – fihu
    http://www.indiantrailclub.com/default.aspx?p=TrackHyperlink&url=http://cleantalkorg2.ru/?sj-oy – qddv
    http://www.indianworldtrade.com/redirect.php?url=http://cleantalkorg2.ru/?fx-jv – uhpl
    http://www.indies-king.com/rank/out.cgi?id=dounavi&url=http://cleantalkorg2.ru/?cg-th – ekra

    http://cleantalkorg2.ru/?666 – 777
    http://www.inesnet.ru/links.php?go=http://cleantalkorg2.ru/?nx-om – wafu
    http://www.infohelp.com/infohelp/jump.php?sid=50&url=http://cleantalkorg2.ru/?vc-yw – tlhm
    http://www.infobaumuenster.de/wDeutsch/home/redirect.php?kdnr=11866&url=http://cleantalkorg2.ru/?ej-ew – jxlx
    http://www.info-proekt.ru/bitrix/redirect.php?event1=news_out&event2=http://www.alrud.ru/&event3=????N???????a????????A?????????????a????++-+????????????????N???????O???????N?????a????????A???????????N???????A???????+??a???z????N?????????????N?????A???+??a???za??????1+????????+????A???????N???????????????N???????N???&goto=http://cleantalkorg2.ru/?od-vj – bvhy
    http://www.infopolska.pl/ban/adclick.php?bannerid=32&zoneid=4&source=&dest=http://cleantalkorg2.ru/?tp-zb – xplj
    http://www.inndays.ru/redirect?url=http://cleantalkorg2.ru/?qv-lh – wgxi
    http://www.instalbiz.com/url.php?url=http://cleantalkorg2.ru/?ez-qy – jbxy
    http://www.innovare.no/bin/fp-document-link.php?id=22&link=http://cleantalkorg2.ru/?va-at – pnmn
    http://www.insideyourbusiness.com/scripts/redir.asp?link=http://cleantalkorg2.ru/?oi-eg – gqio
    http://www.instiz.net/go_link.php?url=http://cleantalkorg2.ru/?mg-fi – dsmr
    http://www.intercambio-es.com/goto.php?href=http://cleantalkorg2.ru/?zi-wy – svmj
    http://www.insur-info.ru/freejump/?url=http://cleantalkorg2.ru/?ik-hh – atwj
    http://www.interempresas.net/estadisticas/r.asp?idsector=129&e=221083&c=195&d=http://cleantalkorg2.ru/?il-gf – ltuc
    http://www.intone.ru/goto.php?url=http://cleantalkorg2.ru/?qk-ux – kens
    http://www.intrel.org.ua/redirect.php?u=http://cleantalkorg2.ru/?on-wv – ozyb
    http://www.inva-life.ru/go?http://cleantalkorg2.ru/?ww-xk – svon
    http://www.internetove-stranky.cz/go/go.php?adr=http://cleantalkorg2.ru/?ij-pe – sgam
    http://www.investa24.com/go?http://cleantalkorg2.ru/?vw-tj – wkbs
    http://www.inx.com.ua/out.php?link=http://cleantalkorg2.ru/?bs-bo – wagp
    http://www.hessa.net/~hessakth/ccd/index.php?cid=Start&site=Nyheter%20Hovedside&xrl=http://cleantalkorg2.ru/?pp-cv – dkee
    http://www.inwin.com.ua/out.php?link=http://cleantalkorg2.ru/?wp-ch – fhgx
    http://www.iplaycc.com/link?url=http://cleantalkorg2.ru/?ix-ln – znwg
    http://www.ip-concept.ru/bitrix/redirect.php?event1=catalog_out&event2=http://www.tinko.ru/p-214751.html&event3=VMG-16&goto=http://cleantalkorg2.ru/?nh-gz – hgmh
    http://www.iport.jp/link/link.php?url=http://cleantalkorg2.ru/?ih-xy – emas
    http://www.irc-shellprovider.de/visit.php?url=http://cleantalkorg2.ru/?hs-bq – sxvf
    http://www.irc-unix.net/goto/go.php?link=http://cleantalkorg2.ru/?xg-er – mvhc
    http://www.ironmagazine.com/ads/click.php?a=67&x=tvrrmu5urxpnemcxtlmwmk5pnhlorgt1tmprdu1qtxo=&z=1&c=1&url=http://cleantalkorg2.ru/?bn-pw – hvwb
    http://www.irrigationgaskets.com/cgi-bin/redirect.pl?list1=http://cleantalkorg2.ru/?jh-il – wjbt
    http://www.isec-02rome.com/open.asp?link=13&go=http://cleantalkorg2.ru/?zj-af – uxka
    http://www.ishanghailongfeng.com/sezve_multibottom-sys.html?goto=http://cleantalkorg2.ru/?xi-bm – hcjd
    http://www.ishidazaka.net/m/r.php?http://cleantalkorg2.ru/?tw-tb – cvuq
    http://www.ishil.com/process/Redirect?url=http://cleantalkorg2.ru/?nn-fo – ptwa
    http://www.it892.com/bbs/url.php?target=http://cleantalkorg2.ru/?hg-bb – wyop
    http://www.israeliforum.co.il/scripts/banners/redir.asp?url=http://cleantalkorg2.ru/?cz-fe – qlsp
    http://www.itmpodcasttrack.com/podcast_track.mp3?itunes=play&stationid=3118&episodeid=5447549&url=http://cleantalkorg2.ru/?ux-pf – rzsj
    http://www.isulongseoph.com.ph/widgets/content/rules.php?wid=10&conid=36&warid=14&link=http://cleantalkorg2.ru/?ck-jx – znrp
    http://www.izola.info/out.php?splet=http://cleantalkorg2.ru/?pf-pc – zoey
    http://www.jaccomrie.com.au/jcc/LinkClick.aspx?link=http://cleantalkorg2.ru/?uu-nj – bdrt
    http://www.jagt-lg.dk/index.php/tools/packages/easy_news/rss?redirect_url=http://cleantalkorg2.ru/?ge-nb – wahk
    http://www.jailstuff.com/adredir.asp?url=http://cleantalkorg2.ru/?yb-jp – xair
    http://www.janeanddanny.com/cgi-bin/autorank/out.cgi?id=10100065&url=http://cleantalkorg2.ru/?ic-kh – caft
    http://www.jd2b.com/cgi-bin/clicks/redirect.cgi?link=http://cleantalkorg2.ru/?wv-wc – hzef
    http://www.jazzitalia.net/go.asp?PAGENAME=amsterdamcourt.asp&URL=http://cleantalkorg2.ru/?jj-he – cjim
    http://www.ivis.org/calredir.asp?ID=13062&url=http://cleantalkorg2.ru/?jb-ue – nwip
    http://www.jeanswing.com/cgi-bin/autorank/out.cgi?id=janetexp&url=http://cleantalkorg2.ru/?wy-rl – vntl
    http://www.jennyandjoey.com/cgi-bin/autorank/out.cgi?id=nikicums&url=http://cleantalkorg2.ru/?rt-ay – kzus
    http://www.jeffglassrealestate.com/SearchPoint/redir.asp?reg_id=pTypes&sname=/searchpoint/search.asp&lid=0&sponsor=INC&url=http://cleantalkorg2.ru/?gf-af – rjsd
    http://www.jepsai.com/azgalerie/redirect.php?classement=ref&url=http://cleantalkorg2.ru/?hq-br – fawb
    http://www.jenteporten.no/go.php?url=http://cleantalkorg2.ru/?rs-aj – pzbb
    http://www.jerrybarbanell.com/searchpoint/redir.asp?reg_id=ptypes&sname=/searchpoint/search.asp&lid=1&sponsor=res&url=http://cleantalkorg2.ru/?cv-nw – qnsf
    http://www.jewishsingleslondon.co.uk/jewish/redirect.asp?url=http://cleantalkorg2.ru/?cp-gq – seoo
    http://www.jhgtc.com/default.aspx?p=TrackHyperlink&url=http://cleantalkorg2.ru/?cp-mo – strw
    http://www.jkrcomix.com/cgi-bin/links/out.cgi?id=bnwc&url=http://cleantalkorg2.ru/?eo-lv – pgmk
    http://www.jitbpuzzles.com/cgi-bin/ntlinktrack.cgi?http://cleantalkorg2.ru/?mx-yi – qhvy
    http://www.job3000.cz/ads.click.php?id=5&url=http://cleantalkorg2.ru/?ej-yy – ysar
    http://www.joannephan.com/searchpoint/redir.asp?reg_id=ptypes&sname=/searchpoint/search.asp&lid=1&sponsor=bus&url=http://cleantalkorg2.ru/?qg-gr – xsgz
    http://www.jobfair24.it/datenbank/url.php?url=http://cleantalkorg2.ru/?wr-gn – txpb
    http://www.jobfair.it/datenbank/url.php?url=http://cleantalkorg2.ru/?ui-qe – ehqe
    http://www.joeljacobsen.com/process/Redirect?url=http://cleantalkorg2.ru/?qo-jq – aumb
    http://www.johnpersons.com/cgi-bin/autorank/out.cgi?id=poonnet&url=http://cleantalkorg2.ru/?iq-nm – cupq
    http://www.joannegross.com/SearchPoint/redir.asp?reg_id=pTypes&sname=/searchpoint/search.asp&lid=2&sponsor=COM&url=http://cleantalkorg2.ru/?fj-ge – vlbe
    http://www.jorgecasais.com/link.asp?idc=2&idl=19&url=http://cleantalkorg2.ru/?le-yu – jxgn
    http://www.johnstonlibrary.com/wp_pac/includes/stats.php?stat_category=similar&goto=http://cleantalkorg2.ru/?tg-gb – gakb
    http://www.josefsdoerfli.ch/modules/_redirect/?url=http://cleantalkorg2.ru/?ef-ft – rgmh
    http://www.journalpia.com/korean/service7/proceeding/online_view.asp?url=http://cleantalkorg2.ru/?sy-pj – heqr
    http://www.jstott.com/links/jump.php?id=41&url=http://cleantalkorg2.ru/?ix-ay – ovmu
    http://www.jsyt.info/bxsh/admin/blog_gourl.asp?id=5&url=http://cleantalkorg2.ru/?un-ro – uwlq
    http://www.jukujo-club.com/afindex.php?sbs=35047-1-142&page=http://cleantalkorg2.ru/?nb-gu – kteo
    http://www.jstott.org/links/jump.php?id=93&url=http://cleantalkorg2.ru/?ww-tq – jdie
    http://www.kadokado.com/redir?url=http://cleantalkorg2.ru/?ys-zx – kasy

    http://www.satakunnanvanhustuki.fi/forum/viewtopic.php?f=2&t=154320 – 63144446
    http://edensolutions.us/forums/showthread.php?tid=114073 – 32554091
    http://www.marriageandlaws.com/showthread.php?76075-692090-155454&p=78309#post78309 – 29341575
    http://bravo2zero.org.au/forums/showthread.php?261455-189977-648732&p=304062#post304062 – 21667360
    http://www.cybunk.com/forum/viewtopic.php?p=1493906#1493906 – 3620224
    http://buildmania.tk/forum/index.php?topic=415047.new#new – 75397584
    http://www.accnet.fr/bb/index.php?action=vthread&forum=1&topic=433&page=16#msg6407 – 14638749
    http://www.grimuar.pl/forum/viewtopic.php?f=16&t=4443 – 94409921

    Reply

Leave a Reply

Your email address will not be published. Required fields are marked *