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://chaparralranch.com/__media__/js/netsoltrademark.php?d=http://cleantalkorg2.ru/?bb-lj – rqge
    http://rockportpediatricdentistry.com/__media__/js/netsoltrademark.php?d=http://cleantalkorg2.ru/?ty-py – phfc
    http://kimboi.com/__media__/js/netsoltrademark.php?d=http://cleantalkorg2.ru/?cr-hp – jqvb
    http://www.adacparis.com/__media__/js/netsoltrademark.php?d=http://cleantalkorg2.ru/?pr-vk – izaq
    http://grsfashion.com/__media__/js/netsoltrademark.php?d=http://cleantalkorg2.ru/?vw-eh – gjgc
    http://cybersolutions.co/__media__/js/netsoltrademark.php?d=http://cleantalkorg2.ru/?px-tp – wted
    http://okpastors.net/__media__/js/netsoltrademark.php?d=http://cleantalkorg2.ru/?vi-gr – cxqw
    http://sodanca.ca/__media__/js/netsoltrademark.php?d=http://cleantalkorg2.ru/?ti-jj – qfiy
    http://amaregolf.com/__media__/js/netsoltrademark.php?d=http://cleantalkorg2.ru/?bo-sa – ajuk
    http://homeopathic-products.com/__media__/js/netsoltrademark.php?d=http://cleantalkorg2.ru/?fj-ws – smii
    http://fayeandrews.net/__media__/js/netsoltrademark.php?d=http://cleantalkorg2.ru/?tn-fv – esfj
    http://adauction.com/__media__/js/netsoltrademark.php?d=http://cleantalkorg2.ru/?ou-ew – xuqy
    http://ww41.rasowe.net/__media__/js/netsoltrademark.php?d=http://cleantalkorg2.ru/?kk-fx – viyi
    http://www.micasitacdc.com/__media__/js/netsoltrademark.php?d=http://cleantalkorg2.ru/?lj-fs – mdwt
    http://johnsonconcentrates.info/__media__/js/netsoltrademark.php?d=http://cleantalkorg2.ru/?rg-ov – ivuw

    http://cleantalkorg2.ru/?666 – 777
    http://lurkster.com/__media__/js/netsoltrademark.php?d=http://cleantalkorg2.ru/?np-rg – bcli
    http://www.lesnympheas-rouen.com/__media__/js/netsoltrademark.php?d=http://cleantalkorg2.ru/?rv-xy – ptrh
    http://atlantisrehab.net/__media__/js/netsoltrademark.php?d=http://cleantalkorg2.ru/?et-el – hlke
    http://beaconwashington.com/__media__/js/netsoltrademark.php?d=http://cleantalkorg2.ru/?kw-jw – qoae
    http://julieannturner.com/__media__/js/netsoltrademark.php?d=http://cleantalkorg2.ru/?fq-rt – ljeb
    http://ydkn.info/__media__/js/netsoltrademark.php?d=http://cleantalkorg2.ru/?hz-rd – caqf
    http://thinkpromotion.com/__media__/js/netsoltrademark.php?d=http://cleantalkorg2.ru/?kb-yb – scjr
    http://lifetimemagazine.info/__media__/js/netsoltrademark.php?d=http://cleantalkorg2.ru/?qt-qp – cobf
    http://rciholidayexchange.com/__media__/js/netsoltrademark.php?d=http://cleantalkorg2.ru/?xa-cp – miyp
    http://chevyracing.com/__media__/js/netsoltrademark.php?d=http://cleantalkorg2.ru/?ce-qt – hnuu
    http://medcompadmin.com/__media__/js/netsoltrademark.php?d=http://cleantalkorg2.ru/?ci-yr – egng
    onlinecialls.com – jdsw
    http://tsavin.com/__media__/js/netsoltrademark.php?d=http://cleantalkorg2.ru/?rt-oi – bzfw
    http://mamanow.com/__media__/js/netsoltrademark.php?d=http://cleantalkorg2.ru/?uj-jr – uzwq
    http://palladiumhispanicventure.com/__media__/js/netsoltrademark.php?d=http://cleantalkorg2.ru/?ex-iw – mmms
    http://www.rivascularinstitute.com/__media__/js/netsoltrademark.php?d=http://cleantalkorg2.ru/?pr-tt – axfm
    http://lootpic.com/__media__/js/netsoltrademark.php?d=http://cleantalkorg2.ru/?mz-qf – hlqt
    http://www.aero-techniques.com/__media__/js/netsoltrademark.php?d=http://cleantalkorg2.ru/?zg-cw – uged
    http://angeloak.org/__media__/js/netsoltrademark.php?d=http://cleantalkorg2.ru/?lr-tr – gzxo
    http://www.abayashopping.com/__media__/js/netsoltrademark.php?d=http://cleantalkorg2.ru/?yo-zx – qepw
    http://www.amanualofstyle.com/__media__/js/netsoltrademark.php?d=http://cleantalkorg2.ru/?ez-va – rbcl
    http://houseofnorway.com/__media__/js/netsoltrademark.php?d=http://cleantalkorg2.ru/?wc-rk – lxbd
    http://digitalfatura.com/__media__/js/netsoltrademark.php?d=http://cleantalkorg2.ru/?ii-co – hzur
    http://management-research-network.com/__media__/js/netsoltrademark.php?d=http://cleantalkorg2.ru/?go-zd – gfyv
    http://textmessage.net/__media__/js/netsoltrademark.php?d=http://cleantalkorg2.ru/?ai-by – qzod
    http://www.freemark.com/__media__/js/netsoltrademark.php?d=http://cleantalkorg2.ru/?gm-ri – wyrz
    http://reach-3mc.net/__media__/js/netsoltrademark.php?d=http://cleantalkorg2.ru/?oc-uf – yibm
    http://my-wolfpack.com/__media__/js/netsoltrademark.php?d=http://cleantalkorg2.ru/?qo-oo – qkau
    http://funtownpier.com/__media__/js/netsoltrademark.php?d=http://cleantalkorg2.ru/?wq-wq – ubfz
    http://kcsa.net/__media__/js/netsoltrademark.php?d=http://cleantalkorg2.ru/?cg-pn – brao
    http://artmarketinstitute.org/__media__/js/netsoltrademark.php?d=http://cleantalkorg2.ru/?ng-tq – tjqm
    http://www.texasparadise.com/__media__/js/netsoltrademark.php?d=http://cleantalkorg2.ru/?ga-ie – mgjq
    http://www.annyblatt-aiguillesdor.com/__media__/js/netsoltrademark.php?d=http://cleantalkorg2.ru/?cf-bv – ewlg
    http://rovimovies.com/__media__/js/netsoltrademark.php?d=http://cleantalkorg2.ru/?hv-wn – ujpi
    http://redcubecanada.com/__media__/js/netsoltrademark.php?d=http://cleantalkorg2.ru/?dw-ky – tftd
    http://www.projecttalentuk.com/__media__/js/netsoltrademark.php?d=http://cleantalkorg2.ru/?mq-br – elfv
    http://www.kitemonger.com/__media__/js/netsoltrademark.php?d=http://cleantalkorg2.ru/?rj-zs – fmtf
    http://le-chocolat.com/__media__/js/netsoltrademark.php?d=http://cleantalkorg2.ru/?zv-wr – rnuf
    http://juris-associates.com/__media__/js/netsoltrademark.php?d=http://cleantalkorg2.ru/?zy-ns – dowx
    http://mrcoats.com/__media__/js/netsoltrademark.php?d=http://cleantalkorg2.ru/?po-io – aukh
    http://cruisecashcard.com/__media__/js/netsoltrademark.php?d=http://cleantalkorg2.ru/?fi-mp – nrza
    http://lupuspodcasts.com/__media__/js/netsoltrademark.php?d=http://cleantalkorg2.ru/?hj-yd – fupq
    http://goldengate-magazine.com/__media__/js/netsoltrademark.php?d=http://cleantalkorg2.ru/?di-jq – nupj
    http://service-computing.com/__media__/js/netsoltrademark.php?d=http://cleantalkorg2.ru/?aj-sb – efql
    http://figuplast.com/__media__/js/netsoltrademark.php?d=http://cleantalkorg2.ru/?ud-uc – cyca
    http://whatshappeninatusfoodservice.com/__media__/js/netsoltrademark.php?d=http://cleantalkorg2.ru/?kx-lt – pyso
    http://wingatetampa.com/__media__/js/netsoltrademark.php?d=http://cleantalkorg2.ru/?gv-st – uvua
    http://visual.water-source.net/__media__/js/netsoltrademark.php?d=http://cleantalkorg2.ru/?iy-tf – nveh
    http://kratosinfo.com/__media__/js/netsoltrademark.php?d=http://cleantalkorg2.ru/?eu-pd – iggm
    http://fashionfirstseattle.com/__media__/js/netsoltrademark.php?d=http://cleantalkorg2.ru/?sk-oe – awpm
    http://helpingeachotherchange.com/__media__/js/netsoltrademark.php?d=http://cleantalkorg2.ru/?pc-rh – hjlk
    http://alimamaltd.biz/__media__/js/netsoltrademark.php?d=http://cleantalkorg2.ru/?cr-yu – wvbh
    http://maxexch.com/__media__/js/netsoltrademark.php?d=http://cleantalkorg2.ru/?qc-bw – wjws
    http://cyberanthro.org/__media__/js/netsoltrademark.php?d=http://cleantalkorg2.ru/?mb-nu – jpij
    http://gohastingsdownload.com/__media__/js/netsoltrademark.php?d=http://cleantalkorg2.ru/?br-yw – nrub
    http://ww4.rapidig.com/__media__/js/netsoltrademark.php?d=http://cleantalkorg2.ru/?ye-ri – uqam
    http://calidusssoftware.com/__media__/js/netsoltrademark.php?d=http://cleantalkorg2.ru/?bv-vs – rpmz
    http://hallmarkhardwoodfloors.com/__media__/js/netsoltrademark.php?d=http://cleantalkorg2.ru/?gn-nv – kjtt
    http://mexican-autoinsurance.org/__media__/js/netsoltrademark.php?d=http://cleantalkorg2.ru/?za-pe – kqhp
    http://pretapapier.com/__media__/js/netsoltrademark.php?d=http://cleantalkorg2.ru/?qq-id – tslj
    http://golden-theater.net/__media__/js/netsoltrademark.php?d=http://cleantalkorg2.ru/?xq-xi – cyys
    http://especiallyforchocolatelovers.com/__media__/js/netsoltrademark.php?d=http://cleantalkorg2.ru/?nw-qf – smkq
    http://camillegoldsborough.com/__media__/js/netsoltrademark.php?d=http://cleantalkorg2.ru/?kl-dk – evpp
    http://ww35.gocadd.com/__media__/js/netsoltrademark.php?d=http://cleantalkorg2.ru/?an-hh – ztnx
    http://ww41.purple-days.com/__media__/js/netsoltrademark.php?d=http://cleantalkorg2.ru/?ea-vt – uafd
    http://peskycritters.biz/__media__/js/netsoltrademark.php?d=http://cleantalkorg2.ru/?xn-yr – tkno
    http://specificationwriter.net/__media__/js/netsoltrademark.php?d=http://cleantalkorg2.ru/?ve-pv – kkoq
    http://fun-on.com/__media__/js/netsoltrademark.php?d=http://cleantalkorg2.ru/?zs-wq – onbt
    http://lacountyplasticsurgeon.com/__media__/js/netsoltrademark.php?d=http://cleantalkorg2.ru/?nk-pc – sdns
    http://axiomfinancial.net/__media__/js/netsoltrademark.php?d=http://cleantalkorg2.ru/?ci-lq – tuap

    http://noseyassesofpottsville.com/chat/showthread.php?tid=97628 – 344252
    http://jackalclan.ru/forum/viewtopic.php?f=3&t=40824 – 19375149
    http://dinai.com/forum/viewtopic.php?f=4&t=169632 – 81409660
    http://club-ktm.ru/forum_/viewtopic.php?f=36&t=91236 – 7145894
    http://www.grimuar.pl/forum/viewtopic.php?f=16&t=6234 – 13218085
    http://etland.y0.pl/showthread.php?tid=7941 – 15347934
    http://lendirabg.com/showthread.php?414355-12810-742792&p=1943766#post1943766 – 3079448
    http://cryptonews.keyforum.ru/viewtopic.php?f=28&t=5469 – 18817642

    http://dzintars-kiev.com.ua/forum/viewtopic.php?f=2&t=1051404 – 50641426
    http://forum.dottnet.it/showthread.php?tid=1053&pid=635323#pid635323 – 37976337
    http://forum.dottnet.it/showthread.php?tid=8907 – 99835792
    http://winatlosingweight.com/forum/viewtopic.php?pid=377907#p377907 – 5669584
    http://www.novaufo.net/forum/showthread.php?tid=37589 – 96467687
    http://giocarecasino.altervista.org/showthread.php?tid=47453 – 14684723
    http://forum.dottnet.it/showthread.php?tid=1053&pid=635324#pid635324 – 43538124
    http://www.msr2droids.com/forum/viewtopic.php?f=8&t=355451 – 6827333

    http://zbiorowisko.online/showthread.php?tid=32453&pid=208443#pid208443 – 22262863
    http://www.egologic.eu/nfsw/showthread.php?tid=168322 – 4835978
    http://nnfgaming.com.br/forum/index.php?topic=3808.new#new – 88417179
    http://www.novaufo.net/forum/showthread.php?tid=37590 – 78912062
    http://traviet.net/Thread-1056533584 – 2377839
    http://www.forum.jatimdevcenter.com/showthread.php?tid=4397&pid=7944#pid7944 – 1163870
    http://traviet.net/Thread-5438448603 – 6873655
    http://forum.lite-money.ru/viewtopic.php?pid=177857#p177857 – 8521862

    http://hugeplr.com/product/2500-mrr-plr-ebooks-collection-on-various-topics/?unapproved=3194&moderation-hash=f977e83a8edb15b51653b92db8ff496c#comment-3194 – 2738128
    http://www.poznanie.com.ua/forum/forum4/topic284319/message1231614/?sessid=c8697736f446326d8bf092773a1d37f9&TOPIC_SUBSCRIBE=Y&result=new – 29882774
    http://lisboaforum.com/showthread.php?tid=194167&pid=373494#pid373494 – 44242372
    http://dzintars-kiev.com.ua/forum/viewtopic.php?f=2&t=1051407 – 51513438
    http://www.iptv-one.net/viewtopic.php?f=31&t=38777 – 9410768
    http://www.antropocrazia.com/forum/viewtopic.php?p=352077#352077 – 30921469
    http://www.antropocrazia.com/forum/viewtopic.php?p=352078#352078 – 17829061
    http://mercadoforo.com/showthread.php?tid=6803 – 75394029

    http://myesl.ca/forum/viewtopic.php?f=3&t=706890 – 934745
    http://klingentaenzer.seelenfeder.at/viewtopic.php?f=4&t=26873 – 6542596
    http://armtorent.ru/viewtopic.php?f=17&t=29496 – 44516230
    http://uselessrecords.com/forum/index.php?topic=425832.new#new – 47677066
    http://q10.hu/forum/Thread-266835-886127 – 22209575
    http://uselessrecords.com/forum/index.php?topic=425834.new#new – 204689
    http://sciezkiprzeznaczenia.c0.pl/showthread.php?tid=28909 – 95679368
    http://www.msr2droids.com/forum/viewtopic.php?f=8&t=355452 – 27998476

    Reply

Leave a Reply

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