How do I export my iCloud contacts to a csv file

This does not seem to be working. The contacts won’t drag from Contacts app.

If your contacts are synced with your Mac, open the Contacts app and also open a blank Numbers spreadsheet. You can then select all (or some) contacts and drag them from the Contacts app to the Numbers spreadsheet.

You can then use File menu > Export to export to an Excel or civ format.

Note that this only works via Numbers (you can't drag directly to an Excel spreadsheet).