Well if you are adventurous you could use something like https://codewalkers.com/seecode/585.html. That php script, csv2sql.php, will generate the SQL INSERT statements that you could copy and paste into the SQL query box in phpMyAdmin.
To do this you should be familiar with the WordPress database structure, in particular, the “wp_users” and “wp_usermeta” tables.
With the sample data below, I was able to generate the correct INSERT statements. I did have to change the two “explode” statements csv2sql.php, lines 39 and 61, to use “|” instead of “,” for the field separators due to the “wp_capabilities” row in “wp_usermeta”. I played with the password field and ended up using “password” and expect your users will need to have a new password sent to them. Note that if your database prefix is different that “wp_” you need to reflect that in the “wp_usermeta” rows “wp_capabilities” and “wp_user_level”. You will want to insure each “ID” and “user_login” is unique.
Sample data used:
ID|user_login|user_pass|user_nicename|user_email|user_url|user_registered|user_activation_key|user_status|display_name
3|peter|password|peter|[email protected]|https://|2005-12-10 12:19:12||0|peter
umeta_id|user_id|meta_key|meta_value
20|3|first_name|peter
21|3|last_name|jones
22|3|wp_capabilities|a:1:{s:10:”subscriber”;b:1;}
23|3|wp_user_level|0
