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]"
