2
Besides to export the users table `xoops_users` and clean it up, you can copy your members (use find user) and paste special (as text) at Excel.
Unfortunatelly, if you have a lot of members, you have to do it: [Nr. of members / Nr. of members per page] times! This way you get less data but it is faster.