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
.