Restore or Copy an Earlier Google Sheet Version
The fastest way to recover an earlier version of a Google Sheet is to use File > Version history > See version history, which lets you preview and restore any past snapshot. If you only want a piece of the old data without overwriting the current sheet, you can copy a specific version into a new file instead. This article explains both methods, when to use each, and how to avoid common pitfalls.
How Google Sheets Version History Works
Google Sheets automatically saves a snapshot of your spreadsheet every time a change is made, but it groups rapid edits into named or timestamped versions. You can access up to 30 days (or 100 versions, whichever comes first) for free accounts; Google Workspace accounts may retain longer depending on admin settings. Each version shows the time it was saved and who made the edits, if the sheet is shared.
To open the history, go to File > Version history > See version history. A panel slides in from the right, listing all saved versions. Click any entry to preview the sheet as it looked then. The preview is read-only until you choose to restore it.
Restoring an Earlier Version (Overwrites Current Data)
Restoring replaces your current sheet with the selected version. This is the right choice when you want to undo a mistake entirely, such as deleting a column, breaking formulas, or overwriting a large block of data.
- Open the spreadsheet in Google Sheets.
- Click File > Version history > See version history.
- In the right panel, click a version to preview it.
- If it looks correct, click the blue Restore this version button at the top.
- Confirm in the dialog that appears.
After restoring, the sheet becomes the current version, and the previous state is pushed into the version history—so you can undo the restore if needed. Be aware that any edits made after the restored version are lost, unless you saved them elsewhere.
Copying an Earlier Version (Keeps Current Data Intact)
Copying is safer when you only need a portion of the old data, or when you want to compare versions without changing the live sheet. Google Sheets does not offer a direct “copy this version” button, but you can achieve it in a few clicks:
- Open File > Version history &strong> and select the version you want.
- In the preview, click the three-dot menu (⋮) next to the version name.
- Choose Copy to and select an existing spreadsheet, or Make a copy to create a new file.
The copied file is a standalone spreadsheet, so you can extract data, copy ranges, or use it as a reference without affecting the original. This is ideal for auditing, merging changes, or keeping a permanent archive.
When to Restore vs. Copy
The choice depends on what you need:
- Restore when you want the sheet to go back to that exact state, and you don’t need anything newer.
- Copy when you want to keep the current data and pull something from the past, or when you’re not sure if you’ll need the restore later.
- Copy when you need to compare two versions side by side.
- Restore when the sheet is corrupted or a major error needs to be undone immediately.
If you’re collaborating, restoring affects everyone viewing the sheet. Copying creates a separate file that only you can edit, so it’s less disruptive.
Common Problems and Misconceptions
“I can’t see any versions.” If the version history is empty, the sheet may have been created recently, or you might be looking at a file that was imported as a non-Google format (like .xlsx). Convert it to Google Sheets first via File > Save as Google Sheets, then history will start accumulating.
“Restoring deleted a version I needed.” Restoring does not delete previous versions; it adds a new version. The state before the restore remains in history, so you can go back to it.
“Version history only shows one version.” This happens when the sheet has been edited only once, or when edits were made in a very short time and grouped. Try clicking the timestamp to expand grouped versions.
Misconception: “Copying a version preserves all formulas and formatting.” It does, but only if the version itself had them. If a formula was added later, it won’t appear in the copied version.
Version History Limits and Retention
Google keeps version history for 30 days for personal accounts, or 100 versions, whichever is greater. For Google Workspace accounts, retention is often longer, but it depends on the admin’s settings. After the retention period, older versions are permanently deleted—there is no way to recover them. If you need a long-term archive, use File > Make a copy or download a copy as .xlsx or .ods periodically.
Also note that version history is per spreadsheet, not per tab. If you edit multiple tabs, the version includes all tabs at that moment.
Alternatives to Version History
If you need more control or longer retention, consider:
- File > Make a copy – creates a new file with the current state, useful for snapshots.
- Google Drive’s “Manage versions” – for uploaded files, but not for native Sheets.
- Third-party backup tools – like Sheetgo or Backupify, which can automate daily copies, but they may cost money.
- Export as .xlsx – download a copy to your computer, then re-upload if needed.
For most users, the built-in version history is sufficient. The key is to act quickly, because the 30-day window passes faster than you think.
Frequently Asked Questions
Can I restore a version from a specific date?
Yes, the version history panel lists all saved versions with timestamps. You can scroll through the list and click any one to preview it. There is no search bar, but if you have many versions, you can use the date range filter at the top of the panel to narrow down to a specific day.
Does restoring a version affect other people’s edits?
Yes, restoring changes the sheet for everyone. If someone else has unsaved changes, they might be lost. It’s best to notify collaborators before restoring, or use the copy method instead.
Can I copy just one tab from an older version?
Yes, after copying the entire version to a new file, you can delete the tabs you don’t need, or copy the specific tab to your current sheet via right-click > Copy to > Existing spreadsheet.
What if I accidentally restore the wrong version?
No problem. The restore action itself creates a new version, so you can go back to the version history and restore the previous state again. The history retains all states, so you can always undo your restore.
Is version history available on the mobile app?
Yes, the Google Sheets mobile app has a version history option under the three-dot menu (⋮) > Version history. The interface is simplified, but you can view and restore versions from your phone.
Related
Method: the standard formula for this calculation, rounded as each result states. See how the calculators work or report an error.