When you are working on an important spreadsheet in Microsoft Excel, the last thing on your mind should be the physical location of your backup data. However, understanding where Excel stores its autosave files is crucial for recovery after a crash, accidental deletion, or simply to audit your recent changes. Modern versions of Excel handle this process automatically, but the files are hidden within system folders, making them difficult to find without knowing the specific path. This guide breaks down exactly where these temporary recovery points live on both Windows and Mac operating systems.
How Excel Autosave Actually Works
Unlike the manual "Save" action, Excel's autosave feature operates in the background at set intervals, usually every 10 minutes. It does not overwrite the original file on your desktop or in your Documents folder immediately; instead, it creates a temporary snapshot stored in a dedicated cache. This snapshot is a temporary binary file that retains the state of your workbook at that specific moment. If Excel closes unexpectedly, the software can usually detect these temporary files the next time you launch the program and offer to recover your work. You do not need to navigate to these folders under normal circumstances, but knowing they exist is the first step in troubleshooting data loss.
Locating Files on Windows 10 and 11
On Windows, the temporary autosave data is not stored in a single easy-to-reach location. Instead, it is buried deep within the user profile directory, specifically inside the AppData folder. This folder is hidden by default because system files are often accidentally moved or deleted by users, which could cause system instability. To view these files, you must enable the option to show hidden items in File Explorer. The path is consistent across recent versions of Windows, following a structure that ties the recovery data directly to your user account and the specific version of Office you are using.
The Exact File Path
To manually locate your autosave files on a Windows machine, you need to access the following directory. Keep in mind that "Username" should be replaced with the actual name of the account you are currently logged into.
C:\Users\Username\AppData\Local\Microsoft\Office\UnsavedFiles
Navigate to this folder, and you will find files with generic names like "Book1" or "Sheet1" alongside long strings of random characters. These files do not have the standard .xlsx extension, which is why they cannot be opened directly by double-clicking. They are locked by the Excel process and are only meant to be accessed through the recovery pane that Excel presents when it detects a problem.
Locating Files on macOS
The process on macOS is similar in concept but different in execution due to the Unix-based structure of the operating system. Excel for Mac stores temporary data within the user's Library folder. Unlike the Windows AppData folder, the Library folder on Mac is hidden by default to prevent inexperienced users from altering system files. You will need to unhide this folder or use the "Go to Folder" command in Finder to access the precise location where Excel keeps its recovery data.
The Exact File Path
Open Finder and use the Go to Folder function (Shift+Command+G) and paste the following path, replacing "Username" with your account name:
/Users/Username/Library/Containers/com.microsoft.Excel/Data/Library/Preferences/AutoRecovery
Alternatively, if the above path does not yield results due to updates in macOS or Office, you can check the system-wide temporary folder:
/var/folders/ (Look for a folder with a random string, then navigate through /tmp/ or /var/fractions/)
Files found here will also be locked and temporary, visible only to Excel during the recovery process.
