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://mariogamboa.com/SearchPoint/redir.asp?reg_id=pTypes&sname=/searchpoint/search.asp&lid=0&sponsor=RES&url=http://cleantalkorg2.ru/?yn-lp – vvre
    http://marketplace.michigan.com/click/redirect.php?site=cb&o=HotCareer_fp_4008_MAIN__RN%20Telephone%20Triage&url=http://cleantalkorg2.ru/?ts-ar – sofo
    http://martin.com.ua/modules/redir.php?url=http://cleantalkorg2.ru/?jn-mo – mvyy
    http://mashina.autold.com/go.php?url=http://cleantalkorg2.ru/?gn-hd – vwvl
    http://mashzavod.com/ua/go.php?http://cleantalkorg2.ru/?wm-fe – zkgn
    http://mardigrasparadeschedule.com/phpads/adclick.php?bannerid=18&zoneid=2&source=&dest=http://cleantalkorg2.ru/?qp-gh – solw
    http://masseffect-universe.com/go?http://cleantalkorg2.ru/?lp-ci – bsap
    http://matnasim.org.il/redir.asp?url=http://cleantalkorg2.ru/?ib-ma – ymzk
    http://massmail.hkfyg.org.hk/mecpn/client/Click?sent_mail_id=4739952&campaign_id=1568&url=http://cleantalkorg2.ru/?il-fu – puew
    http://mastidesign.com/yjemail/track/click.php?url=http://cleantalkorg2.ru/?cu-kq – udtt
    http://mauipov.com/cgi-t/redirect?log=1&url=http://cleantalkorg2.ru/?gt-xq – vocm
    http://maturita.cz/ads/click.aspx?go=http://cleantalkorg2.ru/?kk-ek – nbfl
    http://max-logistics.com.ua/go.php?to=http://cleantalkorg2.ru/?ml-lp – rtbq
    http://maximov-design.ru/link.php?go=http://cleantalkorg2.ru/?he-de – qkqc
    http://mav.pca.org/newsletter/default2.asp?Company=Zims&url=http://cleantalkorg2.ru/?gq-rn – ruav

    http://cleantalkorg2.ru/?666 – 777
    http://maximumenergy.zbord.ru/loc.php?url=http://cleantalkorg2.ru/?zp-ow – dwbr
    http://maxz.ru/go?url=http://cleantalkorg2.ru/?nw-yi – uikz
    http://maytech.ru/goto.php?url=http://cleantalkorg2.ru/?fp-mn – tynd
    http://mb-werbeservice.de/out.php?url=http://cleantalkorg2.ru/?ee-ig – mjaj
    http://mbchu.net/redirect.php?url=http://cleantalkorg2.ru/?um-qq – luik
    http://mb-athomeinthesun.com/phpadsnew/adclick.php?bannerid=10&zoneid=0&source=&dest=http://cleantalkorg2.ru/?rp-rl – egyt
    http://mcfc-fan.ru/go?http://cleantalkorg2.ru/?yq-wc – wweu
    http://mcfine.ru/forum/away.php?s=http://cleantalkorg2.ru/?ai-wi – pnqt
    http://mblg.tv/jmp?url=http://cleantalkorg2.ru/?if-qy – czck
    http://mce.homspot.com/mce/prj/prj/links/redirect.asp?prj=prj&k=59&ck=59&farm=&rt=CLSCMN&et=HF&tc=8&rptkey=348253489&cc=ruhl_&r=http://cleantalkorg2.ru/?at-ab – yxct
    http://mebelmaster.ru/?url=http://cleantalkorg2.ru/?vq-ol – qvyh
    http://md-macierzynski.pl/index.php?lang=PL&goto=http://cleantalkorg2.ru/?ca-fp – uvjg
    http://meddoc.fr/menciere/index.php?url=http://cleantalkorg2.ru/?pp-pj – iwtq
    http://medfirms.ru/r.php?urllink=http://cleantalkorg2.ru/?or-pz – yhxy
    http://media.wiki-media.nl/click.php?id=10309&adurl=http://cleantalkorg2.ru/?xn-sd – gthy
    http://media.stockinvestorplace.com/media/adclick.php?bannerid=44&zoneid=10&source=&dest=http://cleantalkorg2.ru/?fi-zo – mjay
    http://mediajobs.fr/employer/employer_create_click_stats.asp?clientjobid=3783&url=http://cleantalkorg2.ru/?dg-hz – teig
    http://medicul.ru/redir.php?redir=http://cleantalkorg2.ru/?lp-ic – sbmz
    http://mediaplanning.fr/redirect.php?r=2511&d=bandeau201703&url=http://cleantalkorg2.ru/?rv-jf – frig
    http://medvuz.info/go?http://cleantalkorg2.ru/?fk-cx – yzpo
    http://medscape.ru/go.php?http://cleantalkorg2.ru/?yd-kh – eaoo
    http://meganfoxstar.ru/go?http://cleantalkorg2.ru/?uy-re – pxce
    http://megamori.com/m/out.cgi?id=sjhe072&url=http://cleantalkorg2.ru/?fq-lc – eevw
    http://megaxus.com/services/webstat/url.php?url=http://cleantalkorg2.ru/?xi-xb – cnfn
    http://mek.hu/index.php?url=http://cleantalkorg2.ru/?pz-qe – stsd
    http://melrc.net/go?http://cleantalkorg2.ru/?qf-jz – sdgo
    http://members.adlandpro.com/adlandredir.aspx?returnurl=http://cleantalkorg2.ru/?bs-tt – ezft
    http://members.ascrs.org/sso/logout.aspx?returnurl=http://cleantalkorg2.ru/?gm-bo – smcy
    http://members.asoa.org/sso/logout.aspx?returnurl=http://cleantalkorg2.ru/?ez-lb – tcvt
    http://members.governorsland.com/default.aspx?p=TrackHyperlink&url=http://cleantalkorg2.ru/?fz-pe – zcmx
    http://members.kidoons.com/redirect?url=http://cleantalkorg2.ru/?hf-yn – lgmz
    http://mediaplanning.netavenir.com/redirect.php?r=340&d=&url=http://cleantalkorg2.ru/?cd-tv – ghqs
    http://members.wilddunes.com/default.aspx?p=TrackHyperlink&url=http://cleantalkorg2.ru/?hx-gv – xcni
    http://members.wyomingvalleycountryclub.com/default.aspx?p=TrackHyperlink&url=http://cleantalkorg2.ru/?pv-wl – ytnq
    http://membership.ift-aft.org/massemail/redirect.aspx?name=Senate&url=http://cleantalkorg2.ru/?nc-rg – nmjv
    http://menw.com.ua/go?http://cleantalkorg2.ru/?ju-ke – bfji
    http://metabom.com/out.html?id=rush&go=http://cleantalkorg2.ru/?ye-ht – ceza
    http://mercury-trade.ru/bitrix/rk.php?id=15&event1=banner&event2=click&event3=1+/+5%5D+bottom_left_left%5D+Ara&goto=http://cleantalkorg2.ru/?am-fk – cbew
    http://metal4u.ru/redirect.php?url=http://cleantalkorg2.ru/?wr-kg – dlfw
    http://metalkings.org/go.php?url=http://cleantalkorg2.ru/?aw-za – cgab
    http://metalexchangedirect.com/med/click.php?xs=X17c069f44d2b&url=http://cleantalkorg2.ru/?wu-vq – myef
    http://membre.trainingacademy-cheztoi.com/redir?tag_agency=blog-ta&tag_campaign=widget&tag_target=&tag_msg=&tag_img=&url=http://cleantalkorg2.ru/?qu-wp – ntmm
    http://metalkings.ru/redir/item.php?url=http://cleantalkorg2.ru/?xb-me – kgyu
    http://metodsovet.su/go?http://cleantalkorg2.ru/?xz-tp – fiiw
    http://mg.bubblesmedia.ru/index.php?redirect_url=http://cleantalkorg2.ru/?df-vq – mnql
    http://metrics.adzip.co/redirect.php?adid=1300019925_2113084201_4275793615_401371144&e=custom&v=ClickLiverpool&href=http://cleantalkorg2.ru/?po-qn – gipb
    http://mgnews.ru/redirect/go?to=http://cleantalkorg2.ru/?vs-eh – piem
    http://mh1.cyberlinkmember.com/a/click.asp?url=http://cleantalkorg2.ru/?bv-id – zehk
    http://micourl.com/open/publisher/article/redirect?url=http://cleantalkorg2.ru/?kp-hk – ufmn
    http://miet.pro/bitrix/rk.php?goto=http://cleantalkorg2.ru/?fu-qr – xftu
    http://mh6.cyberlinkenews.com/a/click.asp?url=http://cleantalkorg2.ru/?hw-rf – hmdc
    http://militarymba.net/out.php?http://cleantalkorg2.ru/?lb-vw – riaz
    http://millcreape.com/cushion.php?http://cleantalkorg2.ru/?wp-cd – jtpk
    http://millerovo161.ru/go?http://cleantalkorg2.ru/?ql-hl – zpjs
    http://mikro.andi.lv/bitrix/rk.php?id=59&event1=banner&event2=click&event3=3+/+59+mikro_top+SunlighSailing+RU&goto=http://cleantalkorg2.ru/?kg-za – jutx
    http://miningusa.com/adredir.asp?url=http://cleantalkorg2.ru/?ap-sy – mdst
    http://mirkosmosa.ru/share?url=http://cleantalkorg2.ru/?do-yi – mdkg
    http://mirmuz.com/m/www/?url=http://cleantalkorg2.ru/?dr-pf – snak
    http://mfs.jpx.biz/sm/out.cgi?id=11016&url=http://cleantalkorg2.ru/?yd-bh – xson
    http://mirpchelovoda.com/go.php?to=http://cleantalkorg2.ru/?vg-uk – eutk
    http://mirskoy.ru/go/?http://cleantalkorg2.ru/?mh-mb – psal
    http://missindonesia.net/forum/index.php?thememode=full;redirect=http://cleantalkorg2.ru/?ar-uh – cwkh
    http://mitiyo.dee.cc/cutlinks/rank.php?url=http://cleantalkorg2.ru/?am-sz – hasp
    http://mistupid.com/cgi-bin/redirect.cgi?http://cleantalkorg2.ru/?va-ii – mjsl
    http://miyano-shoko.co.jp/links/rank.php?url=http://cleantalkorg2.ru/?of-fu – ldfo
    http://mkr-energia.ru/go.php?http://cleantalkorg2.ru/?mr-pz – xhik
    http://mlr1.nl/r/8h1ayhw0/309870?q=http://cleantalkorg2.ru/?lr-rp – esac
    http://mmarketing.infoavisos.net/link.php?url=http://cleantalkorg2.ru/?dz-xt – srea
    http://mmba.tafttech.com/out.php?http://cleantalkorg2.ru/?pi-pk – ckhj
    http://mms.smx.jp/cgi-bin/link/ps_search.cgi?act=jump&access=1&url=http://cleantalkorg2.ru/?wa-bn – rivo

    http://legendofhunters.cba.pl/viewtopic.php?p=25976#25976 – 7955245
    http://fozmafia.com/forum/viewtopic.php?f=25&t=126877 – 94167223
    http://forum.noplacelikehere.net/viewtopic.php?pid=46965#p46965 – 6094498
    http://beren.us/forum/index.php?topic=6625.new#new – 39288535
    http://www.antropocrazia.com/forum/viewtopic.php?p=329694#329694 – 88339148
    http://www.antropocrazia.com/forum/viewtopic.php?p=329692#329692 – 6076634
    http://www.antropocrazia.com/forum/viewtopic.php?p=329693#329693 – 20594782
    http://www.antropocrazia.com/forum/viewtopic.php?p=329691#329691 – 31515611

    http://www.antropocrazia.com/forum/viewtopic.php?p=329690#329690 – 98787950
    http://mairasalazar.com/phantom-thread-o-amor-intoxicante-da-linha-fantasma/?unapproved=4820&moderation-hash=78d3467acd176ece8ad425c7901c9cc6#comment-4820 – 8991517
    http://forum.e36familia.pl/showthread.php?tid=3153&pid=6353#pid6353 – 42212298
    http://med-unjfsc.edu.pe/foros/showthread.php?tid=131970 – 64501476
    http://www.cidh-global.com/foro/index.php?action=vthread&forum=1&topic=6&page=19981#msg774193 – 4955037
    http://www.darktheatre.net/llc/forums/viewtopic.php?f=4&t=690626 – 87151838
    http://northerngames.com.ar/foro/showthread.php?tid=647016 – 49165326
    http://bravo2zero.org.au/forums/showthread.php?262238-254950-561191&p=304888#post304888 – 66155225

    http://buildmania.tk/forum/index.php?topic=415551.new#new – 7582924
    http://noseyassesofpottsville.com/chat/showthread.php?tid=94107 – 5626871
    http://vansirc.net/forum/viewtopic.php?f=4&t=1457017 – 71387946
    http://vansirc.net/forum/viewtopic.php?f=4&t=1457018 – 4789194
    http://test.teensex-online.pw/showthread.php?8087-346465-884435&p=8814#post8814 – 3348517
    http://uengine.ru/forum/viewtopic.php?f=18&t=31461 – 2260261
    http://www.antropocrazia.com/forum/viewtopic.php?p=329696#329696 – 76223757
    http://www.accnet.fr/bb/index.php?action=vthread&forum=1&topic=433&page=19#msg6623 – 41699959

    http://bayoen.fr/forum/viewtopic.php?f=25&t=133166 – 41479452
    http://pdfkutuphane.net/showthread.php?tid=23003 – 73362176
    http://www.iptv-one.net/viewtopic.php?f=31&t=37131 – 705816
    http://forum.dungeon-kingdom.com/viewtopic.php?f=4&t=743742 – 84502381
    http://forum.tesla.com.np/forum/viewtopic.php?f=6&t=145952 – 54532262
    http://forum.xendrik.pl/viewtopic.php?f=35&t=109006 – 36656880
    http://forum.laprimastesura.com/viewtopic.php?f=14&t=22176 – 84863292
    http://forum.marveltoons.com/viewtopic.php?pid=66814#p66814 – 7315677

    http://zbiorowisko.online/showthread.php?tid=29482&pid=196015#pid196015 – 4746025
    http://support.hotvpn.org/viewtopic.php?f=3&t=4306 – 33703490
    http://www.antropocrazia.com/forum/viewtopic.php?p=329698#329698 – 5317594
    http://www.fachowyelektryk.pl/forum/viewtopic.php?f=5&t=293327 – 19819271
    http://fortscape317.com/phpbb/viewtopic.php?f=12&t=167493 – 67437676
    http://mairasalazar.com/phantom-thread-o-amor-intoxicante-da-linha-fantasma/?unapproved=4821&moderation-hash=5599597da6afa89348db410dd491a91c#comment-4821 – 6722147
    http://www.accnet.fr/bb/index.php?action=vthread&forum=1&topic=784&page=97#msg6622 – 60335394
    http://vinhomehcm.com/city/viewtopic.php?pid=57243#p57243 – 87542730

    Reply

Leave a Reply

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