5 Ways to Recover Damaged Excel Files

Table of contents:

5 Ways to Recover Damaged Excel Files
5 Ways to Recover Damaged Excel Files

Video: 5 Ways to Recover Damaged Excel Files

Video: 5 Ways to Recover Damaged Excel Files
Video: Get Microsoft Office for free 2024, November
Anonim

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

Step

Method 1 of 5: Repairing Files

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

Step 1. Make sure you are using a Windows computer

You can only repair Excel files on Windows versions of Microsoft Excel.

If you're using a Mac, try one of the other methods in this article

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

Step 2. Open Excel

The program icon looks like a green box with an “X” in it.

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

Step 3. Click Open Other Workbooks

This option appears next to the folder icon in the lower-left corner of the window.

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

Step 4. Click Browse

This folder icon is in the middle of the page. After that, a File Explorer window will be opened.

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

Step 5. Select the desired Excel file

Go to the folder containing the corrupted Excel file, then click the file to select it.

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

Step 6. Click the "Menu" icon

Android7dropdown
Android7dropdown

This down arrow icon is to the right of the “ Open A drop-down menu will appear after that.

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

Step 7. Click Open and Repair…

It's at the bottom of the drop-down menu.

If the option " Open and Repair… ” cannot be selected (displayed in opaque color), make sure the Excel file is selected and try again. If it still cannot be selected, the file cannot be repaired.

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

Step 8. Click Repair when prompted

This option is in the pop-up window. Windows will try to repair the file.

If the option is not available, click “ Extract Data, then select " Convert to Values " or " Recover Formulas " The data that can still be saved will be recovered.

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

Step 9. Wait for the file to open

This process can take a few minutes if your Excel file is large enough.

If the file still can't be opened, repeat the process again and click “ Extract Data " (no " Repair ”) when prompted.

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

Step 10. Save the file

After the repaired file is opened, press Ctrl+S, double-click the option “ This PC ”, select a save location, enter a file name, and click “ Save ”.

Make sure you use a different file name than the corrupted Excel file name

Method 2 of 5: Changing File Types on a Windows Computer

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

Step 1. Understand the importance of file types

Sometimes an Excel document created on a computer or an earlier version of Excel becomes unstable when opened on a computer or a newer version of the Excel program. In addition, Excel documents can also be saved in a variety of file formats. By changing the Excel file format to "xlsx" (or "xls" for programs with earlier versions), the problem of file corruption can be resolved.

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

Step 2. Open the “Start” menu

Windowsstart
Windowsstart

Click the Windows logo in the lower-left corner of the screen.

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

Step 3. Open the File Explorer program

Windowsstartexplorer
Windowsstartexplorer

Click the folder icon that appears in the lower-left corner of the “Start” window.

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

Step 4. Click the View tab

This tab is at the top of the File Explorer window. The toolbar will appear below this tab.

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

Step 5. Check the "File name extensions" box

This box is in the "Show/hide" toolbar section. After that, you can see the file type extension at the end of the file name, including the Excel document file.

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

Step 6. Select the Excel file

Go to the directory where the Excel file you want to recover, then click the document to select it.

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

Step 7. Click Home

It's a tab in the upper-left corner of the File Explorer window. The toolbar will be displayed afterwards.

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

Step 8. Click Rename

This option is in the " Organize " toolbar section. Once clicked, the Excel file name will be marked.

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

Step 9. Change the file type

Replace the extension that appears after the period at the end of the name with xlsx, then press Enter.

  • For example, if the document is named "Spreadsheet1.docx", change it to "Spreadsheet1.xlsx".
  • If the file already has an "xlsx" extension, try using "xls" or "html".
Recover a Corrupt Excel File Step 20
Recover a Corrupt Excel File Step 20

Step 10. Click Yes when prompted

The changes will be confirmed and the file extension will be changed.

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

Step 11. Try opening the file

Double-click the file to open it. If the file can be opened in (or a web browser if you chose "html" as the extension), the file has been successfully restored.

  • If you select the "html" extension, you can convert a web page into an Excel document by dragging the "html" file onto the Excel program icon, and saving the opened file as a new "xlsx" file.
  • If the file still won't open, move on to the next Windows method.

Method 3 of 5: Changing File Types on Mac Computer

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 the importance of file types

Sometimes an Excel document created on a computer or an earlier version of Excel becomes unstable when opened on a computer or a newer version of the Excel program. In addition, Excel documents can also be saved in a variety of file formats. By changing the Excel file format to "xlsx" (or "xls" for programs with earlier versions), the problem of file corruption can be resolved.

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

Step 2. Open Finder

Click the blue face icon that appears in your computer's Dock.

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

Step 3. Select the Excel file

Go to the folder where the Excel file is stored, then click the file that you want to recover.

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

Step 4. Click File

This menu option is in the upper-left corner of your computer screen. Once clicked, a drop-down menu will appear.

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

Step 5. Click Get Info

This option is in the drop-down menu “ File A pop-up window will open afterwards.

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

Step 6. Expand the "Name & Extension" segment if necessary

If you don't see a file name or extension under this category, click the triangle icon to the left of the " Name & Extension " heading to see the file name and extension.

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

Step 7. Change the file type

Replace the extension that appears after the period at the end of the file name with xlsx, then press Return.

  • For example, if the document is named "Spreadsheet1.txt", change it to "Spreadsheet1.xlsx".
  • If the file already has an "xlsx" extension, try using an "xls" or "html" extension.
Recover a Corrupt Excel File Step 29
Recover a Corrupt Excel File Step 29

Step 8. Click Use.xlsx when prompted

The selection will be confirmed and the file type will be changed.

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

Step 9. Try opening the file

Double-click the file to open it. If the file can be opened in Excel (or a web browser if you chose the "html" extension), the file has been successfully recovered.

  • If you choose the "html" extension, you can convert a web page to an Excel document by dragging the "html" file onto the Excel program icon, then saving the opened file as a new "xlsx" file.
  • If the file still won't open, move on to the next Mac method.

Method 4 of 5: Recovering Temporary Saved Files on Windows Computer

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

Step 1. Understand the limitations of this method

Like most Microsoft Office products, Microsoft Excel will automatically save the recovery version of the file. This means that you can restore part of the data or part of the corrupted Excel document. However, Excel doesn't always save the files on time and it's possible that you won't be able to recover the entire document this way.

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

Step 2. Open the “Start” menu

Windowsstart
Windowsstart

Click the Windows logo in the lower-left corner of the screen.

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

Step 3. Type this pc

After that, the computer will search for the program "This PC".

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

Step 4. Click This PC

It's a computer monitor icon at the top of the "Start" window. After that, the “This PC” window will be displayed.

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

Step 5. Double-click the computer hard drive

It's usually labeled "OS (C:)" and appears under the "Devices and drives" heading in the middle of the page.

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

Step 6. Double click the “Users” folder

This folder is in the middle of the hard drive folder.

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

Step 7. Double click the user folder

This folder is named after part or all of your username on the computer.

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

Step 8. Double click the “AppData” folder

This folder is in the "A" section so there's a good chance you'll find it at the top of the file browsing window.

If the folder cannot be found, click the tab “ View ”, then check the box " Hidden items " in the " Show/hide " segment to display the " AppData " folder.

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

Step 9. Double click the “Local” folder

This option is at the top of the folder.

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

Step 10. Scroll down and double click the “Microsoft” folder

This folder is in the "M" segment.

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

Step 11. Double-click the "Office" folder

This folder is in the “O” section of the “Microsoft” folder.

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

Step 12. Double click the “UnsavedFiles” folder

This folder is at the top of the window.

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

Step 13. Select the Excel file

Look for the Excel file icon with the same name as the corrupted Excel file, then click on the file to select it.

If you don't see any files, the recovery version of the Excel document is not saved

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

Step 14. Change the Excel file extension

To change it:

  • Click " View ”.
  • Check the "File name extensions" box.
  • Click " Home ”.
  • Click " Rename ”.
  • Replace the.tmp extension with.xlsx.
  • Press the Enter key.
  • Click " Yes ' when prompted.
Recover a Corrupt Excel File Step 45
Recover a Corrupt Excel File Step 45

Step 15. Open the Excel file

Double-click the recently renamed file to open it.

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

Step 16. Save the file

After the recovered files are opened, press the Ctrl+S key combination, double-click the “ This PC ”, select a storage directory, enter a file name, and click the “ Save ”.

Make sure you select a different file name than the name previously used for the corrupted Excel file

Method 5 of 5: Recovering Temporary Saved Files on Mac Computer

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

Step 1. Understand the limitations of this method

Like most Microsoft Office products, Microsoft Excel will automatically save the recovery version of the file. This means that you can restore part of the data or part of the corrupted Excel document. However, Excel doesn't always save the files on time and it's possible that you won't be able to recover the entire document this way.

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

Step 2. Click Go

This menu option is at the top of the screen. Once clicked, a drop-down menu will open.

If you don't see the option " Go ”, open Finder or first click on the desktop for options to appear.

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

Step 3. Hold down the Option key

After that, you can see the folder " Library " in the drop-down menu " Go ”.

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

Step 4. Click Library

This option is in the drop-down menu “ Go " Folders " Library ” hidden will be shown.

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

Step 5. Open the "Containers" folder

Double-click the "Containers" folder which is in the "C" section of the "Library" folder.

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

Step 6. Click the search bar

It's in the upper-right corner of the window.

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

Step 7. Locate the “Microsoft Excel” folder

Type com.microsoft.excel and press Return.

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

Step 8. Click the Containers tab

This tab is to the right of the " Search: " heading at the top of the Finder window.

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

Step 9. Open the “com.microsoft.excel” folder

Double-click the folder to open it.

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

Step 10. Open the “Data” folder

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

Step 11. Open the "Library" folder

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

Step 12. Open the “Preferences” folder

If you don't see this folder, swipe until you find it.

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

Step 13. Open the "AutoRecovery" folder

A list of saved versions of the Excel file will automatically be displayed.

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

Step 14. Look for a temporary version of the corrupted Excel file

Temporary versions of files contain part or all of the file name in the title.

If you can't find a temporary version of the file you want, it hasn't been automatically backed up by Microsoft Excel

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

Step 15. Select the Excel file

Click the file to select it.

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

Step 16. Click File

This menu option is in the upper-left corner of your computer screen. A drop-down menu will appear after that.

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

Step 17. Select Open With

It's at the top of the drop-down menu " File " A pop-out menu will appear after that.

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

Step 18. Click Excel

It's in the pop-out menu. A temporary version of the document will open in Microsoft Excel.

This temporary version may not contain some of the recent changes that you previously made to the original Excel document

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

Step 19. Save the document

Press the Command+S key combination, enter a file name, select a storage location on the " Where " menu, and click “ Save ”.

Tips

  • Windows computers usually try to repair corrupted Excel worksheets automatically when you open them.
  • You can open corrupted Excel files by enabling safe mode on your computer. If the document can be opened in that mode, a file error or virus may be the cause of the file not opening normally.
  • There are several paid data recovery programs that can be used to recover corrupted Excel files. Stellar Phoenix Excel Repair is one such example and is available for Windows and Mac computers.

Recommended: