If you enabled File History (it's disabled by default), all you have to do is use it to recover the file. File History saves the state of the included folders at a specific time.

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.