Where Do Excel Autosave Files Go: A Practical Guide

Where do excel autosave files go on Windows and Mac

If you’re asking where do excel autosave files go, the answer isn’t a single folder. According to XLS Library, the autosave and AutoRecover features are designed to protect your work, but their physical locations depend on your operating system and Office version. In practice, Excel saves temporary copies in a user-specific area rather than a shared program folder, which means you’ll usually need to browse your own profile to locate recoverable data after a crash. On Windows, the most common starting point is the AppData folder within your user directory, sometimes nested under Roaming or Local subfolders. On macOS, the equivalent is inside your Home Library folders; paths can vary by Office release and whether you use Office for Mac or the App Store version. This article translates those realities into concrete steps you can follow today.

To reduce confusion, remember that AutoRecover is designed to balance speed and safety. The default interval is typically set to 10 minutes in many Office installations, and you can adjust this interval in Excel Options under Save. Understanding where the files live helps you quickly recover after an unexpected shutdown and minimize data loss.

In all scenarios, do not rely on memory alone—know the configured path and make a habit of checking the recovery pane when Excel restarts after a crash.

How AutoRecover works across platforms

AutoRecover operates as a background safety net. On Windows and Mac, it creates temporary, recoverable copies at regular intervals (the default varies by version but is commonly 10 minutes). AutoSave, when enabled in Office 365, saves directly to the cloud (OneDrive or SharePoint) and helps protect collaborative work in real time. The two features are related but not identical: AutoRecover offers local recovery after a crash, while AutoSave protects by continuously syncing changes to the cloud. The exact file locations for AutoRecover data are platform-dependent and can be influenced by user settings, installed Office updates, and whether add-ins modify save behavior.

For practitioners, this means you should treat AutoRecover as a safety net rather than a guaranteed archive. If you work with very large spreadsheets or frequent interruptions, pairing AutoRecover with a short save cadence and occasional manual saves is prudent. This combination minimizes the risk of data loss while maintaining performance.

Windows: Where Excel autosave files go

On Windows, Excel typically stores AutoRecover data in a user-scoped directory within AppData. The path can appear as AppData\Roaming\Microsoft\Excel or within a subfolder related to AutoRecover depending on the Office version you’re using. If you enable Show hidden files, you can navigate to your profile (C:\Users\YourUsername) and explore AppData, Local, and Roaming folders to locate potential recoverable files. When Excel restarts after a crash, the Document Recovery pane often lists the most recent autosaved versions, which you can open or save to a new location. Remember that the exact path may shift with major Office updates, so it’s wise to verify in Excel Options > Save where the AutoRecover files are configured to be written.

If you’ve customized your install or use a corporate profile with redirected folders, the recovery path might point to a network share or a different local subdirectory. In such cases, consult IT or the local policy to identify the effective recovery folder.

Mac: Paths and Settings for AutoRecover

Mac users face similar concepts but different filesystem conventions. AutoRecover data for Excel on macOS lives in user Library folders, and the precise location can vary by Office version and installation type. Typical starting points include Library subfolders within the home directory and, in some setups, specific containers used by Office apps. To locate or adjust this, open Excel > Preferences > Save or check the AutoRecover setting in the same pane. If you can’t find recoverable files, this is a strong signal to confirm the configured path and ensure AutoRecover is enabled. Mac environments sometimes store autosaved copies in inconspicuous locations, so keeping an up-to-date backup strategy is essential for critical work.

A practical tip is to perform a quick search in Finder for terms like “AutoRecover” or the current workbook’s name to surface any hidden autosave files. Also, confirm that macOS privacy settings allow Excel to access its own recovery folders.

How to locate autosave files manually

Locating autosave files manually involves a few targeted steps. Start by checking Excel’s built-in recovery features: launch Excel after a crash and look for the Document Recovery pane, which lists autosaved copies that Excel detected on startup. If nothing appears, navigate to the configured AutoRecover path in Excel Options > Save and inspect that folder directly using File Explorer (Windows) or Finder (Mac). You can also perform a system search for keywords like “AutoRecover” or the workbook name, including hidden files. In environments with redirected folders or corporate profiles, recovery data may be stored on a network drive rather than locally.

If you use Excel for the Web, remember that autosave happens in the cloud. Local recovery copies may not exist, but version history and previous versions within OneDrive/SharePoint can serve as a fallback. Regularly saving manually to a known local or cloud location remains a best practice.

AutoSave in Excel for the Web vs desktop

Excel for the Web relies primarily on cloud autosave, which means there are effectively no local autosave files to locate. Your changes are continuously written to OneDrive or SharePoint, depending on how you opened the file. Desktop Excel, by contrast, uses AutoRecover on Windows or macOS to store local recovery data when a crash occurs. Understanding this distinction is crucial when you collaborate across platforms; if you’re offline, AutoSave may not capture every change, and you’ll rely more on AutoRecover or manual backups when reconnecting. In both cases, enabling version history in the cloud adds an extra safety net for critical work.

Configuring AutoRecover and AutoSave for safety

To optimize protection, configure AutoRecover settings in Excel Options. Set a reasonable interval (for example, 5-10 minutes) and choose a clearly labeled AutoRecover file location you can easily access. If you use Office 365, enable AutoSave to ensure continuous cloud backups and collaborative safety. On Windows, consider enabling the option to keep the last autosaved version if you close without saving. For Mac users, verify that Excel Preferences reflect the intended AutoRecover path and that the Library location isn’t restricted by macOS security settings. Finally, pair autosave with regular manual saves and a routine backup strategy to minimize data loss during unexpected shutdowns.

Troubleshooting: recover best practices

If you can’t locate autosave files after a crash, start with the startup recovery pane in Excel. If nothing appears, check that AutoRecover is enabled, confirm the configured path in Excel Options, and search the recovery directories for recent files. If you still can’t find anything, search the system for files with the “AutoRecover” label or check the OneDrive/SharePoint version history for cloud-based work. Running a quick test by creating a new workbook and forcing an abnormal shutdown can help you verify that the recovery workflow is functioning as expected. Finally, consider implementing a short cadence of frequent manual saves and keeping local backups as an additional guardrail.