How to Recover Deleted Google Sheets: 4 Ways
Do you want to know know to recover deleted Google Sheets? In this tutorial, you will learn 4 effective ways to recover Google Sheets deleted within or after 30 days.
Can you recover deleted Google Sheets?
How can I recover the Google Sheets deleted two months ago? I thought it was useless so I moved it to the trash. However, I found some important information was stored in it! But when I opened the trash holder, it was gone forever. Can someone help me get this file back?
- Question from TechForum
It is a question from a forum user about how to recover deleted Google Sheets after 30 days. Yes, you can recover deleted Google sheets even if it was permanently deleted.
Google Sheets is one online spreadsheet editor for personal and business use. Users can get insights together with secure sharing from any device and in real time.
With its most popular feature of collaboration, an increasing number of businesses feel inclined to save numerous data on Google Sheets.
However, you may find some wanted Google Sheets disappeared or were mistakenly deleted. Don't worry. Please read the following parts to find a suitable way to help you restore deleted Google Sheets.
How to Recover Deleted Google Sheets within 30 Days?
Fortunately, there is a location called "Trash" on Google Drive. "Trash" stores all the deleted Google files (including Google Sheets).
If you have not manually emptied your deleted files within 30 days, they are still in "Trash". You can recover them via your Google Drive.
Recover deleted Google Sheets from Google Drive Trash
If you are on a computer, you can resort to a web browser to recover deleted Google Sheets. Directly access Google Drive Trash through Google Chrome, Microsoft Edge, or other online browsers.
Just with several simple clicks and you can restore the wanted spreadsheet.
Step 1. Visit Google Drive and log into your Google account.
Step 2. Click Trash on the left panel and enter its recycle bin.
Step 3. Locate the spreadsheet you want. Right-click its name and click Restore. The deleted file will come back to your sheet list.
How to Recover Deleted Google Sheets after 30 days?
The method mentioned above only works for Google Sheets removed within 30 days. But how to recover Google files deleted for more than 30 days?
Or what if you have manually emptied the Google Drive trash? Try the following ways instead.
Recover permanently deleted Google Sheets from version history
It is common to save multiple copies of your spreadsheets every time you make some changes. However, this operation may not only take up your disk space but also force you to spend extra time managing and recognizing these different versions.
Luckily, Google Sheets saves every edit to the cloud and keeps logs of every change automatically. So you could look them up and compare. And it's called version history.
With this beneficial feature, even if part of your Google Sheets disappeared, as long as the Google spreadsheet file that included it is still present, you are able to restore google sheets to the previous version and find this part back.
Here are the steps.
Step 1. Open the Google Sheets file where you have deleted partial contents.
Step 2. Click the File tab > Version history > See version history.
Step 3. Locate the version needed in terms of its name and time. Then click More actions > Restore this version. Now you have restored your spreadsheet to previous version and get the wanted data back.
Recover permanently deleted Google Sheets from Google Drive Help
If you have permanently deleted the whole Google spreadsheet file and have no access to the previous version, go for Google Drive Help for file recovery. Apart from disappeared files, you can also ask Google Help Center for feedback, FAQs and other technical support services.
Step 1. Visit Google Drive Help and sign in with your Google account.
Step 2. Type the basic information required. And check the content box to submit your request.
Step 3. Google Drive Help is going to send you a confirmation email in consequence. It usually takes up less than 48 hours to recover your deleted Google Sheets.
Recover permanently deleted Google Sheets from data recovery software
However, if there is little time to wait for Google for a response or you are unable to contact the owner to send a restoration request, you still have another simple, fast and secure way -
Find a professional Windows data recovery tool - MyRecover. It is a free and powerful data recovery software researched and developed by a professional IT team.
As long as you have once stored Google Sheets on your computer, this tool is able to recover them quickly and effectively without data loss.
With more than 12 years of experience, MyRecover has grown into an impressive Windows file recovery tool with a package of advanced features and user-friendly operations.
- Recover lost/deleted data from HDD/SSD with simple clicks.
- Apply to all-inclusive data loss scenarios in Windows.
- Restore 200+ types of data, such as photos, videos, office files, etc.
- Embed advanced scan and recovery technology.
- Support Windows 11/10/8/7 & Windows Server.
Step 1. Launch MyRecover first. Select the disk where your Google Sheets are stored on. Click Start Scan to run a quick and deep scan.
Step 2. Select the Sheets needed to recover. Use the filters to quickly locate your deleted files as you like.
Step 3. Choose the wanted files under Deleted files or Recycle Bin > click Recover x files.
Extension: Why can't I see version history in Google Sheets?
As has been mentioned above, the version history of Google Sheets saves every change made to work across all editors. Google sheets version history limit is set to protect privacy in consequence.
As for how to restore Google sheets to the previous version, only users with viewing permission have access to the previous versions.
Therefore, if you can't see the revision history of shared Google Sheets, it means that you don't have appropriate access rights.
Ask the editor to change your access rights from "can view" (or "can view only") to "can edit (or "can organize, add and edit").
Conclusion and suggestions
This article has introduced 4 ways how to recover deleted Google Sheets after 30 days or within 30 days in detail.
For recently deleted spreadsheets, you can directly recover them from Google Drive Trash; for permanently deleted spreadsheets, you can restore them from version history, Google Drive Help, or MyRecover.
Choose the most suitable way for you and recover deleted Google Sheets simply and easily.
However, even though these ways are useful, data recovery always costs you extra time. So it is better not to lose them. Thus, there are some suggestions that can be helpful.
- Think twice about whether it is necessary to delete the file or not.
- Do not empty Google Drive Trash manually unless your Google Drive is out of storage.
- Keep a copy of the needed Google files if you are not the owner.
- Back up important files to online and offline locations in advance.
The last suggestion is of the greatest importance. It is common sense that data loss may cause disastrous consequences, financial and mental. So developing a habit of backing up crucial data matters.
AOMEI Backupper is a professional backup, sync, and clone software. Some useful features, such as system/file/disk/partition/cloud backup and restore, can add an extra layer of protection to your data.