How to Recover Corrupt Excel Files
Edit files
How to Recover Corrupt Excel Files Picture 1
You need to make sure you are using a Windows computer. We can only edit Excel files on Windows version of Excel.
If you are using a Mac computer, try the other methods mentioned in the article.
How to Recover Corrupt Excel Files Picture 2
Open Excel. The application has an icon with a green frame with a white "X".
How to Recover Corrupt Excel Files Picture 3
Click Open Other Workbooks . This option is next to the folder icon in the lower left corner of the window.
How to Recover Corrupt Excel Files Picture 4
Click Browse . This folder image option is in the middle of the page. The File Explorer window will open.
How to Recover Corrupt Excel Files Picture 5
Select Excel file. Access the folder containing the corrupted Excel file, then click to select the file.
How to Recover Corrupt Excel Files Picture 6
Click the down-arrow "Menu" icon to the right of the Open button . A drop-down menu will appear.
How to Recover Corrupt Excel Files Picture 7
Click Open and Repair… (Open and repair). This option is at the bottom of the drop-down menu.
If the Open and Repair. option is greyed out, make sure the Excel file is selected and try again. If it still doesn't work, you can't edit this file.
How to Recover Corrupt Excel Files Picture 8
Click Repair when the pop-up window appears. Windows will begin trying to repair the file.
If you don't see this option, click Extract Data , then click Convert to Values or Recover Formulas . Any salvageable data will be restored.
How to Recover Corrupt Excel Files Picture 9
Wait for the file to open. It will take a few minutes if the Excel file is large.
If the file still won't open, go back and click Extract Data instead of Repair when asked.
How to Recover Corrupt Excel Files Picture 10
Save the file. After the edited file opens, press Ctrl+ S, double-click This PC , select a save location, enter a name for the file, and then click Save .
You must choose a name different from the previously corrupted Excel file name.
Change file type on Windows
How to Recover Corrupt Excel Files Picture 11
You need to understand why the file type is important. Occasionally, an Excel document created on a computer or an older version of Excel may become unstable when you use it on the new version; Similarly, Excel documents can be saved in many different file formats. By changing the Excel file format to "xlsx" (or "xls" with older programs), you can fix the problem.
How to Recover Corrupt Excel Files Picture 12
Open Start . Click the Windows icon in the lower left corner of the screen.
How to Recover Corrupt Excel Files Picture 13
Open File Explorer. Click the folder icon in the bottom left of the Start window.
How to Recover Corrupt Excel Files Picture 14
Click the View tab. This option is at the top of the File Explorer window. A toolbar will appear immediately below.
How to Recover Corrupt Excel Files Picture 15
Check the "File name extensions" box. This option is in the "Show/hide" section of the toolbar. This allows you to see the extension at the end of file names, including Excel documents.
How to Recover Corrupt Excel Files Picture 16
Select Excel file. Go to the folder containing the Excel document you want to restore, then click the file to select it.
How to Recover Corrupt Excel Files Picture 17
Click Home . This tab is located in the upper left of the File Explorer window. A toolbar will appear.
How to Recover Corrupt Excel Files Picture 18
Click Rename . This option is in the "Organize" section of the toolbar. After you click Rename , the name of the Excel file will be highlighted.
How to Recover Corrupt Excel Files Picture 19
Change file type. Replace the suffix after the file name with xlsxthen press ↵ Enter.
For example, if the document name is "Spreadsheet1.docx", you would change it to "Spreadsheet1.xlsx".
If the file extension is originally "xlsx", try replacing it with "xls" or "html".
How to Recover Corrupt Excel Files Picture 20
Click Yes when asked. This will confirm and change the file extension.
How to Recover Corrupt Excel Files Picture 21
Try opening the file. Double click the file to open it. If the file opens in Excel (or in a web browser if you choose the "html" extension), the file has been fully restored.
If you choose the "html" extension, you can convert a web page into an Excel document by dragging the html file onto the Excel icon and then saving the opened document as a new "xlsx" file.
If the file still doesn't open, try restoring a temporary backup on Windows.
Change file types on Mac
How to Recover Corrupt Excel Files Picture 22
You need to understand why the file type is important. Occasionally, an Excel document created on a computer or an older version of Excel may become unstable when you use it on the new version; Similarly, Excel documents can be saved in many different file formats. By changing the Excel file format to "xlsx" (or "xls" with older programs), you can fix the problem.
How to Recover Corrupt Excel Files Picture 23
Open Finder. Click the blue face-shaped app icon in your Mac's Dock.
How to Recover Corrupt Excel Files Picture 24
Select Excel file. Go to the folder containing the Excel document you want to restore, then click the file to select it.
How to Recover Corrupt Excel Files Picture 25
Click File . This menu item is located in the upper left corner of your Mac computer screen. A drop-down menu will appear.
How to Recover Corrupt Excel Files Picture 26
Click Get Info . This option is in the File drop-down menu . A window will pop up.
How to Recover Corrupt Excel Files Picture 27
Expand the "Name & Extension" section if necessary. If you don't see any file names or extensions under this section, click the triangle to the left of the "Name & Extension" heading to see the file names and extensions.
How to Recover Corrupt Excel Files Picture 28
Change file type. Replace the suffix after the file name with xlsxthen press ⏎ Return.
For example, if the document name is "Spreadsheet1.docx", you would change it to "Spreadsheet1.xlsx".
If the file extension is originally "xlsx", try replacing it with "xls" or "html".
How to Recover Corrupt Excel Files Picture 29
Click Use .xlsx when asked. This will confirm and change the file extension.
How to Recover Corrupt Excel Files Picture 30
Try opening the file. Double click the file to open it. If the file opens in Excel (or in a web browser if you choose the "html" extension), the file has been fully restored.
If you choose the "html" extension, you can convert a web page into an Excel document by dragging the html file onto the Excel icon and then saving the opened document as a new "xlsx" file.
If the file still won't open, try restoring a temporary save on your Mac.
Restore temporary backup on Windows
How to Recover Corrupt Excel Files Picture 31
You need to understand the limitations of the method. Like most Microsoft Office products, Excel automatically saves a recovery version of the file, meaning you can partially restore a damaged version of an Excel document. However, Excel doesn't always save these files on time, and you won't be able to restore the entire document this way.
How to Recover Corrupt Excel Files Picture 32
Open Start . Click the Windows icon in the lower left corner of the screen.
How to Recover Corrupt Excel Files Picture 33
Type this pcto find the "This PC" program on your computer.
How to Recover Corrupt Excel Files Picture 34
Click This PC . This computer icon is at the top of the Start window. The This PC window will open.
How to Recover Corrupt Excel Files Picture 35
Double-click your computer's hard drive. This is usually the "OS (C:)" option under the "Devices and drives" heading in the middle of the page.
How to Recover Corrupt Excel Files Picture 36
Double-click the "Users" folder in the middle of your hard drive's folder.
How to Recover Corrupt Excel Files Picture 37
Double-click the user folder. This folder is partially or completely labeled by the user name on the computer.
How to Recover Corrupt Excel Files Picture 38
Double-click the "AppData" folder. Look for the folder in the "A" section near the top of the window.
If you cannot find this folder, you can click on the View tab , check the "Hidden items" box in the "Show/hide" section to make the "AppData" folder appear.
How to Recover Corrupt Excel Files Picture 39
Double-click the "Local" folder near the top.
How to Recover Corrupt Excel Files Picture 40
Scroll down to the "M" section and double-click the "Microsoft" folder.
How to Recover Corrupt Excel Files Picture 41
Double-click the "Office" folder located in the "O" section of the Microsoft folder.
How to Recover Corrupt Excel Files Picture 42
Double-click the "UnsavedFiles" folder. It's near the top of the window.
How to Recover Corrupt Excel Files Picture 43
Select Excel file. Find the Excel file icon with the same name as the corrupted Excel document, then click to select it.
If you don't see any files in this folder, the recovered version of the Excel document has not been saved.
How to Recover Corrupt Excel Files Picture 44
Change the Excel file extension. To proceed, you:
Click View
Check the "File name extensions" box.
Click Home
Click Rename
Replace the extension .tmpwith.xlsx
Press ↵ Enter.
Click Yes when asked.
How to Recover Corrupt Excel Files Picture 45
Open the Excel file. Double click to open the Excel file you just renamed.
How to Recover Corrupt Excel Files Picture 46
Save the file. After the restored file opens, press Ctrl+ S, double-click This PC , select a save location, enter a file name and then click Save .
You must choose a name different from the previously corrupted Excel file name.
Restore temporary backups on Mac
How to Recover Corrupt Excel Files Picture 47
You need to understand the limitations of the method. Like most Microsoft Office products, Excel automatically saves a recovery version of the file, meaning you can partially restore a damaged version of an Excel document. However, Excel doesn't always save these files on time, and you won't be able to restore the entire document this way.
How to Recover Corrupt Excel Files Picture 48
Click Go . This menu item is at the top of the screen. A drop-down menu will appear.
If you don't see the Go menu item , first open Finder or click on your desktop for the option to appear.
How to Recover Corrupt Excel Files Picture 49
Hold down the key ⌥ Option. The Library folder will then appear in the Go drop-down menu .
How to Recover Corrupt Excel Files Picture 50
Click Library from the Go drop-down menu . The hidden Library folder will appear.
How to Recover Corrupt Excel Files Picture 51
Open the "Containers" folder. Double-click the "Containers" folder located in the "C" section of the Library folder.
How to Recover Corrupt Excel Files Picture 52
Click the search bar in the top right of the window.
How to Recover Corrupt Excel Files Picture 53
Find the Microsoft Excel folder. Type com.microsoft.Exceland press ⏎ Return.
How to Recover Corrupt Excel Files Picture 54
Click the Containers tab to the right of the "Search:" heading near the top of the Finder window.
How to Recover Corrupt Excel Files Picture 55
Double-click the "com.microsoft.Excel" folder to open it.
How to Recover Corrupt Excel Files Picture 56
Open the "Data" folder.
How to Recover Corrupt Excel Files Picture 57
Open the "Library" folder.
How to Recover Corrupt Excel Files Picture 58
Open the "Preferences" folder. Scroll down to find it if you don't see this folder.
How to Recover Corrupt Excel Files Picture 59
Open the "AutoRecovery" folder. A list of automatically saved versions of the Excel file will appear.
How to Recover Corrupt Excel Files Picture 60
Find temporary versions of Excel files. The temporary version of the Excel file will contain part or all of the file name in the title.
If you can't find a temporary version of your Excel file, the document hasn't been backed up.
How to Recover Corrupt Excel Files Picture 61
Click to select the Excel file.
How to Recover Corrupt Excel Files Picture 62
Click File in the upper left corner of your Mac screen. A drop-down menu will appear.
How to Recover Corrupt Excel Files Picture 63
Select Open With . This option is near the top of the File drop-down menu . A menu will pop up.
How to Recover Corrupt Excel Files Picture 64
Click Excel in the pop-up menu. A temporary version of the Excel document opens in Excel.
The interim version may not include some recent changes in the original Excel document.
How to Recover Corrupt Excel Files Picture 65
Save document. Press ⌘ Command+ S, then enter a file name, select a save location in the "Where" menu, and then click Save .
You should read it
- How to recover files from a completely corrupted computer
- 10 ways to recover corrupted Excel files
- How to repair or restore corrupted PDF files
- Corrupted Excel file and the most effective way to recover Excel files!
- How to recover a corrupted or lost Word 2016 document
- Recover and repair corrupted Word files - Repair Doc files
- How to recover a corrupted zip file with ZIP Repair from DiskInternals
- Repair, decompress, restore data in corrupted rar archives, errors in 3 ways - 99% success
- The recover command in Windows
- How to retrieve unsaved Excel files, restore unsaved Excel files
- How to Recover a Corrupt Excel File
- How to Recover Data from Memory Cards