Create Users and Add to specified roles from CSV file using Sitecore PowerShell Extensions

CreateUsers.ps1

$VerbosePreference = "Continue"

$newUsersFile = Receive-File -Path "C:\temp\upload" -CancelButtonName "No, I will do it using MS Excel instead"
$newUsers = Import-Csv -Path $newUsersFile

foreach($user in $newUsers) {
    Write-Verbose "Creating User: $($user.Username)"
    New-User -Identity $($user.Username) -Enabled -Password $($user.Password) -Email $($user.Email) -FullName "$($user.Name)"
    
    $($user.Roles).Split(",")  | ForEach {
        Write-Verbose "Adding user to role: $_ "
        Add-RoleMember -Identity $_ -Members "$($user.Username)"
    }
}

NewUsersTest.csv