How to remove revision history from a Google Sheet

How to remove revision history from a Google Sheet

If you use Google Sheets you’re probably familiar with how useful it is to be able to scroll through changes made. However, unlike Office, Google doesn’t seem to give you any easy way to remove personal information or revision history before you share a document.

Here’s my very important spreadsheet with columns of stuff, for people, about things. When I share that with people I’m keen not to let them view the revisions. I also might just want to draw a line in the sand and remove any revisions up to today so that the list is cleaner in the future.

2016-03-02 12_32_32-Very Important Things - Google Sheets

  1. In Google Drive, right click the Sheet entry for your file and choose Make a Copy.
    2016-03-02 12_37_49-test - Google Drive
  2. Now right click your original file again and choose Remove. This will delete the file to your trash and leave you with the copy file (prefixed with “Copy of”).
  3. Right click the “Copy of” file and click Rename. Rename this to match your original filename.
  4. Your revisions have now been removed. Open up your new spreadsheet and you can check the revision history.

    My revision list before

    My revision list after

Author

Oliver Marshall
Oliver works as a Director at Oakson who provide absolutely awesome IT support in Brighton, UK. Out of hours he's a runner with a limp, has a board game addiction and a owns a dog that looks like a badger.
Show Buttons
Hide Buttons

Stay in touch

or
Subscribe to my weekly newsletter

If you are enjoying this article then why not like my page.