How to Recover a Corrupt Excel File

PDF download Download Article
Easy ways to recover a corrupt Excel file
PDF download Download Article

This wikiHow teaches you how to recover and repair a corrupted Microsoft Excel file on your Windows or Mac computer.

Method 1
Method 1 of 5:

Repairing the File

PDF download Download Article
  1. Make sure that you're using a Windows computer. You can only repair an Excel file in the Windows version of Excel.
    • If you're using a Mac, try one of the other methods in this article.
  2. Its app icon resembles a green box with a white "X" on it.
    Advertisement
  3. This option is next to a folder-shaped icon in the lower-left corner of the window.
  4. It's a folder-shaped icon in the middle of the page. Doing so opens a File Explorer window.
  5. Select your Excel file . Go to the folder in which your corrupted Excel file is stored, then click the Excel file to select it. [1]
  6. It's the downward-facing arrow to the right of the Open button. A drop-down menu will appear. [2]
  7. This option is at the bottom of the drop-down menu.
    • If Open and Repair... is greyed out, make sure that your Excel file is selected and try again. If it's still greyed out, you can't repair this file.
  8. It's in a pop-up window. Windows will begin attempting to repair your file. [3]
    • If you don't have this option, click Extract Data instead, then click either Convert to Values or Recover Formulas . This will recover any salvageable data.
  9. This may take a few minutes if your Excel file is large.
    • If the file still won't open, go back through this process and click Extract Data instead of Repair when prompted.
  10. Save your file . Once the repaired file opens, press Ctrl + S , double-click This PC , select a save location, enter a file name, and click Save .
    • Be sure to select a different file name than the one which you used for the corrupted Excel file.
    11. Advertisement
Method 2
Method 2 of 5:

Changing the File Type on Windows

PDF download Download Article
  1. Sometimes, Excel documents created on older computers or versions of Excel become unstable on newer versions; similarly, Excel documents can be saved in many different file formats. By changing the Excel file format to "xlsx" (or "xls" for older programs), you can fix this problem.
  2. Click the Windows logo in the bottom-left corner of the screen.
  3. Click the folder-shaped icon in the lower-left side of the Start window.
  4. It's at the top of the File Explorer window. A toolbar will appear below this tab.
  5. This option is in the "Show/hide" section of the toolbar. Doing so will allow you to see the file type extensions at the end of files, including your Excel document.
  6. Go to the location of the Excel document that you want to recover, then click the document to select it.
  7. It's a tab in the upper-left side of the File Explorer window. This will prompt a toolbar to appear.
  8. This option is in the "Organize" section of the toolbar. Clicking Rename will cause the Excel file's name to become highlighted.
  9. Replace whatever comes after the period at the end of the file name with xlsx and then press ↵ Enter .
    • For example, if the document was named "Spreadsheet1.docx", you would change it to "Spreadsheet1.xlsx".
    • If the file extension already is "xlsx", try using "xls" or "html".
  10. This will confirm your changes and change the file extension.
  11. Double-click the file to open it. If the file opens in Excel (or, if you selected "html" as the extension, a web browser), your file has successfully been recovered.
    • If you chose the "html" extension, you can convert the webpage into an Excel document by dragging the html file onto the Excel icon and then saving the file that opens as a new "xlsx" file.
    • If the file still won't open, proceed to the next Windows method .
    12. Advertisement
Method 3
Method 3 of 5:

Changing the File Type on Mac

PDF download Download Article
  1. Sometimes, Excel documents created on older computers or versions of Excel become unstable on newer versions; similarly, Excel documents can be saved in many different file formats. By changing the Excel file format to "xlsx" (or "xls" for older programs), you can fix this problem.
  2. Click the blue, face-shaped app icon in your Mac's Dock.
  3. Go to the folder in which your Excel file is located, then click the Excel file that you want to recover.
  4. This menu item is in the top-left corner of your Mac's screen. Clicking it prompts a drop-down menu.
  5. It's in the File drop-down menu. This will open a pop-up window.
  6. If you don't see any file name or extension below this category, click the triangle to the left of the "Name & Extension" heading to view the file's name and extension.
  7. Replace whatever comes after the period at the end of the file name with xlsx and then press ⏎ Return .
    • For example, if the document was named "Spreadsheet1.txt", you would change it to "Spreadsheet1.xlsx".
    • If the file extension already is "xlsx", try using "xls" or "html".
  8. This will confirm your decision and change the file type.
  9. Double-click the file to open it. If the file opens in Excel (or, if you selected "html" as the extension, a web browser), your file has successfully been recovered.
    • If you chose the "html" extension, you can convert the webpage into an Excel document by dragging the html file onto the Excel icon and then saving the file that opens as a new "xlsx" file.
    • If the file still won't open, proceed to the next Mac method .
    10. Advertisement
Method 4
Method 4 of 5:

Recovering a Temporary Save on Windows

PDF download Download Article
  1. Like most Microsoft Office products, Excel will automatically save recovery versions of files, meaning that you may be able to restore a partial version of your corrupted Excel document. However, Excel doesn't always save these files in time, and you most likely won't be able to recover the whole document in this way.
  2. Click the Windows logo in the bottom-left corner of the screen.
  3. This will search your computer for the "This PC" program.
  4. It's the computer monitor-shaped icon at the top of the Start window. Doing so opens the This PC window.
  5. This is usually the "OS (C:)" option below the "Devices and drives" heading in the middle of the page.
  6. You'll find this in the middle of the hard drive's folder. [4]
  7. This folder is labeled with part or all of your username on your computer.
  8. It's in the "A" section, so you'll most likely find this folder near the top of the window. [5]
    • If you can't find this folder, click the View tab, then check the "Hidden items" box in the "Show/hide" section to prompt the "AppData" folder to appear.
  9. This option is near the top of the folder.
  10. You'll find it in the "M" section.
  11. It's in the "O" section of the Microsoft folder.
  12. This folder should be near the top of the window. [6]
  13. Look for an Excel file icon that has a name matching your corrupted Excel file, then click it to select it.
    • If you don't see any files here, a recovery version of your Excel document was not saved.
  14. To do so: [7]
    • Click View
    • Check the "File name extensions" box.
    • Click Home
    • Click Rename
    • Replace the .tmp section with .xlsx
    • Press ↵ Enter .
    • Click Yes when prompted.
  15. Double-click the file that you just renamed to open it.
  16. Once the restored file opens, press Ctrl + S , double-click This PC , select a save location, enter a file name, and click Save .
    • Be sure to select a different file name than the one which you used for the corrupted Excel file.
    17. Advertisement
Method 5
Method 5 of 5:

Recovering a Temporary Save on Mac

PDF download Download Article
  1. Like most Microsoft Office products, Excel will automatically save recovery versions of files, meaning that you may be able to restore a partial version of your corrupted Excel document. However, Excel doesn't always save these files in time, and you most likely won't be able to recover the whole document in this way.
  2. This menu item is at the top of the screen. Clicking it prompts a drop-down menu.
    • If you don't see the Go menu item, first open Finder or click the desktop to make it appear.
  3. After doing this, you should see the Library folder appear in the Go drop-down menu.
  4. It's in the Go drop-down menu. This will open the Library hidden folder.
  5. Double-click the "Containers" folder, which is in the "C" section of the Library folder. [8]
  6. It's in the upper-right side of the window.
  7. Type in com.microsoft.Excel and press ⏎ Return .
  8. You'll find this to the right of the "Search:" heading near the top of the Finder window.
  9. Double-click this folder to open it.
  12. If you don't see this folder, scroll down to find it.
  13. This will bring up a list of automatically saved versions of your Excel files. [9]
  14. The temporary version of your Excel file should have some or all of the file's name in its title.
    • If you can't find the temporary version of your Excel file, it wasn't backed up.
  15. Click the Excel file to do so.
  16. It's a menu item in the upper-left corner of your Mac's screen. A drop-down menu will appear.
  17. This option is near the top of the File drop-down menu. You should see a pop-out menu open.
  18. It's in the pop-out menu. Doing so will prompt the temporary version of the Excel document to open in Excel.
    • The temporary version will probably not include some of your most recent changes to the original Excel document.
  19. Press ⌘ Command + S , then enter a file name, select a save location in the "Where" menu, and click Save .
    20. Advertisement

Community Q&A

Search
Add New Question
  • Question
    I cannot open the file with my Excel file, but I can open it in another computer. Why?
    Community Answer
    It's likely that the other computer has either an older or newer version of Excel, and your document is not compatible with the version you have on your computer.
    Thanks! We're glad this was helpful.
    Thank you for your feedback.
    If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
    Yes No
    Not Helpful 6 Helpful 16
  • Question
    What do I do if my Excel files are save with the extension xls?
    Nakamura Rei
    Community Answer
    You can repair .xls files using methods from this article as well as xlsx.
    Thanks! We're glad this was helpful.
    Thank you for your feedback.
    If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
    Yes No
    Not Helpful 3 Helpful 3
  • Question
    How do I recover a deleted excel file in Windows 7?
    Community Answer
    y\You can use the same method. However, to change the file extension you will need to use CMD and run a command like this (make sure you are in the right directory): rename (corrupted excel file, add its file extension at the end) (corrupted excel filename, do NOT add the file extension at the end).(xls, xlsx).
    Thanks! We're glad this was helpful.
    Thank you for your feedback.
    If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
    Yes No
    Not Helpful 3 Helpful 0
Ask a Question
200 characters left
Include your email address to get a message when this question is answered.
Submit
      Advertisement

      Video

      Tips

      • Windows computers will often attempt to repair automatically the corrupted Excel workbook when you open it. [10]
        Thanks
        Helpful 0 Not Helpful 0
      • You may be able to open an otherwise corrupted Excel file by placing your computer in safe mode . If so, a file error or a virus is most likely the reason for your document failing to open.
        Thanks
        Helpful 0 Not Helpful 0
      • There are a few paid data recovery software options that you can use to recover corrupted Excel files. Stellar Phoenix Excel Repair, which is available for both Windows and Mac computers, is a good example of such a program.
        Thanks
        Helpful 0 Not Helpful 0
      Submit a Tip
      All tip submissions are carefully reviewed before being published
      Name
      Please provide your name and last initial
      Submit
      Thanks for submitting a tip for review!
      Advertisement

      Warnings

      Advertisement

      You Might Also Like

      How to
      Remove a Macro in Excel
      How to
      Make a File Downloadable from Your Website
      How to
      Merge Cells in Microsoft Excel: A Quick Guide
      How to
      Unprotect an Excel Sheet
      How to
      Unhide All Rows and Columns in Microsoft Excel
      How to
      Use If‐Else in Microsoft Excel: Step-by-Step Tutorial
      How to
      Insert Pictures in Excel That Automatically Size to Fit Cells
      How to
      Create a Mortgage Calculator With Microsoft Excel
      How to
      Create a Graph in Excel
      How to
      Show Hidden Columns in Microsoft Excel & Unhide Column A
      How to
      Fix Ethernet Doesn't Have a Valid IP Configuration on Windows
      3 Easy Ways to Freeze Panes to Lock Columns or Rows in Excel
      How to
      Change from Lowercase to Uppercase in Microsoft Excel
      How to
      Make a Spreadsheet in Excel
      Advertisement

      References

      1. ↑ https://support.microsoft.com/en-us/office/repair-a-corrupted-workbook-153a45f4-6cab-44b1-93ca-801ddcd4ea53
      2. ↑ https://support.microsoft.com/en-us/office/repair-a-corrupted-workbook-153a45f4-6cab-44b1-93ca-801ddcd4ea53
      3. ↑ https://support.office.com/en-us/article/Repair-a-corrupted-workbook-153A45F4-6CAB-44B1-93CA-801DDCD4EA53
      4. ↑ https://learn.microsoft.com/en-us/office/troubleshoot/word/recover-lost-unsaved-corrupted-document
      5. ↑ https://learn.microsoft.com/en-us/office/troubleshoot/word/recover-lost-unsaved-corrupted-document
      6. ↑ https://learn.microsoft.com/en-us/office/troubleshoot/word/recover-lost-unsaved-corrupted-document
      7. ↑ https://www.easeus.com/file-recovery/recover-and-repair-corrupted-excel-file-in-windows-10.html
      8. ↑ https://support.microsoft.com/en-us/office/recover-files-in-office-for-mac-6c6425b1-6559-4bbf-8f80-4f038402ff02
      9. ↑ https://support.microsoft.com/en-us/office/recover-files-in-office-for-mac-6c6425b1-6559-4bbf-8f80-4f038402ff02
      1. ↑ https://support.office.com/en-us/article/repairing-a-corrupted-workbook-7abfc44d-e9bf-4896-8899-bd10ef4d61ab

      About This Article

      Article Summary X

      1. Open Excel.
      2. Select Open Other Workbooks .
      3. Select the corrupted file.
      4. Click the down-arrow menu next to "Open."
      5. Select Open and Repair .
      6. Click Repair .
      7. Click Close when complete.

      Did this summary help you?
      In other languages
      Thanks to all authors for creating a page that has been read 1,805,158 times.

      Is this article up to date?

      Advertisement