Recover a Deleted Sheet in Google Sheets

Accidentally deleting a worksheet, or tab, inside a Google Sheets spreadsheet can be frustrating, especially when that sheet contains important data. Fortunately, deleting a sheet tab does not necessarily mean that the information is permanently lost. In many cases, you can use Google Sheets version history to restore the spreadsheet to a previous state or copy the deleted sheet’s data back into the current version.

It is important to understand that a deleted sheet tab is different from a deleted Google Sheets file. If you deleted the entire spreadsheet from Google Drive, you need to recover the file from the Trash instead. This guide focuses specifically on recovering a sheet tab that was deleted from an existing spreadsheet.

Let’s explore the steps in detail!

How to Recover a Deleted Sheet in Google Sheets?

You can recover a deleted sheet in Google Sheets by opening the spreadsheet’s Version history, finding a version from before the sheet was deleted, and restoring that version or copying the missing sheet’s contents into the current spreadsheet. Google Sheets automatically saves changes, making version history particularly useful when you accidentally remove a worksheet.

Before restoring anything, check the available versions carefully. Restoring an older version can also undo other changes made after that version, so copying the deleted sheet into the current spreadsheet is often the safer option when you want to preserve recent work.

Step 1: Open the Google Sheets File

First, open the Google Sheets spreadsheet that contained the deleted sheet.

Go to Google Sheets and sign in to the Google Account that has access to the spreadsheet. Find the file containing the missing sheet and open it.

Once the spreadsheet opens, look at the bottom of the screen where the sheet tabs normally appear. You may see tabs such as Sheet1, Sales, Expenses, or January. If the sheet you deleted is no longer there, do not make additional unnecessary changes to the spreadsheet while you are trying to recover it.

It is also a good idea to confirm that you have Editor access to the spreadsheet. Version history and restoration options may depend on your permissions and the type of Google account or file you are using.

Step 2: Open Version History

After opening the spreadsheet, use Version history to look for an earlier version of the file.

Click File in the top-left corner of Google Sheets. Move your mouse over Version history, and then select See version history.

You can also use the keyboard shortcut Ctrl + Alt + Shift + H on Windows or ChromeOS. On a Mac, the corresponding shortcut is Command + Option + Shift + H.

Google Sheets will open the version history panel. You will see different saved versions of the spreadsheet organized by date and time.

Do not worry if you have never used this feature before. You are essentially looking for a snapshot of the spreadsheet from before you deleted the sheet tab.

Step 3: Find a Version From Before the Sheet Was Deleted

Now you need to identify the correct version.

Look through the dates and times shown in the Version history panel. Think about when you noticed that the sheet was missing. For example, if you accidentally deleted the Expenses sheet at 10:30 AM, look for a version created before 10:30 AM.

Click an earlier version to preview it.

Google Sheets will display what the spreadsheet looked like at that point in time. Check the bottom of the spreadsheet and see whether the deleted sheet tab appears in that version.

If the missing tab is visible, you have found a version that contains the sheet you want to recover.

If it is not there, select another earlier version and check again. Continue moving backward until you find the most recent version where the deleted sheet still exists.

Step 4: Check the Deleted Sheet Before Restoring Anything

Once you find a version containing your missing sheet, take a moment to inspect it.

Click the recovered version’s sheet tab and check whether the data, formulas, formatting, charts, and other information you need are present.

This step is important because you may have made other changes to the spreadsheet after deleting the sheet. An older version could contain the missing sheet but might not include your latest work.

For example, suppose you deleted the January Sales sheet yesterday but made several important changes to the February Sales sheet afterward. Restoring yesterday’s version could bring back January Sales while removing those newer February changes.

Because of this, you should consider copying the deleted sheet rather than immediately restoring the entire spreadsheet.

Step 5: Copy the Recovered Sheet Into the Current Spreadsheet

If you want to keep your latest changes, copying the recovered sheet into the current spreadsheet is often the better approach.

Open the version containing the deleted sheet. At the bottom, right-click the recovered sheet tab.

Look for an option such as Copy to and choose the option that lets you copy the sheet to an existing spreadsheet. Select the current spreadsheet you are working with.

Google Sheets will create a copy of that sheet in the selected spreadsheet.

Return to your current spreadsheet and check the bottom sheet tabs. The recovered sheet should now appear as a new tab.

This method is useful because you can recover the missing sheet without replacing the entire spreadsheet with an older version.

Depending on the spreadsheet’s contents and permissions, some linked references, formulas, or connections may need additional checking after copying.

Step 6: Restore the Older Version If Necessary

If copying the sheet is not practical, you can restore the entire spreadsheet to the earlier version.

While viewing the appropriate version in Version history, click Restore this version.

Google Sheets will ask you to confirm the restoration. Carefully check the date and time before confirming.

Once restored, the spreadsheet will return to the state represented by that version. The deleted sheet should reappear.

Remember that this does not simply bring back one sheet. It changes the spreadsheet to an older saved state, so changes made after that version may no longer be reflected in the current version.

For that reason, consider making a copy of the current spreadsheet before performing a full restoration if you have important recent work that you do not want to risk losing.

Step 7: Check the Recovered Sheet

After recovering the sheet, carefully check the contents.

Look through the cells, formulas, formatting, charts, images, filters, and other elements that were present on the deleted sheet.

If the sheet contains formulas that refer to other worksheets, verify that those references still work correctly. You should also check whether any external data sources or linked information continue to update properly.

If you copied the sheet from an older version, give it a recognizable name. For example, if Google Sheets created a duplicate called Expenses copy, you could rename it to Expenses Recovered and then compare it with your current spreadsheet.

Once you have confirmed that the necessary information is present, you can decide whether to keep the recovered copy or rename it to the original sheet name.

Check Google Drive Trash If the Entire File Was Deleted

If you cannot find the spreadsheet itself, the problem may be different.

You may have accidentally deleted the entire Google Sheets file rather than just one sheet tab. In that situation, open Google Drive and go to Trash.

Find the deleted spreadsheet, right-click it, and select Restore if the option is available.

After the file is restored, open it and check whether the missing sheet is inside it.

This method is different from using Version history because Version history is used to recover previous states of an existing spreadsheet, while Google Drive Trash is used to recover a deleted file.

Verify That the Recovery Is Complete

After recovering the sheet, do not immediately assume everything has been restored perfectly.

Compare the recovered sheet with any available copies, exported files, or related records you may have. Check important formulas and make sure the information you expected to recover is present.

If the sheet was used by other people, also check whether its permissions and sharing behavior are correct.

Once you are satisfied, continue working normally. Google Sheets will automatically save your subsequent changes.

Faqs

Can I recover a deleted sheet in Google Sheets?

Yes, you can often recover a deleted sheet using Version history. Find a version of the spreadsheet from before the sheet was deleted, then either copy the sheet into the current spreadsheet or restore the older version.

Can I recover only the deleted sheet instead of the whole spreadsheet?

Yes. If possible, use an earlier version to copy the deleted sheet into your current spreadsheet. This is generally preferable when you have made other changes since the sheet was deleted.

Does Google Sheets automatically save deleted sheets?

Google Sheets automatically saves changes to your spreadsheet, and Version history can preserve earlier versions. However, the exact availability of version history can depend on the account, file type, ownership, and other factors.

What if I cannot find the deleted sheet in Version history?

Try checking versions from further back in time. The sheet may have been deleted earlier than you initially thought.

If no suitable version exists, check whether you have another copy of the spreadsheet, an exported Excel file, or another backup containing the missing information.

Will restoring an old version delete my newer changes?

Restoring an older version changes the spreadsheet back to that previous state. Therefore, changes made after that version may no longer appear in the restored spreadsheet.

If you want to preserve newer work, consider copying the deleted sheet from the older version instead of restoring the entire spreadsheet.

Can I recover a sheet after closing Google Sheets?

Yes, closing the browser does not necessarily prevent recovery. Google Sheets saves changes automatically, so you can reopen the spreadsheet and check Version history for an earlier version.

Can I recover a deleted sheet from Google Drive Trash?

Usually, Google Drive Trash is relevant when the entire spreadsheet file was deleted. If only a sheet tab was removed from a spreadsheet, use Version history instead.

Is there an Undo option for a deleted sheet?

If you have just deleted the sheet, you may be able to use Undo immediately. However, if you have closed the spreadsheet, continued working, or returned later, Version history is usually the more useful recovery method.

What should I do after recovering the deleted sheet?

Check the recovered sheet carefully. Verify its data, formulas, formatting, charts, and references. If you copied it from an older version, compare it with your current spreadsheet before replacing or renaming any existing tabs.

Summary

Accidentally deleting a sheet in Google Sheets does not always mean that the data is permanently gone. The most useful recovery method is to open Version history and locate a version from before the sheet was deleted.

If you want to preserve newer changes, try copying the missing sheet from the older version into your current spreadsheet. If you need to return the entire spreadsheet to an earlier state, you can use Restore this version, but make sure you understand that this may affect changes made afterward.

If the entire spreadsheet was deleted rather than just one sheet tab, check Google Drive Trash and restore the file.