how to open and edit an excel file?

Depending on the applications that you have installed, it should open in Excel, Numbers, or LibreOffice. Double clicking on the file should open it. Another option is to first run one of the above apps and then use their File menu > Open.

For maximum compatibility -- Microsoft Office for Mac: Office 365 for Mac, Office 2016 for Mac

For very good compatibility and free: https://www.libreoffice.org/

Also free: Apple's Numbers

Use Excel, Numbers, LibreOffice, or similar programs.

(157945)