How to Recover a Corrupt Excel File
This wikiHow teaches you how to recover and repair a corrupted Microsoft Excel file on your Windows or Mac computer. Make sure that you're using a Windows computer. You can only repair an Excel file in the Windows version of Excel.
Method 1 of 5:
Repairing the File
-
How to Recover a Corrupt Excel File Picture 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.
-
How to Recover a Corrupt Excel File Picture 2
Open Excel. Its app icon resembles a green box with a white "X" on it. -
How to Recover a Corrupt Excel File Picture 3
Click Open Other Workbooks. This option is next to a folder-shaped icon in the lower-left corner of the window. -
How to Recover a Corrupt Excel File Picture 4
Click Browse. It's a folder-shaped icon in the middle of the page. Doing so opens a File Explorer window. -
How to Recover a Corrupt Excel File Picture 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. -
How to Recover a Corrupt Excel File Picture 6
Click the "Menu" iconHow to Recover a Corrupt Excel File Picture 7
-
How to Recover a Corrupt Excel File Picture 8
Click Open and Repair…. 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.
-
How to Recover a Corrupt Excel File Picture 9
Click Repair when prompted. It's in a pop-up window. Windows will begin attempting to repair your file.[1]- 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.
-
How to Recover a Corrupt Excel File Picture 10
Wait for the file to open. 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.
-
How to Recover a Corrupt Excel File Picture 11
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.
Method 2 of 5:
Changing the File Type on Windows
-
How to Recover a Corrupt Excel File Picture 12
Understand why the file type matters. 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. -
How to Recover a Corrupt Excel File Picture 13
Open StartHow to Recover a Corrupt Excel File Picture 14
-
How to Recover a Corrupt Excel File Picture 15
Open File ExplorerHow to Recover a Corrupt Excel File Picture 16
-
How to Recover a Corrupt Excel File Picture 17
Click the View tab. It's at the top of the File Explorer window. A toolbar will appear below this tab. -
How to Recover a Corrupt Excel File Picture 18
Check the "File name extensions" box. 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. -
How to Recover a Corrupt Excel File Picture 19
Select your Excel file. Go to the location of the Excel document that you want to recover, then click the document to select it. -
How to Recover a Corrupt Excel File Picture 20
Click Home. It's a tab in the upper-left side of the File Explorer window. This will prompt a toolbar to appear. -
How to Recover a Corrupt Excel File Picture 21
Click Rename. This option is in the "Organize" section of the toolbar. Clicking Rename will cause the Excel file's name to become highlighted. -
How to Recover a Corrupt Excel File Picture 22
Change the file type. 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".
-
How to Recover a Corrupt Excel File Picture 23
Click Yes when prompted. This will confirm your changes and change the file extension. -
How to Recover a Corrupt Excel File Picture 24
Try opening the file. 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.
Method 3 of 5:
Changing the File Type on Mac
-
How to Recover a Corrupt Excel File Picture 25
Understand why the file type matters. 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. -
How to Recover a Corrupt Excel File Picture 26
Open Finder. Click the blue, face-shaped app icon in your Mac's Dock. -
How to Recover a Corrupt Excel File Picture 27
Select the Excel file. Go to the folder in which your Excel file is located, then click the Excel file that you want to recover. -
How to Recover a Corrupt Excel File Picture 28
Click File. This menu item is in the top-left corner of your Mac's screen. Clicking it prompts a drop-down menu. -
How to Recover a Corrupt Excel File Picture 29
Click Get Info. It's in the File drop-down menu. This will open a pop-up window. -
How to Recover a Corrupt Excel File Picture 30
Expand the "Name & Extension" section if necessary. 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. -
How to Recover a Corrupt Excel File Picture 31
Change the file type. 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".
-
How to Recover a Corrupt Excel File Picture 32
Click Use .xlsx when prompted. This will confirm your decision and change the file type. -
How to Recover a Corrupt Excel File Picture 33
Try opening the file. 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.
Method 4 of 5:
Recovering a Temporary Save on Windows
-
How to Recover a Corrupt Excel File Picture 34
Understand the limitations of this method. 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. -
How to Recover a Corrupt Excel File Picture 35
Open StartHow to Recover a Corrupt Excel File Picture 36
-
How to Recover a Corrupt Excel File Picture 37
Type in this pc. This will search your computer for the "This PC" program. -
How to Recover a Corrupt Excel File Picture 38
Click This PC. It's the computer monitor-shaped icon at the top of the Start window. Doing so opens the This PC window. -
How to Recover a Corrupt Excel File Picture 39
Double-click your computer's hard drive. This is usually the "OS (C:)" option below the "Devices and drives" heading in the middle of the page. -
How to Recover a Corrupt Excel File Picture 40
Double-click the "Users" folder. You'll find this in the middle of the hard drive's folder. -
How to Recover a Corrupt Excel File Picture 41
Double-click your user folder. This folder is labeled with part or all of your username on your computer. -
How to Recover a Corrupt Excel File Picture 42
Double-click the "AppData" folder. It's in the "A" section, so you'll most likely find this folder near the top of the window.- 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.
-
How to Recover a Corrupt Excel File Picture 43
Double-click the "Local" folder. This option is near the top of the folder. -
How to Recover a Corrupt Excel File Picture 44
Scroll down and double-click the "Microsoft" folder. You'll find it in the "M" section. -
How to Recover a Corrupt Excel File Picture 45
Double-click the "Office" folder. It's in the "O" section of the Microsoft folder. -
How to Recover a Corrupt Excel File Picture 46
Double-click the "UnsavedFiles" folder. This folder should be near the top of the window. -
How to Recover a Corrupt Excel File Picture 47
Select an Excel file. 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.
-
How to Recover a Corrupt Excel File Picture 48
Change the Excel file's extension. To do so:[2]- Click View
- Check the "File name extensions" box.
- Click Home
- Click Rename
- Replace the .tmp section with .xlsx
- Press ↵ Enter.
- Click Yes when prompted.
-
How to Recover a Corrupt Excel File Picture 49
Open the Excel file. Double-click the file that you just renamed to open it. -
How to Recover a Corrupt Excel File Picture 50
Save your file. 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.
Method 5 of 5:
Recovering a Temporary Save on Mac
-
How to Recover a Corrupt Excel File Picture 51
Understand the limitations of this method. 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. -
How to Recover a Corrupt Excel File Picture 52
Click Go. 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.
-
How to Recover a Corrupt Excel File Picture 53
Hold down the ⌥ Option key. After doing this, you should see the Library folder appear in the Go drop-down menu. -
How to Recover a Corrupt Excel File Picture 54
Click Library. It's in the Go drop-down menu. This will open the Library hidden folder. -
How to Recover a Corrupt Excel File Picture 55
Open the "Containers" folder. Double-click the "Containers" folder, which is in the "C" section of the Library folder. -
How to Recover a Corrupt Excel File Picture 56
Click the search bar. It's in the upper-right side of the window. -
How to Recover a Corrupt Excel File Picture 57
Search for the Microsoft Excel folder. Type in com.microsoft.Excel and press ⏎ Return. -
How to Recover a Corrupt Excel File Picture 58
Click the Containers tab. You'll find this to the right of the "Search:" heading near the top of the Finder window. -
How to Recover a Corrupt Excel File Picture 59
Open the "com.microsoft.Excel" folder. Double-click this folder to open it. -
How to Recover a Corrupt Excel File Picture 60
Open the "Data" folder. -
How to Recover a Corrupt Excel File Picture 61
Open the "Library" folder. -
How to Recover a Corrupt Excel File Picture 62
Open the "Preferences" folder. If you don't see this folder, scroll down to find it. -
How to Recover a Corrupt Excel File Picture 63
Open the "AutoRecovery" folder. This will bring up a list of automatically saved versions of your Excel files. -
How to Recover a Corrupt Excel File Picture 64
Find a temporary version of your Excel file. 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.
-
How to Recover a Corrupt Excel File Picture 65
Select the Excel file. Click the Excel file to do so. -
How to Recover a Corrupt Excel File Picture 66
Click File. It's a menu item in the upper-left corner of your Mac's screen. A drop-down menu will appear. -
How to Recover a Corrupt Excel File Picture 67
Select Open With. This option is near the top of the File drop-down menu. You should see a pop-out menu open. -
How to Recover a Corrupt Excel File Picture 68
Click Excel. 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.
-
How to Recover a Corrupt Excel File Picture 69
Save the document. Press ⌘ Command+S, then enter a file name, select a save location in the "Where" menu, and click Save.
4 ★ | 2 Vote
You should read it
- How to Insert Hyperlinks in Microsoft Excel
- How to Hide a File or Folder from Search Results in Microsoft Windows
- How to change the folder to save the default Excel file
- How to Zip Folder on Windows
- What is a folder The concept of a file (File) and a folder (Folder) in a computer
- How to Lock a Folder on Windows
- How to Zip a File in Windows
- How to Set Password for Folder and File in Windows
- Forgot password protected Excel file, what should you do?
- How to save files to multiple folders on the web browser
- How to Extract a Gz File
- Open the file, open the folder with a mouse click