Export Clients to csv

Hi is there an option to export clients to a csv ?
if i copy to clipboard data i get only the table visible columns (not VAT number or any custom field we have added)

No.

you seem to be copying the list then.
click on Batch Update and then Copy to Clipboard.

Edit your custom field and check this box:

This will make the fields show on the table and when copying to clipboard.