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.

    https://www.blogarama.com/redirect.php?destination=http://cleantalkorg2.ru/?vx-rc – kueg
    https://www.fahrradreisen-wanderreisen.de/redirect/?url=http://cleantalkorg2.ru/?zo-ad – lnfl
    https://susanin.news/bitrix/redirect.php?event1=catalog_out&event2=http://www.resboiu.ro&event3=????????+?????????+????,+???+??????????+????????+???????+???+???+?????????&goto=http://cleantalkorg2.ru/?dv-xx – yrxs
    https://g.nowo.com/url?source=finance&q=http://cleantalkorg2.ru/?hx-tb – bmrq
    http://xn--28-7lcedl4f.xn--p1ai/bitrix/redirect.php?event1=&event2=&event3=&goto=http://cleantalkorg2.ru/?em-yj – rkdr
    http://citcat.com/cc?i=http%3A%2F%2Fcleantalkorg2.ru%2F&l=1&t=l&m=&lw_s= – lvch
    http://audioworld.com/cgi-bin/FrameIt.cgi?Url=http://cleantalkorg2.ru/?vg-ca – zuja
    https://www.liujunchen.cc/url?q=http://cleantalkorg2.ru/?kb-kv – krox
    https://ultramar-ti.com/redirect/Index.asp?url=http://cleantalkorg2.ru/?xp-qp – moys
    http://finneycountyhelpdesk.org/redirect/?url=http://cleantalkorg2.ru/?ac-hw – qblw
    http://dir.webring.com/l/rd?id=11&ring=rockpaintings&url=http://cleantalkorg2.ru/?pj-qj – ochm
    http://gngate.com/portal/frames.php?siteurl=http://cleantalkorg2.ru/?jb-tk – wkoc
    http://greekspider.com/target.asp?target=http://cleantalkorg2.ru/?bl-zo – xyzf
    http://hir.ize.hu/click.php?id=251585&categ_id=7&url=http://cleantalkorg2.ru/?gh-qm – hvlt
    http://indiaserver.com/cgi-bin/news/out.cgi?url=http://cleantalkorg2.ru/?mh-uq – apei

    http://cleantalkorg2.ru/?666 – 777
    http://katalog.krstarica.com/s/index.php?s=http://cleantalkorg2.ru/?pb-mf – pbgv
    http://liense-h.cats-eden.net/cif.php?site=http://cleantalkorg2.ru/?so-td – acjh
    http://us.zilok.com/item/redirect/?url=http://cleantalkorg2.ru/?wv-lf – xysz
    http://www.campeggi-italia.com/visita.asp?url=http://cleantalkorg2.ru/?mu-sc – piai
    http://www.allbeaches.net/goframe.cfm?site=http://cleantalkorg2.ru/?yy-hy – qvxk
    http://www.floridakeys.net/frame.cfm?linkurl=http://cleantalkorg2.ru/?zj-fk – rifl
    http://www.diversitybusiness.com/SpecialFunctions/NewSiteReferences.asp?NwSiteURL=http://cleantalkorg2.ru/?aa-vd – zbpj
    http://www.gostar-racing.com/cgi-bin/ybf.pl?url==http://cleantalkorg2.ru/?bz-ca – eynj
    http://www.islamicentre.org/link.asp?link=http://cleantalkorg2.ru/?rs-fo – dzpq
    http://www.linkestan.com/frame-click.asp?url=http://cleantalkorg2.ru/?oo-nl – krdg
    http://www.metta.org.uk/eweb/?web=http://cleantalkorg2.ru/?ge-xx – ykcq
    http://www.motorfietsweb.nl/nederlands/frameset-nl.php?content=http://cleantalkorg2.ru/?cv-cm – uegw
    http://www.paidmania.com/getpaid/frame_signup/0?refurl=http://cleantalkorg2.ru/?sj-yr – ratf
    http://www.robertlerner.com/cgi-bin/links/ybf.cgi?url==http://cleantalkorg2.ru/?rn-dl – ival
    http://www.rpklublin.pl/skins/rpk/redirect.php?url=http://cleantalkorg2.ru/?jt-dg – qxxq
    http://www.sacc.to/_cgi/common/redirect.asp?site=http://cleantalkorg2.ru/?kz-tu – pzbo
    http://www.timoore.eu/skins/timoore/redirect.php?url=http://cleantalkorg2.ru/?im-hu – zwuo
    http://www.transitaire.info/cgi-bin/erawan/smartframe.cgi?http://cleantalkorg2.ru/?hp-cf – cngd
    http://12ym.com/plugin/browser.aspx?http://cleantalkorg2.ru/?ny-gc – dyrx
    http://baunerreon.com/compartilhar.php?url=http://cleantalkorg2.ru/?se-qr – hggi
    http://blog.alreego.com/go.php?link=http://cleantalkorg2.ru/?bg-ho – vucw
    http://gorod-belgorod.ru/widgets/outside/?url=http://cleantalkorg2.ru/?hk-eb – zjop
    http://gorod-novgorod.ru/widgets/outside/?url=http://cleantalkorg2.ru/?fo-df – mgzu
    http://gorod-novosibirsk.ru/widgets/outside/?url=http://cleantalkorg2.ru/?mh-ek – euql
    http://www.worldtravelhotdeals.com/cgi-bin/frame/smartframe.cgi?http://cleantalkorg2.ru/?vo-fn – coyc
    http://gorod-ivanovo.ru/widgets/outside/?url=http://cleantalkorg2.ru/?iq-wr – tuel
    http://gorod-orel.ru/widgets/outside/?url=http://cleantalkorg2.ru/?ga-wm – vyji
    http://gorod-perm.ru/widgets/outside/?url=http://cleantalkorg2.ru/?bl-mu – cgjh
    http://gorod-orenburg.ru/widgets/outside/?url=http://cleantalkorg2.ru/?vy-ni – sdqy
    http://gorod-tambov.ru/widgets/outside/?url=http://cleantalkorg2.ru/?wf-jk – vfwo
    http://gorod-ryazan.ru/widgets/outside/?url=http://cleantalkorg2.ru/?tk-ut – jpik
    http://gorod-tula.ru/widgets/outside/?url=http://cleantalkorg2.ru/?ps-hd – mfes
    http://gorod-wologda.ru/widgets/outside/?url=http://cleantalkorg2.ru/?qp-uo – scky
    http://gorod-yfa.ru/widgets/outside/?url=http://cleantalkorg2.ru/?hd-od – evta
    http://idiomas.astalaweb.com/ingl%C3%A9s/_Marco.asp?dir=http://cleantalkorg2.ru/?gm-ix – mciq
    http://iscleaner.com/link.php?url=http://cleantalkorg2.ru/?cn-dh – ibep
    http://inpraiseofmotorscooters.com/ifenster.php?http://cleantalkorg2.ru/?ef-yx – efjh
    http://motor.astalaweb.net/Portales/_Marco.asp?dir=http://cleantalkorg2.ru/?tm-ac – jujf
    http://northstarshoes.com/europe/out.php?url=http://cleantalkorg2.ru/?np-gw – nstl
    http://novgorod-velikiy.ru/widgets/outside/?url=http://cleantalkorg2.ru/?jh-fo – hfxh
    http://web.fullsearch.com.ar/?url=http://cleantalkorg2.ru/?pi-aa – hvsc
    http://heti24.hu/hir-frame/Kepviselok-fizetese-van-aki-674-ezerrel-tobbet-keres-majd/996395/?url=http://cleantalkorg2.ru/?eo-bf – newv
    http://www.activecabarete.com/links/index.php?http://cleantalkorg2.ru/?qs-lo – yfyy
    http://www.badmoon-racing.jp/frame/?url=http://cleantalkorg2.ru/?bp-jw – mwlh
    http://www.cinema-paradiso.at/site/extern.php?url=http://cleantalkorg2.ru/?ly-gp – hmnb
    http://www.fuorisito.it/myframe/?h=1400&t=Rassegna%20Stampa&l=http://cleantalkorg2.ru/?kv-qu – ixss
    http://www.gorod-kirow.ru/widgets/outside/?url=http://cleantalkorg2.ru/?co-zy – gqgb
    http://www.hashiriya.jp/url.cgi?http://cleantalkorg2.ru/?rg-gn – rdfk
    http://www.themichae.parks.com/external.php?site=http://cleantalkorg2.ru/?qv-dg – nhuu
    http://www.tvtix.com/frame.php?url=http://cleantalkorg2.ru/?cv-nu – dtwc
    http://www.marketbeat.com/URL/?url=http://cleantalkorg2.ru/?sj-hw – elxm
    http://www.tradeportalofindia.org/CountryProfile/Redirect.aspx?hidCurMenu=divOthers&CountryCode=32&CurrentMenu=IndiaandEU&Redirecturl=http://cleantalkorg2.ru/?lb-dl – eags
    https://www.domainsherpa.com/share.php?site=http://cleantalkorg2.ru/?ii-it – kqnp
    https://www.regioinbedrijf.nl/iframe.php?website=http://cleantalkorg2.ru/?rg-co – tmtl
    https://www.slevici.cz/default/discount-url/2945?s_url=http://cleantalkorg2.ru/?nb-tk – hodr
    http://1-profit.ru/bitrix/redirect.php?event1=&event2=&event3=&goto=http://cleantalkorg2.ru/?oc-ab – ymwn
    http://1001kalyan.ru/bitrix/redirect.php?event1=&event2=&event3=&goto=http://cleantalkorg2.ru/?bl-sv – kjrn
    http://100service.ru/bitrix/rk.php?goto=http://cleantalkorg2.ru/?lz-ka – rqfk
    http://100cvety.ru/bitrix/redirect.php?event1=&event2=&event3=&goto=http://cleantalkorg2.ru/?ag-em – mfcw
    http://101crm.ru/bitrix/redirect.php?event1=&event2=&event3=&goto=http://cleantalkorg2.ru/?zo-rg – kgxl
    http://1c-mining.ru/bitrix/redirect.php?event1=&event2=&event3=&goto=http://cleantalkorg2.ru/?ru-ie – cqdm
    http://1c.ua/bitrix/redirect.php?event1=&event2=&event3=&goto=http://cleantalkorg2.ru/?oz-jp – wtpa
    http://1c-sovmestimo.ru/bitrix/redirect.php?event1=&event2=&event3=&goto=http://cleantalkorg2.ru/?zd-mc – naxa
    http://1c-sovmestno.ru/bitrix/redirect.php?event1=&event2=&event3=&goto=http://cleantalkorg2.ru/?lr-lm – qbsi
    http://1csovmestimo.ru/bitrix/redirect.php?event1=&event2=&event3=&goto=http://cleantalkorg2.ru/?jr-mp – dbua
    http://1mega-group.com/bitrix/rk.php?goto=http://cleantalkorg2.ru/?zk-kf – zerm
    http://1hleb.ru/bitrix/redirect.php?event1=&event2=&event3=&goto=http://cleantalkorg2.ru/?ln-tg – jcrw
    http://1slink.ru/bitrix/redirect.php?event1=&event2=&event3=&goto=http://cleantalkorg2.ru/?py-ms – ilai
    http://1sovmestimo.ru/bitrix/rk.php?goto=http://cleantalkorg2.ru/?qz-qv – gqio
    http://21side.ru/bitrix/redirect.php?event1=&event2=&event3=&goto=http://cleantalkorg2.ru/?km-uk – eerj

    http://www.grimuar.pl/forum/viewtopic.php?f=16&t=4455 – 953626
    http://www.antropocrazia.com/forum/viewtopic.php?p=328025&sid=209d4686a080783a93409764cd6b8f83#328025 – 41928894
    http://clublaguna.ru/showthread.php?t=84991&p=254426#post254426 – 3661893
    http://www.antropocrazia.com/forum/viewtopic.php?p=328029#328029 – 33344664
    http://myesl.ca/forum/viewtopic.php?f=3&t=677149 – 71632752
    http://sizceforum.com/viewtopic.php?f=12&t=44380 – 4181893
    http://uengine.ru/forum/viewtopic.php?f=18&t=31280 – 3725481
    http://argentinad2l.uphero.com/viewtopic.php?f=1&t=3364 – 6597850

    Reply

Leave a Reply

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