Import Users from Excel (CSV) to SharePoint using PowerShell

Requirement: Got bunch of users and want to add them in to SharePoint? To bulk add users to SharePoint group programmatically using PowerShell, use the below script. This script Imports list of users from Excel .CSV file to SharePoint and adds them into appropriate groups.

Solution: Lets import users from Excel to SharePoint using PowerShell. Here is my CSV file with list of users and their target groups in SharePoint:
sharepoint import users from excel csv

PowerShell script to Import users from CSV to SharePoint 2013:
Add-PSSnapin Microsoft.SharePoint.PowerShell –erroraction SilentlyContinue

$UserListCSV = "C:\UsersToImport.csv"
$SiteURL =""

# Import the CSV file
$UserList = Import-CSV $UserListCSV #-header("GroupName","UserAccount") - If CSV doesn't has headers

#Get the Web
$Web = Get-SPWeb $SiteURL

#Iterate through each user from CSV file
foreach ($user in $UserList)
    #Get the Group and User
    $Group = $web.SiteGroups[$User.GroupName]
    $User = $web.Site.RootWeb.EnsureUser($User.UserAccount)
    #Add user to Group

    Write-Host "$($User) Added Successfully!" -ForegroundColor Green

#Dispose web object

Import Bulk Users to SharePoint site from CSV file using PowerShell:
My another CSV file has AccountName (in the format of: Domain\UserName and GroupName). 
add user to group powershell sharepoint 2010
PowerShell script to add user to SharePoint group:
Let's add a bit of error handling this time.
Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue

#Import the List of Users from a .csv file,
$UserList= Import-CSV "C:\UserList.csv"
#Get the Web
$web = Get-SPWeb ""
foreach ($Row in $UserList)
  #Get the Group
   $Group = $web.Groups[$Row.GroupName]
 #Validate the user name
        $user = $web.Site.RootWeb.EnsureUser($Row.AccountName)
   catch [system.exception]
     write-host $_.Exception.Message
   #Add user if valid user name is provided
    if($user -ne $null)
       write-host $user.AccountName

#Dispose the web object


  1. I’m trying to do something similar to your post above. I have a spreadsheet that contain a column of user name and another column called About Me. I’m trying to figure out how to import the column called About Me into users profiles on Sharepoint using Power Shell but I have yet to figure it out. Any help would be greatly appreciated

  2. Hello, I'm newbie on this, todo this can I run the PS script on the client side or I have to run that scrip on the Sharepoint server?


Please Login and comment to get your questions answered!

Powered by Blogger.