Is it possible to force a copy of a protected Google doc?

Here is how to copy (or print) the protected google sheet values.

NOTE: With this technique you can copy the cells from each sheet; it's not possible to duplicate the spreadsheet file itself. Formatting is preserved but formulas are not.

  1. Change the URL to:

    https://docs.google.com/spreadsheets/u/1/d/***[document id]***/preview

    The document ID is the random string found in the google sheet URL that is normally 40 to 45 characters long.

  2. For each sheet, type Ctrl+A, Ctrl+C

  3. Paste the cells into another spreadsheet. Formatting


As of the 10th of May, 2018, disabling JavaScript will not load the document at all, and changing the 'edit' to 'preview' also no longer works.

I have found that if you click on the three dots and go to: More Tools > Developer Tools and then click on console, and type in 'document.body.innerText', it loads the entire document as a text file, so that you can copy to your heart's content.


Disable javascript in with developer tools, right click the page, click 'print', change the print destination from your printer to 'save as pdf', and you've got it.