Google AppsHow Tos

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.
    [space height=”20″]

    My revision list before



    My revision list after


What is your reaction?

Strongly Agree
Strongly Disagree

You may also like

Leave a reply

Your email address will not be published. Required fields are marked *

The reCAPTCHA verification period has expired. Please reload the page.

More in:Google Apps