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.irseca.net/wbb2/redir.php?url=http://cleantalkorg2.ru/?mg-yn – euzo
    http://www.jkes.tyc.edu.tw/dyna/webs/gotourl.php?id=357&url=http://cleantalkorg2.ru/?kx-ww – halk
    http://www.joi3.com/go.php?url=http://cleantalkorg2.ru/?do-ab – xmlc
    http://www.joinalive.jp/2016/tickets/link.php?rurl=http://cleantalkorg2.ru/?og-tu – heub
    http://www.kamionaci.cz/redirect.php?url=http://cleantalkorg2.ru/?qx-um – vhwm
    http://www.kgs-st-joachim.de/go.php?link=http://cleantalkorg2.ru/?gw-io – tedd
    http://www.kirolan.ru/bitrix/rk.php?goto=http://cleantalkorg2.ru/?sy-mp – bksw
    http://www.kroncbs.ru/go.php?url=http://cleantalkorg2.ru/?uu-of – xlzz
    http://www.lay-el.net/cgi-bin/ac.cgi?url=http://cleantalkorg2.ru/?fm-kc – xddl
    http://www.logycom.kz/bitrix/redirect.php?event1=u0435%u0440u0445%u043E20%u043D20%u041Cu0411%20u0443%u0442u043E%u0440u0438%u043D%u0433&event2=&event3=&goto=http://cleantalkorg2.ru/?vk-yf – qegt
    http://www.mega-mir.com/bitrix/redirect.php?event1=mega-mir&event2=gkeuropa&goto=http://cleantalkorg2.ru/?jq-rm – bcsb
    http://www.menej.sk/redirect.php?tool=mobile-cards&url=http://cleantalkorg2.ru/?ql-jx – blmi
    http://www.mega-pro.ru/bitrix/rk.php?id=400&site_id=er&event1=banner&event2=click&event3=1+/+00%5D+pro_4%5D+&goto=http://cleantalkorg2.ru/?jf-lp – clqe
    http://www.mesk.ru/bitrix/rk.php?goto=http://cleantalkorg2.ru/?pm-an – wnqt
    http://www.mifa.cz/mifa/redirect.php?url=http://cleantalkorg2.ru/?ss-oi – yxje

    http://cleantalkorg2.ru/?666 – 777
    http://www.mobilepriceindia.co.in/trackview?url=http://cleantalkorg2.ru/?vn-pv – tcat
    http://www.mrpretzels.com/locations/redirect.aspx?url=http://cleantalkorg2.ru/?pp-ij – fvic
    http://www.myaso-portal.ru/bitrix/redirect.php?goto=http://cleantalkorg2.ru/?wn-vf – enva
    http://www.myelectriccarforums.com/redirect.php?url=http://cleantalkorg2.ru/?mz-sh – bhlc
    http://www.najcena.si/goredir.php?url=http://cleantalkorg2.ru/?fy-qf – hxfs
    http://www.oilru.com/go.php?URL=http://cleantalkorg2.ru/?hq-sg – ldla
    http://www.oldmanclan.de/wbb2/ct_redir.php?url=http://cleantalkorg2.ru/?yu-yl – njef
    http://www.flandria.ru/bitrix/rk.php?goto=http://cleantalkorg2.ru/?ma-jx – uzbq
    http://www.paranormalne.eu/redir.php?url=http://cleantalkorg2.ru/?qb-we – kfli
    http://www.pipasiapacific.com/en/linkout.php?url=http://cleantalkorg2.ru/?ee-fl – cosg
    http://www.polseguera.org/cgi-bin/forum/gforum.cgi?url=http://cleantalkorg2.ru/?tt-jc – nvex
    http://www.qualicore.de/redirect.php?link=http://cleantalkorg2.ru/?kp-aa – grzo
    http://www.quickmetall.com/en/link.aspx?url=http://cleantalkorg2.ru/?tt-wl – yqoe
    http://www.raut.ru/bitrix/rk.php?goto=http://cleantalkorg2.ru/?hb-lf – bait
    http://www.regione.sardegna.it/j/v/511?s=1&v=9&c=243&nodesc=1&url=http://cleantalkorg2.ru/?fv-br – kyph
    http://www.saperion.ru/bitrix/redirect.php?event1=&event2=&event3=&goto=http://cleantalkorg2.ru/?fs-pj – ohye
    http://www.roetti.de/Oststammtisch-Forum/Forum/go.php?url=http://cleantalkorg2.ru/?bm-pt – gato
    http://www.s-quo.com/bitrix/redirect.php?event1=catalog_out&event2=http2F%2Fwww.s-quo.com2Fclub.php2F1922%2F&event3=Yiannos+Georgiades&goto=http://cleantalkorg2.ru/?yy-yd – ebfr
    http://www.satico.ru/bitrix/redirect.php?event1=satico&event2=twitter&event3=out&goto=http://cleantalkorg2.ru/?ty-rp – zxpe
    http://vtishop.kz/bitrix/redirect.php?event1=&event2=&event3=&goto=http://cleantalkorg2.ru/?zj-yx – vrpz
    http://www.schatzsuchen.de/link.pl?http://cleantalkorg2.ru/?oe-tq – bmnk
    http://www.schekino.ru/bitrix/rk.php?goto=http://cleantalkorg2.ru/?pr-of – gdeg
    http://www.servicetrend.ru/bitrix/rk.php?goto=http://cleantalkorg2.ru/?qq-id – lhnc
    http://www.scire.coppe.ufrj.br/_atrio_change_url/url-redir.php?url=http://cleantalkorg2.ru/?cq-dd – bfkm
    http://www.rsci.ru/bitrix/rk.php?goto=http://cleantalkorg2.ru/?ei-op – olsg
    http://www.smstender.ru/redirect.php?url=http://cleantalkorg2.ru/?ya-au – aiux
    http://www.sharjahcityguide.com/main/advertise.asp?OldUrl=http://cleantalkorg2.ru/?tv-wk – nude
    http://www.socialengine.ru/redirect.php?url=http://cleantalkorg2.ru/?an-fv – ghpl
    http://www.scamax.ru/bitrix/redirect.php?event1=&event2=&event3=&goto=http://cleantalkorg2.ru/?ky-uz – komh
    http://www.spartak-tambov.ru/redirect.php?to=http://cleantalkorg2.ru/?vt-fr – gome
    http://www.speisekarten-seite.de/redirect.asp?http://cleantalkorg2.ru/?tz-ol – jnof
    http://www.splash.it/go.php?url=http://cleantalkorg2.ru/?pb-ke – hxhs
    http://www.ssr-russia.ru/bitrix/redirect.php?event1=&event2=&event3=&goto=http://cleantalkorg2.ru/?km-va – ttik
    http://www.stats3d.com/secure/?http://cleantalkorg2.ru/?kr-bz – nnot
    http://www.starspider.de/goto.phtml?url=http://cleantalkorg2.ru/?ye-ih – msfo
    http://www.taklearn.ir/go/index.php?url=http://cleantalkorg2.ru/?rk-xw – cxkj
    http://www.tambovsport.ru/redirect.php?to=http://cleantalkorg2.ru/?fy-qv – ceba
    http://www.taxrus2000.com/rk.php?goto=http://cleantalkorg2.ru/?yr-rh – mrbn
    http://www.thaijudge.com/go.php?http://cleantalkorg2.ru/?jw-sr – yath
    http://www.strikebacktactics.com/go.php?http://cleantalkorg2.ru/?ko-bv – nurm
    http://www.tamognia.ru/bitrix/redirect.php?event1=news_out&event2=//www.tamognia.ru2Ftp%2F1543210%2F&goto=http://cleantalkorg2.ru/?jy-sm – mivj
    http://www.thesleuthjournal.com/external-link-warning/?url=http://cleantalkorg2.ru/?xp-dn – sfyj
    http://www.thienantech.com/?http://cleantalkorg2.ru/?td-sj – hghd
    http://www.thompson-travel.com/Redirect.aspx?url=http://cleantalkorg2.ru/?es-gl – jztk
    http://www.toohot.jp/livechat/out.php?out=http://cleantalkorg2.ru/?fl-fx – jxec
    http://www.topposuda.ru/bitrix/rk.php?goto=http://cleantalkorg2.ru/?ag-qa – scym
    http://www.torklift.com/stats/distributors.php?n=meyer_com&u=http://cleantalkorg2.ru/?on-zz – klgk
    http://www.uradoga.com/redirect.php?u=http://cleantalkorg2.ru/?nx-zn – iozo
    http://www.viknadveri.com.ua/modules/redir.php?url=http://cleantalkorg2.ru/?wa-uw – sxuq
    http://www.verkostungsnotizen.net/redir.php?VID=25504&URL=http://cleantalkorg2.ru/?eo-km – zcqc
    http://www.toku-jp.com/Rouge/minibbs.cgi?http://cleantalkorg2.ru/?wd-vz – rbhb
    http://www.vinfo.ru/away.php?url=http://cleantalkorg2.ru/?ei-ve – djrm
    http://www.viknadveri.com/modules/redir.php?url=http://cleantalkorg2.ru/?zu-rc – woxc
    http://www.virusfm.ru/go.php?url=http://cleantalkorg2.ru/?mk-va – xslo
    http://www.vladinfo.ru/away.php?url=http://cleantalkorg2.ru/?om-yv – bsmt
    http://www.wangzhifu.com/t/?http://cleantalkorg2.ru/?cc-ja – lcux
    http://www.winbetcasino.com/goto.php?url=http://cleantalkorg2.ru/?bh-ue – qlyc
    http://www.zeppelin-agro.ru/bitrix/rk.php?goto=http://cleantalkorg2.ru/?gr-ie – xeol
    http://x18.ru/bitrix/rk.php?goto=http://cleantalkorg2.ru/?es-uu – thfs
    http://xenon69.ru/bitrix/redirect.php?event1=&event2=&event3=&goto=http://cleantalkorg2.ru/?mk-jz – wcis
    http://xn——7cdbmi6aabt3bbs7a1a7gqc.xn--p1ai/bitrix/rk.php?goto=http://cleantalkorg2.ru/?es-no – igsa
    http://xn—–6kccgel0dwaipuk3jtc.xn--p1ai/bitrix/redirect.php?event1=&event2=&event3=&goto=http://cleantalkorg2.ru/?zi-lu – hock
    http://xn——7cdbmj4acav6ags0bya1gsc.xn--p1ai/bitrix/rk.php?goto=http://cleantalkorg2.ru/?zm-ia – nxev
    http://xn—–7kcabanabdta4ahh3dnbixac2ar4aelb.xn--p1ai/bitrix/redirect.php?event1=&event2=&event3=&goto=http://cleantalkorg2.ru/?qk-pj – ypyv
    http://xn—-7sbapcgaavabpxeerioebukwy6h9k.xn--p1ai/bitrix/redirect.php?event1=&event2=&event3=&goto=http://cleantalkorg2.ru/?gp-wr – sdht
    http://xn—-7sbbesqelfbh3bgmlq.xn--p1ai/bitrix/rk.php?goto=http://cleantalkorg2.ru/?jh-re – jqwh
    http://xn—-7sbbdach8bqfpbpdh3ei.xn--p1ai/bitrix/rk.php?goto=http://cleantalkorg2.ru/?wv-bp – qckr
    http://xn—-7sbebs3a1df6b.xn--p1ai/bitrix/rk.php?goto=http://cleantalkorg2.ru/?ej-xy – emgm
    http://xn—-7sbbaozeijqjd6cch9b1g.xn--p1ai/bitrix/redirect.php?event1=&event2=&event3=&goto=http://cleantalkorg2.ru/?vd-kt – xhez
    http://xn—-7sbpud7afchk.xn--p1ai/bitrix/redirect.php?event1=&event2=&event3=&goto=http://cleantalkorg2.ru/?jo-sz – iaqa

    http://www.consouls.com/forum/viewtopic.php?p=297957#297957 – 4794675
    http://www.cidh-global.com/foro/index.php?action=vthread&forum=1&topic=161346#msg773124 – 27388242
    http://coryn.club/forum/viewtopic.php?f=28&t=464959 – 7894556
    http://klingentaenzer.seelenfeder.at/viewtopic.php?f=4&t=22986 – 15943091
    http://www.novaufo.net/forum/showthread.php?tid=33054 – 4010939
    http://war.web-seo.eu/viewtopic.php?f=10&t=302092 – 3330402
    http://uengine.ru/forum/viewtopic.php?f=18&t=31425 – 72405616
    http://forum.meloni-group.com/showthread.php?tid=4736&pid=10244#pid10244 – 9534579

    http://aop.in.ua/communication/forum/index.php?PAGE_NAME=message&FID=3&TID=51923&MID=67670&result=new – 8474454
    http://www.skyarn.fr/forum/viewtopic.php?f=18&t=217197 – 13451624
    http://lendirabg.com/showthread.php?403539-818777-392580&p=1925978#post1925978 – 26842620
    http://www.antropocrazia.com/forum/viewtopic.php?p=329394#329394 – 83743256
    http://www.antropocrazia.com/forum/viewtopic.php?p=329393#329393 – 72206142
    http://www.avvocatoamministrativo.eu/forum/showthread.php?55761-30160-814715&p=62471#post62471 – 50418199
    http://cebucycling.com.ph/viewtopic.php?f=1&t=27975 – 39618738
    http://nnfgaming.com.br/forum/index.php?topic=866.new#new – 42379677

    http://threadmaniac.com/2019/01/13/you-may-be-a-stitcher-if/?unapproved=4646&moderation-hash=a3e12503774dc46bf98d97dc511e3a68#comment-4646 – 68626923
    http://tsterror.pl/viewtopic.php?f=2&t=8786 – 87181568
    http://clan.canadaka.ca/forum/viewtopic.php?f=1&t=14119 – 6240253
    http://mkjjj.com/forum.php?mod=viewthread&tid=2922&extra= – 41289985
    http://knowzone.ro/index.php?/topic/19881-582869-759774/ – 86172430
    http://www.yhmfl.com/bbs/forum.php?mod=viewthread&tid=2162&extra= – 39165553
    http://www.egologic.eu/nfsw/showthread.php?tid=150678 – 53654827
    http://www.darktheatre.net/llc/forums/viewtopic.php?f=4&t=690278 – 74979117

    http://mdou36.beluo31.ru/?p=274723&unapproved=39672&moderation-hash=e700226e9374380a9ae702c199945b87#comment-39672 – 8857147
    http://ngoinhachung.net/diendan/forum.php?mod=viewthread&tid=1843310&pid=2789355&page=13970&extra=#pid2789355 – 1628182
    http://noseyassesofpottsville.com/chat/showthread.php?tid=94055 – 34113972
    http://noseyassesofpottsville.com/chat/showthread.php?tid=94056 – 2281218
    http://noseyassesofpottsville.com/chat/showthread.php?tid=94057 – 26795756
    http://niklever.com/spritoon/forum/viewtopic.php?f=5&t=924493 – 6658284
    http://english4a.rx22.ru/viewtopic.php?f=2&t=27420 – 28583781
    http://www.divisionbiker.com/foro/viewtopic.php?pid=286111#p286111 – 95634891

    http://lords-mobile.nl/showthread.php?tid=86249 – 62702894
    http://www.bizetashop.it/forum/showthread.php?tid=42224 – 62361529
    http://forum.adminbelka.ru/viewtopic.php?pid=37960#p37960 – 9315898
    http://www.dummydonald.com/fluxbb/viewtopic.php?pid=11802#p11802 – 5558429
    http://etland.y0.pl/showthread.php?tid=6675 – 51719577
    http://q10.hu/forum/Thread-476254-68886 – 99887951
    http://forum.globalgoodness.ca/viewtopic.php?f=11&t=198325 – 76314250
    http://forum.meloni-group.com/showthread.php?tid=4736&pid=10245#pid10245 – 2680222

    Reply

Leave a Reply

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