Upload user name and roles in CSV to give access to private area

We have a requirement where we need to give a list of users(about 1000) access to a private area. Many of these users are not regular forum users, so they will need to be processed in a way that allo...