5 Ways to Recover a Corrupted Excel File

Table of contents:

5 Ways to Recover a Corrupted Excel File
5 Ways to Recover a Corrupted Excel File
Anonim

This article explains how you can recover and repair a damaged or corrupted Excel file. You can perform this procedure on both Windows and Mac systems. Read on to find out how.

Steps

Method 1 of 5: Repair a Damaged File

Play DVDs on Windows Media Player Step 7
Play DVDs on Windows Media Player Step 7

Step 1. Use a computer with a Windows operating system

Unfortunately, the procedure for repairing a corrupt Excel file is only possible with the version of Excel for Windows systems.

If you are using a Mac, try referring to one of the other methods described in the article

Recover a Corrupt Excel File Step 2
Recover a Corrupt Excel File Step 2

Step 2. Launch the Excel application

It features a green icon with a white "X" inside.

Recover a Corrupt Excel File Step 3
Recover a Corrupt Excel File Step 3

Step 3. Choose the Open Other Workbooks option

It is located next to a folder icon in the lower left of the program window.

Recover a Corrupt Excel File Step 4
Recover a Corrupt Excel File Step 4

Step 4. Press the Browse button

It features a folder icon in the center of the page. This will bring up the "File Explorer" system window.

Recover a Corrupt Excel File Step 5
Recover a Corrupt Excel File Step 5

Step 5. Select the Excel file to be processed

Navigate to the folder where the corrupt file to be recovered is stored, then select it with the mouse to highlight it.

Recover a Corrupt Excel File Step 6
Recover a Corrupt Excel File Step 6

Step 6. Press the "Menu" button by clicking the icon

Android7dropdown
Android7dropdown

It features a black down arrow to the right of the button Open. A small drop-down menu will appear.

Recover a Corrupt Excel File Step 7
Recover a Corrupt Excel File Step 7

Step 7. Choose the Open and Repair… option

It is one of the last items on the menu starting from the top.

If the function Open and restore … appears grayed out (i.e. not selectable), make sure the Excel file is selected, then try again. If the indicated option is still not usable, it means that the chosen file cannot be restored.

Recover a Corrupt Excel File Step 8
Recover a Corrupt Excel File Step 8

Step 8. When prompted, press the Reset button visible within the pop-up window that appeared

The Windows operating system will try to restore access to the indicated file.

If the option in question is not available, press the button Extract data, then choose the item Convert to values or Retrieve formulas. In this way all the data still available in the indicated file will be extracted and recovered.

Recover a Corrupt Excel File Step 9
Recover a Corrupt Excel File Step 9

Step 9. Wait for the file to open

This step may take several minutes to complete, especially if there is a lot of data in the file.

If you still cannot access the selected file, repeat the restore procedure but choose the option when prompted Extract data rather than Reset.

Recover a Corrupt Excel File Step 10
Recover a Corrupt Excel File Step 10

Step 10. Save the file

When data access has been restored, then the contents of the file are visible within Excel, press the key combination Ctrl + S, select the item This PC with a double click of the mouse, choose the destination folder, assign a new name to the document in question and finally press the button Save.

Make sure you give the new file a different name than the original damaged one so that you can make a copy of it

Method 2 of 5: Change the File Type on Windows Systems

Convert CSV to XLS Step 5
Convert CSV to XLS Step 5

Step 1. Understand why this method works in some cases

Sometimes Excel files that are created on older computers or using an older version of the program are not perfectly compatible with new versions of the spreadsheet produced by Microsoft. However, Excel files can be saved in many different formats. For this reason, changing the format of the corrupt file to "XLSX" (or "XLS" in the case of an older version of Excel) may solve the problem automatically.

Recover a Corrupt Excel File Step 12
Recover a Corrupt Excel File Step 12

Step 2. Access the "Start" menu by clicking the icon

Windowsstart
Windowsstart

It features the Windows logo and is located in the lower left corner of the desktop.

Recover a Corrupt Excel File Step 13
Recover a Corrupt Excel File Step 13

Step 3. Open a new "File Explorer" window by clicking the icon

Windowsstartexplorer
Windowsstartexplorer

It features a small folder and is located at the bottom left of the "Start" menu.

Recover a Corrupt Excel File Step 14
Recover a Corrupt Excel File Step 14

Step 4. Go to the View tab of the ribbon

It is located at the top of the "File Explorer" window. Its toolbar will appear.

Recover a Corrupt Excel File Step 15
Recover a Corrupt Excel File Step 15

Step 5. Select the "File Name Extensions" checkbox

It is visible within the group called "Show / Hide" of the toolbar. This way the file extension (including Excel documents) will be visible and can be changed manually.

Recover a Corrupt Excel File Step 16
Recover a Corrupt Excel File Step 16

Step 6. Select the file in question

Navigate to the folder where the Excel document to be repaired is stored, then select it with the mouse to highlight it.

Recover a Corrupt Excel File Step 17
Recover a Corrupt Excel File Step 17

Step 7. Go to the Home tab

It is located in the upper left of the "File Explorer" window. A new toolbar will appear, different from the previous one.

Recover a Corrupt Excel File Step 18
Recover a Corrupt Excel File Step 18

Step 8. Press the Rename button

It is located within the "Organize" group. This way you will be able to change the name and extension of the currently selected file.

Recover a Corrupt Excel File Step 19
Recover a Corrupt Excel File Step 19

Step 9. Change the document type

Simply replace the current extension, i.e. the portion of text on the right of the dot, with the suffix xlsx, then press the Enter key.

  • For example, if the actual file name is "Sheet1.docx", after the change it should be "Sheet1.xlsx".
  • If the file extension is already "xlsx", try changing it to "xls" or "html".
Recover a Corrupt Excel File Step 20
Recover a Corrupt Excel File Step 20

Step 10. When prompted, press the Yes button

This will confirm your willingness to change the extension of the file in question.

Recover a Corrupt Excel File Step 21
Recover a Corrupt Excel File Step 21

Step 11. Try to access the contents of the file

Double-click it to open it automatically with the default program. If the file is opened using Excel (or the internet browser if you chose the "html" extension), it means that the recovery procedure was successful and you will be able to recover its contents.

  • If you have chosen to use the "html" extension, you have the possibility to convert the appeared web page into an Excel document by simply dragging the file in HTML format into the window or onto the Microsoft program icon and then saving the new document in "xlsx" format.
  • If the file doesn't open, try using this Windows-only method.

Method 3 of 5: Change the File Type on Mac

Save a. Xlsx Document on Google Sheets on Android Step 6
Save a. Xlsx Document on Google Sheets on Android Step 6

Step 1. Understand why this method works in some cases

Sometimes Excel files that are created on older computers or using an older version of the program are not perfectly compatible with new versions of the spreadsheet produced by Microsoft. However, Excel files can be saved in many different formats. For this reason, changing the format of the corrupt file to "xlsx" (or "xls" in the case of an older version of Excel) may solve the problem automatically.

Recover a Corrupt Excel File Step 23
Recover a Corrupt Excel File Step 23

Step 2. Open a Finder window

Click the blue stylized face icon visible within the System Dock.

Recover a Corrupt Excel File Step 24
Recover a Corrupt Excel File Step 24

Step 3. Select the file to edit

Navigate to the folder where the Excel document to be repaired is stored, then select it with the mouse to highlight it.

Recover a Corrupt Excel File Step 25
Recover a Corrupt Excel File Step 25

Step 4. Access the File menu

It is located in the upper left corner of the screen. A small drop-down menu will appear.

Recover a Corrupt Excel File Step 26
Recover a Corrupt Excel File Step 26

Step 5. Choose the Get Info option

It is one of the items on the menu File appeared; a dialog box will appear.

Recover a Corrupt Excel File Step 27
Recover a Corrupt Excel File Step 27

Step 6. If necessary, expand the "Name and extension" section

If you don't see any information under this heading, click the right-facing triangle icon on the left of the "Name and Extension" section to expand it.

Recover a Corrupt Excel File Step 28
Recover a Corrupt Excel File Step 28

Step 7. Change the file format

Simply replace the current extension, i.e. the portion of text on the right of the dot, with the suffix xlsx, then press the Enter key.

  • For example, if the actual file name is "Sheet1.docx", after the modification it must be "Sheet1.xlsx".
  • If the file extension is already "xlsx", try changing it to "xls" or "html".
Recover a Corrupt Excel File Step 29
Recover a Corrupt Excel File Step 29

Step 8. When prompted, press the Use.xlsx button

In this way you will confirm the willingness to change the extension of the file in question.

Recover a Corrupt Excel File Step 30
Recover a Corrupt Excel File Step 30

Step 9. Try to access the contents of the file

Double-click it to open it automatically with the default program. If the file is opened using Excel (or the internet browser if you chose the "html" extension), it means that the recovery procedure was successful and you will be able to recover its contents.

  • If you have chosen to use the "html" extension, you have the possibility to convert the appeared web page into an Excel document by simply dragging the file in HTML format into the window or onto the Microsoft program icon and then saving the new document in "XLSX" format.
  • If the file doesn't open, try using this Apple-only method.

Method 4 of 5: Restore a Temporary File on Windows Systems

Recover a Corrupt Excel File Step 31
Recover a Corrupt Excel File Step 31

Step 1. Understand the operational limitations of this method

Like most of the products included in the Microsoft Office suite, Excel automatically creates a temporary version of its files for use in the event of a restore. This means that you may have a chance to recover a partial version of the corrupt Excel document. However Excel does not create these temporary files in real time, so most likely using this method you will be able to recover only a partial version of the document.

Recover a Corrupt Excel File Step 32
Recover a Corrupt Excel File Step 32

Step 2. Access the "Start" menu by clicking the icon

Windowsstart
Windowsstart

It features the Windows logo and is located in the lower left corner of the desktop.

Recover a Corrupt Excel File Step 33
Recover a Corrupt Excel File Step 33

Step 3. Type keywords this pc

Your computer will search for the Windows "This PC" program.

Recover a Corrupt Excel File Step 34
Recover a Corrupt Excel File Step 34

Step 4. Select the This PC icon

It features a computer monitor and is displayed at the top of the "Start" menu. This will bring up the "This PC" window.

Recover a Corrupt Excel File Step 35
Recover a Corrupt Excel File Step 35

Step 5. Double-click the icon for the system hard drive

It is normally identified by the wording "(C:)" together with the name of the computer manufacturer and is visible in the "Devices and drives" section located in the center of the window.

Recover a Corrupt Excel File Step 36
Recover a Corrupt Excel File Step 36

Step 6. Double click on the "Users" folder

You'll find it at the bottom of the list of all files and folders on your computer's hard drive.

Recover a Corrupt Excel File Step 37
Recover a Corrupt Excel File Step 37

Step 7. Double click on your user folder

This is the directory where all information relating to the user account you are using is stored and should be identified by a portion or the entire name you have assigned to your user profile.

Recover a Corrupt Excel File Step 38
Recover a Corrupt Excel File Step 38

Step 8. Go to the "AppData" folder

The list should be sorted alphabetically, so the indicated folder will be visible at the top of the list within the section for the letter "A".

If the directory in question is not visible, go to the tab View on the ribbon, then select the "Hidden Items" checkbox located within the "Show / Hide" group. This way the "AppData" folder should appear in the content list.

Recover a Corrupt Excel File Step 39
Recover a Corrupt Excel File Step 39

Step 9. Go to the "Local" folder

It is visible at the top of the window.

Recover a Corrupt Excel File Step 40
Recover a Corrupt Excel File Step 40

Step 10. Scroll through the newly appeared list to locate and select the "Microsoft" entry

You will find it in the section relating to the letter "M" of the list.

Recover a Corrupt Excel File Step 41
Recover a Corrupt Excel File Step 41

Step 11. Go to the "Office" folder

Since the list is sorted alphabetically, find the section for the letter "O".

Recover a Corrupt Excel File Step 42
Recover a Corrupt Excel File Step 42

Step 12. Go to the "UnsavedFiles" directory

It should be visible at the top of the window.

Recover a Corrupt Excel File Step 43
Recover a Corrupt Excel File Step 43

Step 13. Select an Excel file

Locate the icon of a document created with Microsoft Excel whose name matches that of the corrupt or damaged file. At this point click it with the mouse to select it.

If there is no Excel document inside the indicated folder, it means that no recovery version of the file in question has been created

Recover a Corrupt Excel File Step 44
Recover a Corrupt Excel File Step 44

Step 14. Change the extension of the detected Excel document

Follow these simple instructions:

  • Access the card View.
  • Select the "Filename extensions" checkbox.
  • Access the card Home.
  • Push the button Rename.
  • Replace the.tmp suffix with the.xlsx extension.
  • Press the Inivio key.
  • When prompted, press the button Yup.
Recover a Corrupt Excel File Step 45
Recover a Corrupt Excel File Step 45

Step 15. Access the contents of the newly renamed Excel file

Double-click its icon to open it.

Recover a Corrupt Excel File Step 46
Recover a Corrupt Excel File Step 46

Step 16. Save the file

When the file you just restored opens successfully, press the key combination Ctrl + S, select the item This PC with a double click of the mouse, choose the destination folder, assign a new name to the document in question and finally press the button Save.

Make sure you give the new file a different name than the original damaged one, so that you can create a new copy

Method 5 of 5: Restore a Temp File on Mac

Recover a Corrupt Excel File Step 47
Recover a Corrupt Excel File Step 47

Step 1. Understand the operational limitations of this method

Like most of the products included in the Microsoft Office suite, Excel automatically creates a temporary version of its files for use in the event of a restore. This means that you may have a chance to recover a partial version of the corrupt Excel document. However the program does not create these temporary files in real time, so most likely using this method you will be able to recover only a partial version of the document.

Recover a Corrupt Excel File Step 48
Recover a Corrupt Excel File Step 48

Step 2. Enter the Go menu

It's one of the options in the Mac menu bar at the top of the screen. A new drop-down menu will appear.

If the menu Go is not visible, you will first have to open a Finder window or click an empty spot on the desktop to make it appear.

Recover a Corrupt Excel File Step 49
Recover a Corrupt Excel File Step 49

Step 3. Press and hold the special ⌥ Option key

Like this within the menu Go the entry should appear Bookshelf.

Recover a Corrupt Excel File Step 50
Recover a Corrupt Excel File Step 50

Step 4. Select the Library option

It is one of the items on the drop-down menu Go. This way you will have access to the system folder Bookshelf which is normally hidden.

Recover a Corrupt Excel File Step 51
Recover a Corrupt Excel File Step 51

Step 5. Go to the "Containers" directory

Select it with a double click of the mouse. It is listed in the "C" section of the "Library" folder contents list.

Recover a Corrupt Excel File Step 52
Recover a Corrupt Excel File Step 52

Step 6. Select the search bar

It is located in the upper right part of the window.

Recover a Corrupt Excel File Step 53
Recover a Corrupt Excel File Step 53

Step 7. Search the "Microsoft Excel" folder

Type in the keywords com.microsoft. Excel and press the Enter key.

Recover a Corrupt Excel File Step 54
Recover a Corrupt Excel File Step 54

Step 8. Select the Containers entry

It is located to the right of the "Look in:" header at the top of the Finder window.

Recover a Corrupt Excel File Step 55
Recover a Corrupt Excel File Step 55

Step 9. Go to the "com.microsoft. Excel" folder

Simply select it with a double click of the mouse.

Recover a Corrupt Excel File Step 56
Recover a Corrupt Excel File Step 56

Step 10. Open the "Data" directory

Recover a Corrupt Excel File Step 57
Recover a Corrupt Excel File Step 57

Step 11. Go to the "Library" folder

Recover a Corrupt Excel File Step 58
Recover a Corrupt Excel File Step 58

Step 12. Open the "Preferences" directory

If this item is not visible, scroll up or down the list to locate it.

Recover a Corrupt Excel File Step 59
Recover a Corrupt Excel File Step 59

Step 13. Navigate to the "AutoRecovery" folder

It contains the list of all recovery files that Excel created automatically while you were working on your documents.

Recover a Corrupt Excel File Step 60
Recover a Corrupt Excel File Step 60

Step 14. Locate the recovery version of the Excel file of interest to you

It should have the same name (or a portion of it) as the corrupt file you are trying to recover.

If there is no Excel document inside the indicated folder, it means that no recovery version of the file in question has been created

Recover a Corrupt Excel File Step 61
Recover a Corrupt Excel File Step 61

Step 15. Select the desired Excel document

Click the relevant icon with the mouse.

Recover a Corrupt Excel File Step 62
Recover a Corrupt Excel File Step 62

Step 16. Access the File menu

It is located in the upper left corner of the Mac screen. A drop-down menu will appear.

Recover a Corrupt Excel File Step 63
Recover a Corrupt Excel File Step 63

Step 17. Choose the Open With option

It is one of the items at the top of the drop-down menu File. You will see a secondary menu appear.

Recover a Corrupt Excel File Step 64
Recover a Corrupt Excel File Step 64

Step 18. Choose the Excel entry

It is visible within the newly appeared submenu. The temporary version of the corrupt Excel file will be opened within the chosen program window.

This version of the original file will most likely not include all the most recent data changes you made on the original document

Recover a Corrupt Excel File Step 65
Recover a Corrupt Excel File Step 65

Step 19. Save the new file

Press the key combination ⌘ Command + S, name the file, select a destination folder using the "Located in:" drop-down menu and press the button Save.

Advice

  • Often the Windows operating system will try to automatically repair the Excel file upon opening.
  • In some cases you may be able to access the data contained in a corrupt Excel file by booting the system in safe mode. If doing this solves the problem, it means that the cause was most likely a virus or an error in the file.
  • To try to recover the data present in a damaged Excel file there are several paid tools. Stellar Phoenix Excel Repair, available for both Windows and Mac systems, is a great example of this type of program.

Recommended: