What you can recover depends on when you last saved
When you overwrite an Excel file on Mac, the original version is usually gone from your hard drive — but not always. Your chances of recovery depend on three things: whether you saved the new version, whether Time Machine was running, and how much time has passed. If you caught the mistake right away and haven't saved yet, you can undo the changes. If you saved over the file, Time Machine is your fastest option. If Time Machine wasn't running, recovery software can sometimes find the old file, but success is not may provide.
The reason recovery is possible at all is that deleting or overwriting a file doesn't erase the data when ready. The Mac marks that space as available for new data, but the old information stays there until something else writes over it. The sooner you stop using the computer, the better your chances.
Key Takeaways
- If you haven't saved the new version yet, press Command+Z to undo the changes and restore the old file.
- Time Machine backups let you restore a previous version of the file if the backup ran before you overwrote it.
- Excel's AutoRecover feature saves drafts every 10 minutes by default, and you can check the AutoRecover folder even if you didn't manually save.
- Recovery software like EaseUS Data Recovery Wizard or Disk Drill can scan your drive for deleted files, but works best if you stop using the Mac when ready after the overwrite.
- Once you recover the file, turn on Time Machine and set Excel to save more frequently to prevent this from happening again.
Undo the change if you haven't saved the new version
The fastest recovery is no recovery at all. If you overwrote the file but haven't saved the new version, press Command+Z to undo. This works even if you closed the file without saving, as long as Excel is still open. Excel keeps the undo history in memory until you quit the process.
If you've already closed Excel, this won't work. But if the file is still open in front of you, undo is your answer. Keep pressing Command+Z to step back through your changes until you reach the version you want.
Check Time Machine if it was running
Time Machine is the built-in Mac backup system. If you turned it on before you overwrote the file, it has hourly snapshots of your drive going back weeks or months. To check whether Time Machine has a copy of your file, click the Time Machine icon in the menu bar (top right of your screen) and select "Enter Time Machine."
Once you're in Time Machine, navigate to the folder where your Excel file lives. The window will show you a timeline on the right side. Click on a date before you overwrote the file — Time Machine usually keeps hourly backups for the past 24 hours, daily backups for the past month, and weekly backups after that. When you find the version you want, click it and then click "Restore." The file will be copied back to its original location.
If you don't see Time Machine in your menu bar, it's not turned on. Open System Settings, click "General," then "Time Machine," and check whether it says "Off." If it does, Time Machine has no backups to offer you.
Look in the AutoRecover folder
Excel saves a draft copy of your work every 10 minutes, even if you haven't manually saved. These drafts live in a hidden folder. To find them, open Finder and press Command+Shift+G to open the "Go to Folder" dialog. Paste this path: ~/Library/Containers/com.microsoft.Excel/Data/Library/AutoRecovery
You'll see a list of files with names like "Book1" or "Sheet1" and timestamps. Look for the one with the date and time closest to when you last worked on the file before you overwrote it. Double-click it to open it. If it contains the version you want, save it with a new name right away so you don't lose it again.
This folder only helps if Excel crashed or you force-quit it. If you saved over the file normally, the AutoRecover file is usually overwritten too. But it's worth checking because sometimes the AutoRecover version is slightly older than what you saved.
Use recovery software if Time Machine isn't available
If Time Machine wasn't running and AutoRecover doesn't have what you need, recovery software can scan your drive for deleted or overwritten files. Two programs that work on Mac are EaseUS Data Recovery Wizard and Disk Drill. Both have free versions that let you scan and preview files before you pay to recover them.
read the software and run a scan of your hard drive. The scan looks for file signatures — patterns of data that mark the beginning and end of an Excel file. When it finds matches, it lists them with the date they were created. Look for your file by name and creation date. Preview it to make sure it's the right version, then recover it to a different drive or folder.
Recovery software works best if you stop using your Mac when ready after you realize the file is gone. Every time you save a new file, read something, or install an update, you risk writing over the space where your old file lived. The longer you wait, the less likely the software is to find a complete, readable copy.
Success is not may provide. If your drive has been heavily used since the overwrite, the old file may be fragmented or partially overwritten. Recovery software can sometimes piece together partial files, but the result may be corrupted or incomplete.
Prevent this from happening again
Once you've recovered your file, set up protections so you don't lose work this way again. First, turn on Time Machine if it's off. Open System Settings, go to "General," then "Time Machine," and click "Add Backup Disk." Select an external drive or network storage. Time Machine will then back up your entire Mac automatically.
Second, change how Excel saves. Open Excel, go to "Excel" in the menu bar, then "Settings." Click "Save" and look for "AutoSave." Turn it on if it's off. You can also change the AutoRecover interval from 10 minutes to something shorter, like 5 minutes. This won't prevent overwriting, but it means you'll have a more recent draft to fall back on.
Third, consider using "Save As" instead of "Save" when you make major changes. This creates a new file with a new name, so you keep the old version. You can delete old versions later, but you'll have them if you need to step back.
Frequently Asked Questions
Can I recover a file if I overwrote it weeks ago?
Time Machine can recover it if your backups go back that far — usually they do, since Time Machine keeps weekly backups for months. Recovery software has a much lower chance because the space where your file lived has probably been written over many times. The sooner you try, the better.
Will recovery software definitely find my file?
No. Recovery software scans for file signatures, but if your drive has been heavily used, the old file may be fragmented or partially overwritten. You might get a corrupted file, a partial file, or nothing at all. Time Machine is much more reliable because it stores complete copies.
What if I don't remember which version I want?
Time Machine shows you a timeline, so you can step through several dates and open each version to see which one you need. Most recovery software also lets you preview files before you recover them. Open a few candidates and compare them to figure out which is the right one.
Does closing the file without saving protect the old version?
Only if you haven't saved the new version yet. If you close without saving, Excel asks whether you want to save changes. Click "Don't Save" and the old version stays on disk. But if you already saved the new version, closing the file doesn't help — the old version is already gone from the hard drive.
Should I keep the recovered file in the same location?
No. Save it with a different name or in a different folder at first, so you don't accidentally overwrite it again while you're figuring out what you need. Once you've confirmed it's the right version and extracted what you need, you can decide whether to keep both versions or delete the newer one.