Where Excel stores files it hasn't saved yet

If you closed Excel without saving, the file is not completely gone. Excel keeps temporary copies of unsaved work in a recovery folder on your computer. The location depends on whether you're using Windows or Mac, and which version of Excel you have.

On Windows with Excel 2016 or later, look in C:\Users\[Your Username]\AppData\Local\Microsoft\Office\UnsavedFiles. On Mac, the folder is in ~/Library/Containers/com.microsoft.Excel/Data/Library/process Support/Microsoft/Office/UnsavedFiles. These folders are hidden by default, so you may need to show hidden files first.

Excel also creates backup files with the extension .xlk in the same folder where you normally save your spreadsheets. These are not the same as recovery files, but they can sometimes contain recent versions of your work.

Key Takeaways

  • Excel stores unsaved files in a hidden recovery folder that you can access through your file explorer or through Excel's built-in recovery tool.
  • The fastest way to recover an unsaved file is to open Excel and go to File > Info > Manage Versions (or Open & Repair on older versions) rather than hunting for folders manually.
  • If you closed Excel more than a few days ago, the temporary file may have been deleted, but it's worth checking the recovery folder before assuming it's gone.
  • Backup files with .xlk extensions appear in your normal save location and can be opened directly like any other spreadsheet file.

Using Excel's built-in recovery tool

The easiest method is to let Excel find the file for you. Open Excel and click File in the top left. Then click Info. Look for a button labeled Manage Versions (in newer versions) or Open & Repair (in older versions). Click it, and Excel will show you a list of unsaved files it has recovered.

Select the file you want and click Open. Excel will open the recovered version. You can then save it with a new name or overwrite the original if you want to keep the recovered version. This method works even if you don't remember exactly when you closed the file or what folder it was in.

If you don't see a Manage Versions or Open & Repair button, your version of Excel may not have this feature. In that case, you'll need to navigate to the recovery folder manually using the steps below.

Finding the recovery folder on Windows

Open File Explorer and paste this path into the address bar: C:\Users\[Your Username]\AppData\Local\Microsoft\Office\UnsavedFiles. Replace [Your Username] with your actual Windows username. Press Enter.

If the folder appears empty or doesn't exist, you may need to show hidden files first. In File Explorer, click the View tab at the top. Check the box next to Hidden items. Now try the path again.

Look for files with names like "Book1" or "Sheet1" and a .xlsx or .xls extension. These are your unsaved spreadsheets. You can open them by double-clicking, or right-click and choose Open with to select Excel specifically. Once opened, save the file to a location you'll remember.

Finding the recovery folder on Mac

Open Finder and press Command + Shift + G to open the "Go to Folder" dialog. Paste this path: ~/Library/Containers/com.microsoft.Excel/Data/Library/process Support/Microsoft/Office/UnsavedFiles. Press Enter.

If the path doesn't work, your version of Excel may store recovery files in a different location. Try this alternative: ~/Library/process Support/Microsoft/Office/UnsavedFiles. If neither path exists, the recovery folder may not have been created yet, which usually means Excel didn't save a temporary copy.

Files in this folder will have generic names like "Book1" or "Sheet1". Open them in Excel and check the content to make sure you have the right file. Save it to your Documents folder or another location where you keep your spreadsheets.

Checking for backup files with .xlk extension

Excel can create automatic backup files if you turn on the backup feature in settings. These files have the extension .xlk and appear in the same folder where you normally save your spreadsheets. They are not recovery files — they are intentional backups created at regular intervals while you work.

To find them, open File Explorer or Finder and navigate to the folder where you usually save Excel files. Look for any files ending in .xlk. The filename will be similar to your original spreadsheet but with .xlk instead of .xlsx or .xls.

Double-click a .xlk file to open it in Excel. If it contains the version you want, save it as a regular .xlsx or .xls file so you don't lose it again. Note that .xlk files are only created if you have backup enabled in Excel settings, so you may not have one.

What to do if the file is not in the recovery folder

If you don't find your file in the recovery folder, it may have been deleted when you emptied your Recycle Bin or Trash, or it may have expired. Excel typically keeps unsaved files for a limited time — usually a few days to a week, depending on your system settings.

Check your Recycle Bin (Windows) or Trash (Mac) to see if the file is still there. If it is, right-click it and choose Restore to put it back in its original location. If the Recycle Bin or Trash is empty, the file is likely unrecoverable.

If you remember roughly when you created the file, you can also search your entire computer for files with that name. On Windows, use the search box in File Explorer. On Mac, use Spotlight (Command + Space) and type the filename. This may find older versions or backup copies you forgot about.

How to prevent losing unsaved work in the future

Turn on AutoSave in Excel to save your work automatically as you type. In newer versions, click File > Options (Windows) or Excel > Preferences (Mac). Look for Save settings and enable AutoSave. You can set it to save every few minutes.

If you use OneDrive or SharePoint, AutoSave is usually on by default when you open files from those locations. You can also enable AutoRecover, which saves a temporary copy of your file at regular intervals. This is different from AutoSave but provides a safety net if Excel crashes.

Another straightforward habit: use Ctrl + S (Windows) or Command + S (Mac) frequently while you work. Saving takes only a second and ensures you never lose more than a few minutes of work.

Frequently Asked Questions

Can I recover a file if I force-quit Excel without saving?

Yes, in most cases. Excel creates recovery files even when it closes unexpectedly. Check the recovery folder or use the Manage Versions tool in Excel. If you force-quit very recently, the recovery file should still be there. The longer you wait, the more likely it is that the temporary file has been deleted by your system.

What's the difference between a recovery file and a backup file?

A recovery file is a temporary copy Excel creates automatically while you work, even if you never save. A backup file (.xlk) is only created if you turn on the backup feature in Excel settings. Recovery files are stored in a hidden system folder. Backup files appear in the same folder as your spreadsheet.

If I find the file in the recovery folder, will opening it overwrite my saved version?

No. When you open a recovery file, you can save it with a new name or in a different location. You control where it goes. If you want to replace your original file, you can do that, but Excel won't do it automatically.

How long does Excel keep unsaved files in the recovery folder?

This varies by system and settings. Most computers keep recovery files for several days to a week. If you haven't opened Excel in a while, older recovery files may have been deleted. Check as soon as you realize the file is missing — the sooner you look, the better your chances of finding it.

Can I recover a file if I never saved it even once?

Yes. Excel creates recovery files for unsaved work, so you don't need to have saved the file previously. As long as you had the spreadsheet open in Excel when it closed, there should be a recovery copy. The only exception is if Excel crashed before it could create a temporary file, which is rare.