Where Do Excel Recovery Files Go: Locations and Tips
Learn where Excel recovery files go on Windows and Mac, how AutoRecover works, and steps to retrieve unsaved workbooks. Practical guidance from XLS Library to protect your data.
Excel recovery files are typically saved in the user profile areas of Windows and macOS when AutoRecover is enabled. On Windows, look in C:\Users\<YourName>\AppData\Roaming\Microsoft\Excel and C:\Users\<YourName>\AppData\Local\Microsoft\Office\UnsavedFiles for temporary backups. On macOS, check the Office AutoRecovery folder inside the Library. Enabling AutoRecover and setting a frequent save interval helps minimize data loss.
Why Excel Recovery File Locations Matter
Understanding where Excel stores recovery drafts and temporary backups is essential for quick data retrieval after a crash or unexpected shutdown. The XLS Library team emphasizes that knowing the exact paths reduces search time and increases the odds of recovering unsaved work. By aligning your save interval and recovery locations with your operating system, you create a reliable fallback that keeps you productive. This knowledge also helps when collaborating across devices, ensuring that you can locate drafts no matter which machine you used last.
How AutoRecover Works Across Windows and macOS
Excel AutoRecover is designed to periodically snapshot your open workbooks so you can recover them after a crash. On Windows, AutoRecover drafts typically land in user profile folders, while macOS stores similar drafts in a dedicated Office AutoRecovery directory. The exact filename conventions can vary by version, but the underlying principle remains: if Excel crashes or the app quits unexpectedly, there’s a recent draft waiting to be recovered when you reopen Excel and use the recovery prompts. To maximize effectiveness, ensure AutoRecover is enabled and choose a reasonable interval.
Windows: Common Recovery Paths and Access Methods
In Windows, the two primary locations you should check are the roaming profile and the local office backups. The roaming path often holds repository-style recovery files, while the local path houses unsaved copies that may be shorter-lived. Accessing these folders can be done via File Explorer or by using the Run dialog (press Win+R and paste the path). If you don’t see a file you expect, you may need to enable the Recover Unsaved Workbooks feature in Excel, or use the automatic prompts that appear on startup after a crash. Keep in mind that corporate policies or antivirus software can sometimes hide or delete temporary recovery files.
macOS: Office AutoRecovery and How to Find It
Mac users find recovery drafts in Office AutoRecovery, typically under the Library area of the user home directory. The exact path can differ by macOS version and Office build, but a common starting point is a hidden Library directory followed by a path resembling Library/Application Support/Microsoft/Office AutoRecovery. If you don’t see drafts immediately, use Finder’s Go to Folder option and search for 'Office AutoRecovery' from your home directory. Regularly closing documents and using Save As can reduce reliance on recovery files on Mac systems.
Accessing Recovered Workbooks: Step-by-Step in Excel
When Excel shows a Document Recovery pane after a crash, start by saving any drafts to a known location. If the pane is not presented, you can still locate recovery copies via Excel: go to File > Open > Recent > Recover Unsaved Workbooks. This path is your safety net for unsaved changes and can restore most of your recent work. For some versions, Windows users may also find recovery files by navigating to the standard AppData paths described above. Mac users should rely on Office AutoRecovery folders and version histories as a secondary strategy.
Practical Tips to Minimize Data Loss Going Forward
- Turn on AutoRecover and set a frequent interval that fits your workflow (e.g., every 5-10 minutes).
- Save manually often and use cloud storage with version history for critical projects.
- Close workbooks properly to ensure clean saves and to trigger AutoRecover dumps when appropriate.
- If a crash occurs, don’t immediately overwrite recovery drafts; compare with your latest saved copy to avoid duplicate or outdated drafts.
Troubleshooting: When Recovery Files Aren't Visible
If you can’t locate recovery files, start with the Recover Unsaved Workbooks tool in Excel, then check both roaming and local profiles for Windows. On Mac, verify the Office AutoRecovery folder and ensure there are no user permission blocks. If a crash happens frequently, consider increasing your save cadence and enabling AutoSave for cloud-powered documents to reduce dependency on local recovery files.
Typical recovery locations by platform
| OS/Platform | Common Recovery Path | Notes |
|---|---|---|
| Windows | C:\\Users\\<Username>\\AppData\\Roaming\\Microsoft\\Excel; C:\\Users\\<Username>\\AppData\\Local\\Microsoft\\Office\\UnsavedFiles | AutoRecover and Unsaved Files locations |
| macOS | ~/Library/Application Support/Microsoft/Office AutoRecovery | Office AutoRecovery path; variations by version |
| Office on the web | Cloud autosave; recovery drafts stored in browser cache | Web app behavior differs from desktop |
People Also Ask
Where does Excel save AutoRecover files by default?
AutoRecover files are typically stored in your user profile folders. On Windows, this usually involves the roaming AppData and a local UnsavedFiles folder. On Mac, the Office AutoRecovery directory in Library is used. Access through Excel's settings and the Recover Unsaved Workbooks feature.
AutoRecover stores drafts in OS-specific folders. On Windows, check AppData; on Mac, look in the Office AutoRecovery folder. You can access drafts via Excel's recover options.
How do I access recovered workbooks in Excel?
Open Excel and use File > Open > Recent > Recover Unsaved Workbooks. If the pane appears after a crash, follow the prompts to save the recovered file. For Mac, check the Office AutoRecovery directory if the pane doesn’t show.
Open Excel, go to the recovery prompt, or use Recover Unsaved Workbooks to retrieve drafts.
Can I change the AutoRecover save interval?
Yes. In Excel Options, under Save, you can adjust 'Save AutoRecover information every X minutes'. Set a shorter interval if you work with volatile data, but balance with performance.
Yes, you can adjust the AutoRecover interval in Excel's Save options.
What if I can’t find the recovery files?
First, search both Windows AppData folders and use Recover Unsaved Workbooks. If nothing appears, check recent versions in your cloud storage if available, and verify permissions. Consider increasing AutoRecover frequency and saving more often.
If recovery files aren’t visible, try Recover Unsaved Workbooks and check both profile folders.
Do Office on the web auto-save recovery files?
Office on the web relies on cloud autosave and version history rather than local AutoRecover files. If you lose data, check the document’s version history in the cloud and use regular saves.
Web Excel uses cloud autosave and version history, not local AutoRecover files.
“Effective recovery starts with knowing where Excel saves drafts and how to access them quickly. Consistent AutoRecover settings can dramatically reduce data loss.”
The Essentials
- Identify the right OS paths to locate autosave files.
- Enable AutoRecover with a sensible interval.
- Use Excel's built-in Recover Unsaved Workbooks tool.
- Check Mac AutoRecovery if you're on macOS.
- Back up important work with regular saves and cloud storage.
