Password Encryption Question

I'm trying to do a mass import of users into a joomla db using CB. The spreadsheet I have with all of the user information on it has default passwords for each user. How can I recreate the encrypting of the password field that is done whenever a new user is created?

I see there is a $secret variable in configuration.php which I'm assuming is the salt used to hash passwords, but even using it I still can't figure out the crypt command to give me the same hash that's being stored in the db for the same password.


Thanks,
Will P.

For importing users I recommend using CB Juice which allows import of users through CSV file. It will automatically encrypt the passwords for you on import.