I am having issues with the batch create multi user

I am having issues with the batch create multi user addition function. Everything seems to be working for the most part except for the user role. It defaults to none and i have tried changing it in the .xls and .csv file but nothing seems to be working. Perhaps i am missing something really obvious but if i could get some help that would be great.

Thanks