I love Google Docs, Google Sheets and Google Slides. One thing however that I’ve become very adept at is overwriting a document, spreadsheet or presentation that I intended to copy. I’m so used to opening an existing file in Microsoft Word, Excel or PowerPoint, making changes and then clicking Save as that I forget that this isn’t possible in Google G Suite apps.
Restoring a version of a file is simple enough however by following the standard instructions you’ll lose all the new amendments you’ve made to the file.
Instructions to restore an original Google Apps for Work file while keeping all changes
Here is an easy and effective way to restore a file that you’ve accidentally overwritten as well as keeping the new Presentation, spreadsheet or document that you’ve created. Using the steps below you will restore the file that you’ve overwritten as well as keep the new content you have created.
- Open the file with the new content in Google Docs, Sheets or Slides (i.e. this is the file where you have overwritten content you want to restore).
- Click File > Make a copy and follow the prompts to make a copy.
- Open the file that you copied (i.e. the original and not the copy).
- Click File > Version history > Name current version.
- Name the file as you wish.
- Click File > Version history > See version history.
- Under the header titled Version history click the version you want restored.
- Click the button Restore this version.
- Click Restore when prompted.
You now have your original content that you thought you’d overwritten as well as a file with the updates you made.
Thanks but I need to restore from a prior version of a Sheets file to a different file name so I can selectively restore data from the earlier version to the “latest” file.
ITS WORKED. THANK YOU SO MUCH SIR….
“I’ve become very adept at overwriting a document” … ha, Sir, we share that skill now. And thanks to your tutorial, also another to undo the wickedness of the former. Cheers!