Make use of the plugin: WP Users Exporter

By default it only export basic information about the users. If you need address information, you have to configure it in the settings.

The output can be either CSV or XLS.

Suggestion:

• use XLS for cleaning up, then export to CSV.
• The order of the fields can be adjusted in the settings as well.

CSV format Magento needs:

# header #

website,_website,firstname,lastname,email,billing_firstname,billing_lastname,billing_company,billing_postcode,billing_city,billing_street1,billing_telephone,billing_country,shipping_firstname,shipping_lastname,shipping_company,shipping_postcode,shipping_city,shipping_street1,shipping_telephone,shipping_country,group, group_id,taxvat

# sample contents #

"base","base",foxy,star,a@a.eu,bfoxy,bstar,"company co",1111HL,city,billing_street,12345,NL,shipping_fistname,sstar,"company co",2222HL,"Den Haag","sstreet 1",54321,NL,General,1,KvK

If yo need only basic login information of the customer, you can make use of system → import/export → import → customers

go to system → import/export → dataflow profiles → add new profile.

• Take the default values,
• make sure direction is import
• and entity type is customers
• Data format type should be CSV
• Original Magento attribute names in first row should be yes

The go to your newly made profile

• upload your csv by using the upload tab (you can upload 3, but 1 is enough )
• save and continue to save the progress
• go to run profile tab,
• pick the profile you just uploaded and run!