How to Restore a Version from Version History in Google Sheets

Have you ever made a change to a spreadsheet, then realized later that it was a mistake? Often these sorts of changes can be rolled back with Ctrl + Z or the application’s Undo option, but sometimes they can’t.

Typically you may decide that you simply need to manually recreate everything, or possible even give up on the current file and start over. But Google Sheets has something called Version History, which you can use to restore the spreadsheet to a version that was saved at some point in the past. Our guide below will show you how.

How to Use Version History in Google Sheets

The steps in this article were performed in the desktop version of the Google Chrome Web browser, but will also work in other desktop browsers like Firefox or Edge. Note that by restoring a previous version of the file you will be removing any of the edits, changes, or data that have been added to the file since that point.

Step 1: Sign into your Google Drive at https://drive.google.com and open the file.

Step 2: Select the File tab at the top-left of the window.

open google sheets file menu

Step 3: Select Version history from the menu, then click See version history. Note that you can also open that menu by pressing Ctrl + Alt + Shift + H on your keyboard.

open google sheets version history

Step 4: Click the version of the file that you wish to restore from the list at the right side of the window.

choose the version to restore

Step 5: Click the green Restore this version button at the top of the window.

select the restore this version option

Step 6: Click the Restore button on the pop-up window to confirm that you wish to perform the action.

how to restore from version history in google sheets

Do you need to open your file in Microsoft Excel, or to send it to someone else that will? Find out how to get an Excel version of your Google Sheets file so that it can be opened in Excel.