If you cannot open an Excel file and see Excel cannot open the file because the file format or extension is not valid error, see this post.

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.