Easy Steps to Recover Lost Data on Google Sheets
Accidentally closed a Google Sheet without saving or faced an unexpected system crash? Don't worry, your data might still be recoverable. Google Sheets, being cloud-based, has built-in recovery options that can help you retrieve your lost work. Let's dive into how to recover Google Sheets step by step.
Before proceeding, ensure that you're signed into the correct Google account where your Google Sheets are usually saved. Also, remember that recovery options depend on whether you've enabled version history or not. So, let's explore both scenarios.
Recovery Options Without Version History
If you haven't enabled version history, you're not completely out of luck. Google Sheets autosaves your work every few seconds, and these autosaved versions might still be recoverable.
Here's how to check for and recover autosaved versions:
Checking Autosaved Versions
1. Open the Google Sheet that you want to recover.
2. Click on the 'File' menu at the top left corner, then select 'See revision history'. This will open up the Version history sidebar.
Recovering from Autosaved Versions
1. In the Version history sidebar, look for the autosaved versions. They should be labeled with 'Auto-saved' and a timestamp.
2. Select the Autosaved version that has the data you want to recover. Click on the three vertical dots (⋮) next to the version and select 'Restore this version'.
Recovery Options With Version History
If you've enabled version history, the process becomes much simpler. Every time you make changes to your Google Sheet, it's automatically saved as a new version.
Here's how to recover old versions with version history:
Accessing Version History
1. Open the Google Sheet.
2. Click on the 'File' menu, then 'Version history'.
Restoring an Old Version
1. In the sidebar that appears, you'll see a list of all the saved versions with dates and times.
2. Choose the version you want to restore by clicking on its name. A preview of that version will appear.
3. Click on 'Restore this version' at the top of the preview. This will replace your current Google Sheet with the selected version.
Remember, restoring a version overwrites the current version. If you want to keep the current changes, create a copy of the current version first.
Finally, consider making it a habit to manually save your work frequently (click on File > Save) and enable version history for all your important Google Sheets. This will give you peace of mind knowing that your work is always backed up and recoverable. Happy recovering!