Change WordPress user roles and capabilities › Forums › How to or FAQ › Export user names and emails list? › Reply To: Export user names and emails list?
08/03/2017 at 13:58
#3414
Keymaster
Hi,
User Role Editor exports just a user roles with capabilities. It’s a serialized PHP array additionally encoded.
You can use PhpMyAdmin to export needed data. Use this command at SQL tab:
SELECT user_login, user_email FROM wp_users
replace ‘wp_’ with your own database prefix, if needed.
Then click ‘Export’. Select an option “CSV for MS Excel” and that’s it. You will get a file with data formatted this way:
"user1";"[email protected]"
"user2";"[email protected]"