How do I export all of my customers (not users) from Drupal into a CSV file? I'm working on integrating a new accounting system and crm (Xero &amp; Capsule) for a client - and they have just under 10,000 clients - only stored in their Drupal website. I need to export these with all their details (e mail, full name, address etc) - into a csv or excel file.

Currently under Store Administration I can "View Customers" - but this gives me no option to export.

But under Reports > Customer Reports it gives me the option to export each page to a csv - however the information is not what we need - it only gives me usernames.

Any suggestions?
With the https://www.drupal.org/project/views_data_export module you can create views and export to CSV, Excel, XML, etc.

It also supports exporting in batches (default activated if the views has 1 000 or more rows). So 10 000 clients shouldn't be a problem.