Recommended Free Tools
To recover an earlier state of a Google Sheet, open File > Version history > See version history, choose a timestamp to inspect the revision, then either restore it or make a separate copy. You need to own the file or have edit access.
Open and inspect version history
-
On a computer, open the spreadsheet and select File > Version history > See version history.
As an Amazon Associate I earn from qualifying purchases.
-
In the version-history panel, select a timestamp to view that earlier state. Editor names and colored edits can help you identify what changed. Google Sheets version history also shows who made changes and when.
The Tool Desk
Outbyte Driver Updater FREEScan for outdated or missing drivers - takes under a minuteDriver Scan →Outbyte PC Repair FREERepair Windows errors before they cause bigger problemsFix Now →Special offer. See more information about Outbyte and uninstall instructions. Please review EULA and Privacy policy. -
Review the selected revision before choosing what to do with it.
#1 Best Overall
Sale
Mastering Google Sheets: A Step-by-Step Handbook for Beginners to Simplify Data Analysis, Boost Productivity, and Unlock Your Full Spreadsheet Potential- Mastering Google Sheets: A Step by Step Handbook for Beginners to Simplify Data Analysis, Boost Productivity, and Unlock Your Full Spreadsheet Potential
- ABIS BOOK
Google says file owners and people with edit access can view past versions and restore them. See Google Docs Editors Help: Collaborate in Sheets and Google Docs Editors Help: Manage data.
Choose whether to restore or copy the older version
| Option | What happens | Best when |
|---|---|---|
| Restore this version | The selected revision becomes the active spreadsheet. | You want the file itself to return to that earlier state. |
| Make a copy | You create a separate copy of the selected earlier version while keeping the current spreadsheet separate. | You want to inspect or recover earlier contents without replacing the current file. |
Restore the selected revision
Before restoring, consider whether the cell-by-cell edit history matters: Google warns that restoring an earlier spreadsheet version clears the cell-by-cell edit history for changes made before the restore. If that history is important, make a copy instead.
-
In version history, select the timestamp you want.
-
Choose Restore this version to make that revision active.
Special offer. See more information about Outbyte and uninstall instructions. Please review EULA and Privacy policy.
Make a separate copy
-
In version history, select the timestamp you want.
-
Choose the option to make a copy of that earlier version, then use the copy as a separate file.
Rank #3
Sale![The Google Workspace Bible: [14 in 1] The Ultimate All-in-One Guide from Beginner to Advanced | Including Gmail, Drive, Docs, Sheets, and Every Other App from the Suite](https://m.media-amazon.com/images/I/41AWmhmGFuL._SL160_.jpg)
The Google Workspace Bible: [14 in 1] The Ultimate All-in-One Guide from Beginner to Advanced | Including Gmail, Drive, Docs, Sheets, and Every Other App from the Suite- The Google Workspace Bible: [14 in 1] The Ultimate All in One Guide from Beginner to Advanced Including Gmail, Drive, Docs, Sheets, and Every Other App from the Suite
- ABIS BOOK
Google documents both the restore action and the copy option in Google Docs Editors Help: Find what’s changed in a file.
Quick Recap
Rank #4
- hole punched
- high quality card stock
- 4 pages
- made in USA
- keyboard shortcuts
Product prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on Amazon at the time of purchase will apply.
Independent reader supportYour contribution helps us test, update, and keep practical guides available for everyone.
