How to Restore an Older Version of a File in Google Sheets

When you are working with big spreadsheets and large amount of data, it is always a possibility that you will inadvertently change the wrong data, or you will copy and paste the wrong information. This problem can be made even worse when you are collaborating with a team of people on a single file.

Google Sheets makes it easy for a large team to work on data in a centralized location, so it’s very likely that you will discover incorrect data that is very difficult (or even impossible) to fix. Luckily Google Sheets has an awesome feature that stores your revision history, which means that you can go back to an older version of a file before a mistake occurred. Our guide below will help you to find that revision history so that you can restore an older version of the file.

How to Find the Google Sheets Revision History and Restore an Older Version

The steps in this article were performed using the Chrome browser version of Google Sheets. This application provides you with the ability to restore a version of your spreadsheet’s history to a snapshot of that file at a particular time and date. Once you complete these steps the current version of the file will be replaced with the version that you have chosen to restore.

Step 1: Open your Web browser and access your Google Drive at https://drive.google.com/drive/my-drive. if you aren’t already signed into your Google Account, then you will need to enter those credentials to continue.

open google drive

Step 2: Double-click the file whose version history you wish to restore.

select file in google sheets

Step 3: Click File at the top of the window, then click the See revision history option.

view revision history in google sheets

Step 4: Select the version of the file that you wish to restore from the Revision history column at the right side of the window.

how to find version history in google sheets

Step 5: Click the Restore This Revision button at the top of the window.

restore revision in google sheets

Step 6: Click the Restore button to confirm that you wish to restore the revision.

how to restore old version of file in google sheets

Note that the older revisions will still be available, so you can always go back to previous version if you find that you have selected the wrong file revision.

How to View Cell Revision History in Google Sheets

Recently Google Sheets has provided the ability to view the cell history changes for individual cells as well. Note, however, that you can’t restore a previous version from the cell history.

  1. Find the cell whose history you wish to view.
  2. Right-click the cell, then select Show edit history.
  3. Click on the arrows to view the various edits for that cell.

How to Copy an Earlier Version of a File in Google Sheets

This option provides you with the ability to create a separate copy of the file from your revision history. you can then elect to share that copy of the file with others.

  1. Click the File tab.
  2. Choose the Version history option.
  3. Click on See version history.
  4. Click on the three dots to the right of the version you want to copy.
  5. Select the Make a copy option.
  6. Give it a name, choose whether to share it with the same people, then click OK.

Restoring Older Versions of Files in Google Sheets on Android or iOS

Note that this feature is currently not available on the mobile app versions of Google Sheets. Anyone wishing to restore an older version of a file in Google Sheets will need to do so through a Web browser like Chrome, Firefox or Edge by navigating to https://drive.google.com and opening the Sheets file from there.

Are you working on a spreadsheet in Google Sheets that needs to be in the CSV file format? Learn how to save as a .csv from Google Sheets to format your information with that file type.

solveyourtech.com newsletter
vintage t rex t-shirt

Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.