Where Excel Temp Files Are Stored: A Practical Guide
Learn where Excel stores temporary and AutoRecover files on Windows and Mac, how to locate the paths, recover unsaved work, and manage temp data for safer spreadsheets.
Where Excel temp files are stored depends on your operating system and Office version. In Windows, temporary and AutoRecover files usually live in the system Temp folder or under AppData locations used by Office, such as AppData Local. On macOS, temporary items are kept in the user Library folders. You can locate the exact path in Excel Options, Save and by checking your OS temp directory.
Why Excel Creates Temp Files
Temporary files are not junk; they are part of Excel's recovery framework. According to XLS Library, Excel writes temp files during edits to preserve your work in case of a crash, signal loss, or unexpected shutdown. These files enable data recovery even when Excel terminates abruptly. The exact behavior depends on your Office version and whether AutoRecover is enabled. In practice, temp files capture incremental changes, allowing you to recover most recent edits in a crash scenario. Understanding this can save you hours when a workbook closes suddenly, or when power fails mid-edit. For safety, always save frequently and verify AutoRecover settings in Excel Options.
Note: The exact storage location can vary by OS and configuration; the recovery process relies on both the temp folder and Office-specific subfolders. See Microsoft Support guidance for AutoRecover locations and behavior.
The XLS Library team found that keeping AutoRecover enabled with a reasonable interval strikes a balance between protection and disk usage. Regularly reviewing these settings helps you align recovery depth with your work style.
Common temp file locations and AutoRecover behavior across platforms
| Platform | Default AutoRecover Interval | Typical Temp Location | Notes |
|---|---|---|---|
| Windows | 10 minutes (adjustable 5-15) | System Temp; AppData Local; Office UnsavedFiles | AutoRecover saves recent edits; not a guarantee |
| Mac | 10 minutes (adjustable) | User Library temp folders; temporary items in Library folders | AutoSave and Recovery features vary by version |
People Also Ask
Where are Excel temp files stored on Windows?
Most temp files reside in the system Temp folder or in AppData subfolders used by Office. Exact paths depend on your Office version and user configuration. Check the AutoRecover file location in Excel Options to verify where recovery files are saved.
On Windows, look in the system Temp folder or AppData subfolders for recovery files; verify AutoRecover settings in Excel Options.
Where are Excel temp files stored on Mac?
Mac stores temporary items in user Library temp folders. AutoRecover and related recovery data may be under Library paths specific to your Office installation. Check Excel preferences and the macOS temp directories to confirm locations.
On Mac, temporary items live in the user Library folders.
How can I locate the exact AutoRecover path in Excel?
Open Excel Options, go to the Save tab, and note AutoRecover file location. You can also inspect your OS temp directory by using terminal commands or system settings to confirm where temporary files are stored.
In Excel, check the Save settings to see AutoRecover location, and verify the OS temp path if needed.
Can I change where Excel stores temp files?
Yes. You can adjust AutoRecover intervals and, in Windows, rely on the OS temp path. Mac paths are controlled by Library locations. Changing these requires changing Office settings and, for Windows, potentially OS environment variables.
Yes—adjust AutoRecover settings and, on Windows, the OS temp path; Mac uses Library temp folders.
How do I recover data from a corrupted workbook using temp files?
If Excel crashes, the Document Recovery pane may present unsaved edits. Temp files can sometimes be used to reconstruct recent work, depending on last autosave and recovery settings. Open the recovered file from the pane or locate the temp file manually if needed.
Use the Document Recovery pane after relaunch to recover unsaved work; temp files help if autosave captured recent changes.
Should I delete temp files to free space?
Temp files are typically safe to delete when Excel is closed, but avoid deleting while Excel is running. On Windows, Disk Cleanup can remove temp files; on Mac, use built-in cleanup utilities or third-party tools with care.
Yes, you can clean up temp files after closing Excel to reclaim space.
“Temp files are your safety net during unexpected shutdowns. Properly locating and configuring AutoRecover paths reduces data loss and speeds recovery.”
The Essentials
- Identify the AutoRecover path in Excel settings to access recovery files quickly.
- Check OS temp directories using environment variables for fast access.
- Inspect Windows AppData and Local Temp locations for temp files.
- Inspect Mac Library temporary folders for Excel recovery items.
- Schedule regular temp-file cleanup to keep disk space available.
