Copy the required unsaved Excel file to another location.Change the file extension from “.tmp” to “.xlsx ... Excel files using File History: Open the folder where your unsaved Excel ...

If corruption occurs after you open the file, you can use that file. The file is usually saved in the same folder or temporary folder with the same file name and ending with “TMP.” Locate the ...

Click on the Hyperlink. A Microsoft Excel Security Notice dialog box will appear, asking permission to open the hyperlink to the existing file. Click Yes. A window will open with the existing file.

That shouldn't be a problem, after all, Excel can handle JSON. So, you try to open the file in Excel using its data import tooling, which usually works very well indeed as a basic ETL system.