powershell: Export and import SharePoint Group to Excel using PowerShell

Export SharePoint Group to Excel using PowerShell

Export all groups and Names
add-pssnapin microsoft.sharepoint.powershell
#get the site object
$site = Get-SPSite "http://alenaldev.tawazun.ae/"
#get the group collection details
$groups = $site.RootWeb.sitegroups
#output variable is been used for storing the group details.
$Output = @("GroupName")
#loop thru the groups object and get the individual group details.
foreach ($grp in $groups)
{
Write-Host "Group: " $grp.name;
   foreach ($user in $grp.users) {
   Write-Host "user:" $user.Name

$Output += ($grp.Name+"|"+$user.Name+"|"+$user.UserLogin+"|"+$user.Email)
}
}
$site.Dispose()
#finally export the group names to the .csv file
$Output > "C:\ ExportGroups.csv"

-----------------------------------------------------

$siteUrl="SiteURLHere"
$groupName="GroupNametoExport"
$Output = @("GroupName|Name|Login|Email|Department|Title")
$web = Get-SPWeb $siteUrl
$site = $web.Site
$rootWeb = $site.RootWeb
$UserList = $rootWeb.Lists["User Information List"]
$web.SiteGroups[$groupName].Users|%{$user = $UserList.GetItemById($_.ID)
if($user -ne $null)
{
$JobTitle = $user["JobTitle"]
$Department = $user["Department"]
}
$Output += ($groupName+"|"+$_.Name+"|"+$_.UserLogin+"|"+$_.Email+"|"+$ Department +"|"+$JobTitle)
}
$rootWeb.Dispose()
$web.Dispose()
$site.Dispose()
$Output > "D:\MembersExport.csv"

Import Users from Excel to SharePoint using PowerShell






# Import the .csv file, and specify manually the headers, without column name in the file 
$userList=IMPORT-CSV C:\UserToUpload.csv -header("GroupName","UserName")

#Get the site name to the variable
$web = Get-SPWeb SiteURLHere

foreach ($user in $userList)
{
$groupName = $web.SiteGroups[$userList.group]
$user = $web.Site.RootWeb.EnsureUser($userList.user)
$groupName.AddUser($user)
}
Write-Host -ForegroundColor green "Users Added Successfully"
}
$Web.Dispose()

REF:

http://sharepoint-works.blogspot.in/2013/01/import-users-from-excel-to-sharepoint.html#.UO1bvnfSKBw