How to Restore an Older Version of a Google Sheets File

To restore an older version of a Google Sheets file, open the spreadsheet on a computer, click Last edit at the top right, choose an earlier version in the right panel, then click Restore this version and Restore. You need permission to edit the file, and version history is not available in the Sheets mobile apps.

The steps below follow Google’s Find what’s changed in a file help page.

Use a Computer

  • Use a computer. Google’s Android and iPhone & iPad help pages say that to see version history you need to open the file on a computer.
  • Check your access. Google says you need permission to edit a file to browse its earlier versions. View-only and comment-only access is not enough.
  • Know what a version is. Version history is the list of saved states of a spreadsheet, each marked with a date, a time, and the people who edited it.
  • Decide between restoring and copying. Restoring changes the file that everyone shares. Making a copy leaves that file alone and puts the older version in a new file.

How to restore an older version in Google Sheets

Warning: Restoring an earlier version of a spreadsheet clears the cell-by-cell edit history for any changes made before the restore. If you need that history, use the copy method in the next section instead.

  1. On your computer, open the spreadsheet in Google Sheets.
  2. At the top right, click Last edit. The spreadsheet switches to version history view and a panel opens on the right.
  3. In the right panel, click an earlier version. The grid changes to show the spreadsheet as it was at that time, along with who made the edits.
  4. If several versions are grouped under one entry, click Expand to see each one.
  5. Check the tabs at the bottom and scroll through the data to make sure this is the version you want.
  6. At the top, click Restore this version.
Google Sheets version history panel with an earlier version selected and the Restore this version button
Select an earlier version in the right panel, check its data, then use Restore this version when you are ready. (Recreated interface)
  1. Click Restore to confirm.

The spreadsheet returns to normal editing view with the contents of the version you picked. A restore changes the one file that everyone shares, so let collaborators know before you do it.

Steps to restore an older version of a Google Sheets file
Illustration: how to restore an older version of a Google Sheets file.

You can also open the same panel from File > Version history > See version history.

If you prefer the keyboard, Google’s shortcut list gives Ctrl + Alt + Shift + H on Windows and ChromeOS and Command + Option + Shift + H on a Mac for opening revision history.

How to copy an old version instead

Copying is the safer choice when other people are working in the file, when you only need a few cells from the past, or when you want to compare old and new side by side. Your current spreadsheet stays exactly as it is.

  1. Open the spreadsheet on your computer and click Last edit at the top right.
  2. In the right panel, find the version you want. Next to it, click More (the three dots), then Make a copy.
  3. Enter a name for the copy.
  4. Choose where to save the file.
  5. To give the same people access, select Share it with the same people.
  6. Click OK.

A new spreadsheet with that version’s contents is saved in the folder you chose. From there you can copy the cells you need back into the original. The same Make a copy option in Google Drive works for any file you want to duplicate.

Comparison of Restore this version and Make a copy in Google Sheets version history
Illustration: restoring a version changes the current file, while making a copy creates a separate one.

How to confirm the restore and go back

After you click Restore, look over the cells that were wrong before. Then click Last edit again and check the top of the version list.

To reverse a restore, open version history again, choose the version you want, and click Restore this version. Revisions may occasionally be merged, so not every earlier state is guaranteed to stay in the list. Before restoring an important file, make a copy of the version you are about to replace, or give it a name as described below.

If you opened version history only to look, click Back at the top left to return to the current spreadsheet without changing anything.

Find the right version faster

  • Show unmodified rows: By default, Sheets hides rows that did not change so edits are easier to spot. To see every row, click Show unmodified rows at the bottom right.
  • Name a version: Choose a version, click More, then Name this version. Named versions are not merged with others, and you can add up to 15 named versions per spreadsheet.
  • Only show named versions: Turn on this switch in the panel to hide everything that has no name.
  • Expand grouped versions: Click Expand next to an entry to see the individual saves inside it.

Naming works the same way in Docs. Here’s how to name or rename a version in Google Docs.

Other Google Sheets version history tools: copy, name, show rows, cell history
Illustration: other Google Sheets version history tools.

See who changed one cell

If only one value looks wrong, you may not need to restore anything. Right-click the cell and choose Show edit history to see who changed it. You can then type the correct value back in yourself.

Some changes might not show up in the edit history, including added or deleted rows and columns, changes to the cell’s format, changes made by formulas, and changes made before a past version was restored.

If wrong values keep appearing as you type, turn off autocomplete in Google Sheets to stop accepted suggestions.

If a number that should be calculated looks wrong, show the formulas in Google Sheets to check whether someone typed over a formula.

Can’t see or restore older versions?

  • You only have view or comment access. Without edit permission you will not see version history. Ask the owner to change your access. The owner sets that in the same place used to share or unshare a Google Sheets file.
  • You are on a phone or tablet. Open the file in a browser on a computer.
  • The version you expected is not listed. Revisions may occasionally be merged, so not every edit has its own entry. Click Expand on nearby entries, and turn off Only show named versions if it is on.
  • The history was deleted. The file owner can remove unnamed versions with Delete history or Delete this and older versions. This is permanent and cannot be undone.
  • The file is not a Google Sheets file. Files such as PDFs and images use a different feature, Manage versions in Google Drive, and those versions might be deleted after 30 days or once there are 100 newer ones. Google’s version history page does not cover Excel files opened in Sheets, so check both places for those.
  • Cells are locked after the restore. A restored version brings back its contents, and a protected range can still stop you from editing. You may need to unprotect the sheet before you can edit it.

Drive’s separate version feature is described on Google’s Check activity & file versions page.

If the whole file is gone rather than changed, you can recover a deleted file from the Google Drive Trash.

Once the spreadsheet is back the way you want it, name that version so it is easy to find later. If leftover notes from the old version came back with it, here is how to remove comments and notes in Google Sheets.

Sheets Version History Questions

Does restoring an older version delete my current data?

Restoring replaces what is in the spreadsheet with the contents of the version you chose. Google’s page does not say the newer version is erased, but it does say the cell-by-cell edit history from before the restore is cleared. To be safe, use Make a copy on the current version first.

How far back does Google Sheets version history go?

Google does not give a time limit for Sheets on its version history page. It says only that revisions may occasionally be merged, and that owners can delete history. Name any version you know you will need again.

How do I see who made the last change?

Hover over Last edit at the top right. It shows who last updated the file and when. A blue dot on the icon means someone changed the file since you last viewed it.

Can I restore just one sheet tab or one cell?

The Restore this version button applies to the whole spreadsheet. To bring back only part of it, make a copy of the older version and paste the cells or tab contents you need into the current file.

Who can delete version history?

The file owner can manage and delete version history. Deleting removes versions that have not been named, and it is permanent.