ThisCalculator

Everyday

Excel File Recovery: How to Open and Recover Old Files

Updated · Standard formula, shown below

Excel File Recovery: How to Open and Recover Old Files

This guide shows you how to open and recover old Excel files that won’t open, are corrupted, or were saved in an older format. You’ll learn built-in Excel recovery tools, manual file repair methods, and how to prevent future data loss. No special software is needed—just Excel and a few minutes.

What You’ll Need

  • Microsoft Excel (2013 or later recommended, but most steps work in older versions)
  • The old or corrupted Excel file (or a backup copy)
  • File Explorer (Windows) or Finder (Mac)
  • Optional: a USB drive or cloud storage for backups

Step-by-Step

  1. Try opening the file normally. Double-click the file in File Explorer or Finder. If it opens, great—go to File > Save As and save a copy in the current .xlsx format to avoid compatibility issues.
  2. Use Excel’s built-in repair. If the file doesn’t open, start Excel, go to File > Open > Browse, select the file, click the dropdown arrow next to Open, and choose Open and Repair. Excel will attempt to fix the file. If prompted, choose Repair first; if that fails, try Extract Data to pull values and formulas.
  3. Recover unsaved workbooks. If the file was never saved but you worked on it recently, go to File > Info > Manage Workbook (or Manage Versions) and click Recover Unsaved Workbooks. Look for files with .xlsb or .tmp extensions in the dialog that appears.
  4. Check the Recycle Bin or Trash. If you deleted the file, open the Recycle Bin (Windows) or Trash (Mac), find the file, right-click it, and choose Restore. If it’s not there, check if your cloud storage (OneDrive, Google Drive) has a trash or version history.
  5. Look for backup files. Excel sometimes creates backup copies. Go to File > Options > Save and note the AutoRecover file location. Navigate to that folder and look for files with .xlsb, .xlsx, or .tmp extensions. Copy any likely candidates to a safe location and try opening them.
  6. Change the file extension. If the file is corrupted, make a copy of it, rename the copy to have a .zip extension (e.g., oldfile.xlsx becomes oldfile.zip), and extract it using your operating system’s built-in zip tool. Inside, you’ll see folders like xl and worksheets. Look for XML files that contain your data—you can open those in a text editor to recover raw content.
  7. Use a third-party file viewer. If Excel can’t open the file at all, try opening it in a free spreadsheet viewer like LibreOffice Calc or Google Sheets. Sometimes these tools can read files that Excel refuses to open. If they open, save a copy in .xlsx format and then open that in Excel.
  8. Try an older Excel version. If the file was created in a very old format (like .xls), and you have access to an older Excel version, try opening it there. If not, use Excel’s File > Open and change the file type filter to All Files to force Excel to attempt to read it.

Common Mistakes

  • Opening the file directly from email or a download folder. This can cause Excel to block the file due to security settings. Instead, save the file to your computer first, then open it.
  • Not saving a backup before attempting repairs. Always copy the original file before using repair tools, as they can sometimes overwrite the original.
  • Ignoring AutoRecover settings. If you haven’t enabled AutoRecover, you won’t have recent versions to fall back on. Check your settings in File > Options > Save.
  • Using the wrong file extension. If you manually change a file’s extension (e.g., from .xls to .xlsx), it can corrupt the file further. Only change extensions when you’re sure of the format.

Tips

  • Set AutoRecover to save every 5 minutes and keep the last autosaved version. Go to File > Options > Save and adjust the settings.
  • Always save important files to OneDrive or another cloud service. Version history lets you revert to any previous save.
  • If you work with critical data, create a backup routine—copy the file to an external drive or cloud after each major edit.
  • When saving old .xls files, use File > Save As and choose the .xlsx format to ensure compatibility with current Excel.

Troubleshooting

  • Excel says the file is corrupt and won’t open. Try the Open and Repair option first. If that fails, copy the file to a different location (e.g., your desktop) and try again. Sometimes the issue is with the file’s location or permissions.
  • The file opens but shows garbled characters. This usually means the file is not actually an Excel file—it might be a text file or a different format. Try opening it with Notepad to see the content, or use a file identification tool to check the real extension.
  • You can’t find the AutoRecover folder. In Excel, go to File > Options  Save and look for the AutoRecover file location. If the path is blank, Excel may not have saved any recoverable versions.
  • The file is password-protected and you forgot the password. Excel does not provide a way to recover passwords. You’ll need to use a third-party password recovery tool, but be aware that this may be against the file owner’s intentions.
  • You see a message about ‘unreadable content’. Click Yes to try to recover the content. Excel will often repair the file and show a report of what was fixed.

Frequently Asked Questions

  1. Can I recover an Excel file that was never saved? Yes, if you had AutoRecover enabled. Go to File > Info > Manage Workbook > Recover Unsaved Workbooks. If you never saved the file at all and AutoRecover was off, recovery is unlikely.
  2. What is the difference between ‘Repair’ and ‘Extract Data’ in Open and Repair? Repair attempts to fix the file structure and recover as much as possible. Extract Data pulls raw values and formulas without formatting, useful when the file is severely damaged.
  3. How do I open an .xls file in modern Excel? Simply double-click it. Excel will open it in compatibility mode. To convert it to .xlsx, use File > Save As and choose the new format.
  4. Why does Excel say the file is locked for editing? This usually means the file is open in another instance of Excel or by another user. Check your Task Manager for Excel processes, or ask other users to close it. If it’s a shared file, you may need to wait.
  5. Can I recover a file from a corrupted USB drive? Yes, but you’ll need to copy the file to your computer first. If the drive is not recognized, try using a different USB port or a data recovery tool. Once copied, use the repair methods above.
  6. Are there any free tools to repair Excel files? Yes, LibreOffice Calc and Google Sheets can often open corrupted files. There are also free online Excel repair services, but be cautious about uploading sensitive data.

Related

Method: the standard formula for this calculation, rounded as each result states. See how the calculators work or report an error.