To fix the Excel file format does not match extension error, trying opening the spreadsheet with the Open and Repair option or changing its file extension.

How to Recover a Microsoft Excel File That Is Not in a Recognizable Format. If Microsoft Excel fails to recognize a file in the XLSX or XLS format, the data contained in the file could be corrupted.