How to Recover an Overwritten Excel File on Mac

Accidentally saving over an Excel file on a Mac is one of those gut-drop moments — but it's not always permanent. Whether you hit Save instead of Save As, or closed a document after making unwanted changes, macOS and Microsoft Excel both offer several recovery paths. How far back you can go, and which method works for you, depends on how your Mac is configured and how the file was saved.

Why Overwritten Files Can Sometimes Be Recovered

When you overwrite a file, macOS doesn't always erase the previous version immediately. Depending on your setup, the operating system or application may have quietly preserved an earlier snapshot. The key is knowing where those snapshots might live — because they exist in different places depending on your workflow.

There are four main recovery sources on a Mac:

• AutoRecovery (built into Excel)
• Time Machine (macOS backup system)
• Version History (OneDrive or SharePoint)
• Temporary files (system-level caches)

Method 1: Excel's AutoRecovery Folder

Microsoft Excel for Mac automatically saves temporary recovery files at regular intervals. These aren't the same as your saved file — they're background snapshots Excel creates independently.

Where to look:

Navigate to this path in Finder using Go > Go to Folder:

~/Library/Containers/com.microsoft.Excel/Data/Library/Preferences/AutoRecovery/ 

Files here are named after the original document and end in a format Excel can open. If Excel found something to recover, it often prompts you automatically the next time you open the application.

Important caveats:

• AutoRecovery files are deleted once you close Excel normally after saving
• The interval between AutoRecovery saves (default is every 10 minutes) determines how much work might be recoverable
• This method is most useful when Excel crashed or closed unexpectedly — less so after a clean save-and-close

Method 2: Time Machine Backup

Time Machine is macOS's built-in backup system. If it was enabled before you overwrote the file, it's your most reliable option for restoring a prior version.

How to use it:

1. Open Finder and navigate to the folder where your Excel file is stored
2. Launch Time Machine from the menu bar or System Settings
3. Use the timeline on the right to travel back to a point before the overwrite
4. Select the earlier version of the file and click Restore

Time Machine creates hourly backups for the past 24 hours, daily backups for the past month, and weekly backups before that — provided your backup drive has enough space.

The critical variable here is whether Time Machine was actually running. Many Mac users have it set up; many don't. If you're not sure, check System Settings > General > Time Machine.

Method 3: OneDrive or SharePoint Version History ☁️

If your Excel file was stored in OneDrive or SharePoint (common in Microsoft 365 setups), version history may be the easiest recovery path of all.

Microsoft 365 automatically tracks changes to files stored in the cloud, maintaining a detailed version history that you can browse and restore from — often going back 30 or more versions.

How to access it:

1. Open the file in Excel
2. Click the file name at the top of the window
3. Select Version History
4. Browse earlier versions and open or restore the one you need

Alternatively, you can right-click the file in OneDrive on the web and select Version history from there.

This method works regardless of whether Time Machine is configured, making it a strong option for users who work primarily in the cloud.

Method 4: Check the Temp Folder

macOS occasionally writes temporary working copies of files to system folders. This isn't guaranteed, but it's worth checking when other methods fail.

Open Terminal and type:

open $TMPDIR 

This opens the system's temporary directory in Finder. Look for folders or files with names related to Excel or your document. These files are unpredictable — they may not exist, and they won't always be in a cleanly usable format — but in edge cases, they've helped users recover work.

Factors That Determine What's Recoverable

Not every overwrite is recoverable to the same degree. Several variables affect your options:

What Doesn't Work Here

It's worth being clear about a common misconception: macOS does not have a built-in "Previous Versions" feature the way Windows does (via File History). The Versions feature in some native Mac apps like TextEdit doesn't apply to Excel files the same way — Excel manages its own versioning independently, and that's tied to AutoSave settings and cloud storage rather than the local OS.

Third-party data recovery tools exist and are sometimes recommended in this scenario, but they're designed primarily to recover deleted files, not overwritten ones. An overwritten file — where the same file path was saved to — is fundamentally different from a deleted file, and most disk recovery tools won't help unless you're working with very specific storage conditions. 🔍

The Piece That Varies by Setup

The methods above are real and well-established — but which one applies to your situation comes down to decisions that were made before the overwrite happened: whether backups were running, where the file was stored, and how Excel was configured. Someone working entirely locally with no Time Machine drive has a very different set of options than someone using Microsoft 365 with OneDrive sync enabled.

Understanding your own backup and storage setup is what determines which of these paths is actually available to you right now. 💡