In this article:

How to Recover Deleted Google Sheets (Easiest Way in 2024)

May 8, 2024

How to Recover a Deleted Google Sheets File

Follow the steps below to recover a deleted Google Sheets file from Google Drive’s trash bin. 

1. Open Google Drive and Check the Trash Folder for the Deleted File

Navigate to Google Drive (drive.google.com) and click on "Trash" or "Bin" on the left-hand side of the screen. Look for your deleted file here, where files stay for 30 days after deletion.

2. Restore the Deleted File from Trash

If you find your file in the Trash, right-click on it and select "Restore". This will move the file back to your main Drive folder.

How to Recover a Deleted Worksheet within a Google Sheet File

Follow the steps below to recover a deleted worksheet within a Google Sheet file. 

1. Open the Google Sheet File Containing the Deleted Worksheet

Open the Google Sheets file that contained the deleted worksheet. Find it in your Google Drive.

how to recover deleted google sheets

2. Use Version History to Restore the Deleted Worksheet

Click "File" in the menu, then select "Version history" > "See version history". Look for a past version with the deleted worksheet and restore it.

recover deleted google sheets

3. Restore the Worksheet

Look through the version history for a version with the deleted worksheet.

how to recover deleted sheets in google sheets

Click on it and choose "Restore this version" to bring the worksheet back.

We hope that you now have a better understanding of how to recover deleted Google Sheets. If you enjoyed this article, you might also like our article on how to center across selection in Google Sheets or our article on how to calculate percentage change in Google Sheets.

Get Google Sheets productivity and automation tips delivered straight to your inbox
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
We'll email you 1-3 times a week — and never share your information.
Get your copy of our free Google Sheets automation guide!
  • 27 pages of Google Sheets tips and tricks to save time
  • Covers pivot tables and other advanced topics
  • 100% free

Work less, automate more!

Use Lido to connect your spreadsheets to email, Slack, calendars, and more to automate data transfers and eliminate manual copying and pasting. View all use cases ->