I have new installation of a phpBB3 board, and want to add around 350 users from a spreadsheet.
In the spreadsheet I have the following fields:
1. E-mail address (which will also be the username)
2. Unencrypted password
The e-mail address/username (1) and password (2) goes into the core user fields.
The name (3) and district (4) are custom profile fields (made under Admin > Users and groups > Custom profile fields), where name is their names and district is one of 26 different regions where they come from. In phpBB I at first made it a drop down list, but it also works as a ordinary text field if that would be easier to make technically.
Names etc are sometimes in Swedish, so other letters than a-z can occur and need to be shown correctly.