Is there a way to export contacts to an excel sheet

You can open the Contacts app on your Mac and open the Numbers app, then select all (or any) contacts and drag them from the Contacts window to the Numbers blank spreadsheet. Then use the Numbers File menu to export the spreadsheet to Excel format.

That only works if you use Numbers, not directly to Excel without using Numbers.

What part didn't work? I just tried and it still works as described.

You can use Automator to create a Tab-delimited file. Excel should be able to import tab-delimited, but you could then use a text editor to change the tabs to commas. Only issue is if any of the fields have commas in them. You would have to enclose those field fully in double-quotes.

1. Start a new Workflow.
2. Drag in a Get Selected Contacts Item action -- set it to people.
3. Drag in a Get Contact information action -- set it to "Spreadsheet (tabs)" -- select the information to extract.
4. Drag in a New TextEdit Document action.

In Contacts select all people in the group to export.

Go back to Automator and run the workflow.

A TextEdit document will open with the data delimited by tabs. Replace the tabs with commas, or do it in Excel in their text import tool.

https://www.aconvert.com/document/vcf-to-csv/

Apple's contacts when you select multiple contacts to export creates a VCF file, which you can use the above link to convert to CSV.

Then open in Excel to see for yourself how successful it was. Some contacts with custom fields may create some layout issues in the export.

You can export (File menu) from Numbers to Excel or to a CSV which will open in Excel.