Navigation

3 Simplest Ways to Recover Excel Temp Files from Windows 10/8/8.1/7/XP Easily

"I opened an excel file from my email, and then made some changes, but my computer suddenly power off, can I get back my edited excel file? Please help."

Microsoft has realized such demands and introduced temporary files for Excel. It will save your changes in Excel temp files regularly.

In another word, finding the Excel temp files, you can get back your data if the excel file is not save in time due to sudden interruptions.

In this tutorial, we are going to tell you where are temporary excel files stored on Windows 10/8/8.1/7/XP and Mac OS X and how to recover your data through temp files.

Excel Ttemp Files

Part 1: Where are temporary excel files stored

When you create a new Excel file or start editing it, Windows will produce a temp file as well. And the temp file stays on your computer until you click on the Save button.

But it may be stored in different locations depending on where the Excel file saved and which version of Windows you are using.

For example, the Excel temp file is stored in:

Windows 10: C:\Users\AppData\Local\Microsoft\Office\UnsavedFiles.

Windows 7 or XP: The directory is C:\Documents and Settings\ \Application Data\Microsoft. If the Excel file is on a network drive, the temp file is created there.

Bear in mind that the name of the temp file does not look like a normal file, usually containing squiggly line or other symbols and end with TMP.

You will also like: Recover unsaved Excel file.

Unsaved Files

Part 2: Regular way to recover excel temp files

When you encountered sudden interruptions, like Excel file corrupted, Excel file not responding, etc. you can get back your excel Windows 10/8/7/XP through temp files. But you may discover that it is infeasible to open the temp file directly. Follow the methods below to recover excel temp files quickly.

Method 1: Recover Excel temp files by changing extension

Step 1: Go to where temporary excel files stored according to your situations, highlight it, press "Ctrl + C", navigate to another location, press "Ctrl + V" to paste the temp file there.

Step 2: Locate to the top ribbon, go to the View tab and check the box of "File name extensions". After that you can right-click on the Excel temp file to change the file extension to xlsx or xls.

Step 3: Now, you can open excel temporary file as a real workbook.

Save As Excel

Method 2: Open temp files in Excel

Though you cannot open excel temp file directly, it does not mean Excel program is not able to load it.

Step 1: Run Excel program from your desktop, go to "File" > "Info".

Step 2: Click on the "Manage Versions" and select "Recover Unsaved Workbooks".

Step 3: On the popup dialog, navigate to where temp files stored and open it in Excel program. Now, you can save your data as a normal excel file.

Open Temp File

Part 3: Best method to restore excel temporary files

If your excel file is corrupted or damaged, we suggest you to try a professional data recovery tool, such as Apeaksoft Data Recovery.

Step 1: Scan entire drive to look for data

Download Data Recovery and install it on your PC. If your excel file stored on an external drive originally, connect it to your computer. Launch the best Excel temp file recovery software.

Go to the data type section on the home interface, and tick the checkbox on the "Document" option. Then go to the location area and select where are temporary excel files stored. Once click on the "Scan" button, Data Recovery will work automatically.

Scan Data

Step 2: Preview Excel files before recovery

After quick scanning, you will be brought to the result window. Go to the Document tab from left hand column, you will be presented several folders titled XLSX, XLS, DOC, PDF, etc.

Click the folders related to Excel file formats, like XLSX and preview files. Plus, the "Filter" feature at top ribbon could help you to find the Excel file that you want to recover quickly.

Preview

If you cannot find the desired file, click on the "Deep Scan" button at upper right corner. It will take more time to scan the drive deeply and find more recoverable data.

Step 3: Recover excel temporary files in one click

To restore lost data, you can check the box in front of each desired excel file or select entire folder.

Click on the "Recover" button to start restoring excel files. When it is done, you can browse, copy and paste, or edit your data as usual.

Unformat

The steps to recover temp Excel file on Windows are slightly different from on Mac. Check here to recover recover deleted files on Mac.

Data Recovery

Data Recovery is the easiest Excel temp file recovery tool, which can recover .xls, and .xlsx in Excel 2000, 2003, 2007, 2010, 2016, etc. on Windows 10/8/7 and Mac, whether your Excel temp file is lost or deleted due to mistake operation, virus attack, software corrupt, or sudden power off.

Conclusion

Excel is one of the most useful programs on Windows. People use it to save and visualize oceans of data, from financial to sales. But many users have encountered the problem that close the workbook without saving. Fortunately, excel temp files save your data and changes waiting for recovery. We have shared how to find and use Excel temp files in this tutorial. In another world, even if you do not enable the automatic save feature, it is possible to recover data from temporary files that created by Office and Windows.

We wish that our guides and suggestions are helpful. If you have more questions related to excel temp files, please leave a message below.

More Reading