Advice on setting up private site
I think the best way is just to create accounts for every people from spreadsheet. You can use code provided here but generating random passwords instead and sending a mail to each registered user with their information and alerting them to change their passwords on first login.