While sharing Google Documents, Sheets, or Slides with others, Google provides file owners with a number of alternatives for safeguarding their sensitive information. You can only see a Google Doc that has been password-protected; copies cannot be made. Naturally, you can ask them for their consent to copy that paper.
If you are unable to get in touch with the owner, you might try the approach described below to duplicate the secured Google Documents. Let’s get going.
1) /Preview (easiest)
A simple option. In the URL, erase the text after the last forward slash and replace it with “preview”. For example, “/edit#gid=93738036” becomes “/preview”. Then copy and paste the text into another Google sheet.
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.
- Change the URL to:
https://docs.google.com/spreadsheets/u/1/d/***[document id]***/previewThe document ID is the random string found in the google sheet URL that is normally 40 to 45 characters long.
- For each sheet, type Ctrl+A, Ctrl+C
- Paste the cells into another spreadsheet. Formatting
2) Disable JavaScript
- Change the end of the document URL from
/editto/mobilebasic. - Disable JavaScript for all sites( re-enable after you are done copying)
- Keeping the console open, reload the page.
- Ctrl+A + Ctrl+C
- Open new doc and CTRL+V
3) Inspect element
While sharing Google Documents, Sheets, or Slides with others, Google provides file owners with a number of alternatives for safeguarding their sensitive information. You can only see a Google Doc that has been password-protected; copies cannot be made. Naturally, you can ask them for their consent to copy that paper.
If you are unable to get in touch with the owner, you might try the approach described below to duplicate the secured Google Documents. Let’s get going.
Options to download, print, and copy have been disabled on this file. Learn More.
Let’s see how to remove it and copy the text. The document URL will end with /edit, as seen in the address bar.
Go ahead and change /edit the address bar to /mobilebasic.
Change /edit to /mobilebasic in the address bar now.
To open the Developer tools, hit the CTRL, Shift, and C keys on your keyboard simultaneously.
Press CTRL+Shift+P after that. On the console window, you will see a prompt that reads Run > Command. Enter “javascript” and select the Disable Javascript option.
Your address bar will now display a new icon with a little red X. You will get the notice “JavaScript was blocked on this website” if you hover your mouse pointer over that.
Press F5 or click the Refresh symbol on the page to refresh the page without quitting the console window. then choose by pressing CTRL+A.
Your address bar will now display a new icon with a little red X. You will get the notice “JavaScript was blocked on this website” if you hover your mouse pointer over that.
Press F5 or click the Refresh symbol on the page to refresh the page without quitting the console window. To copy the data to the clipboard, press CTRL+C after selecting all of the data with CTRL+A. You won’t see a warning message any longer because the data has successfully been copied.
Then, open a new Google document, paste the data inside by using CTRL+V, and then begin altering the page as you see fit.
Normal users might find this procedure a little complicated, but it actually saves a lot of time because you don’t have to retype the entire page.
How to Download or Copy a Secure Google Sheet
Do you intend to copy information from a secured Google Sheet? The same warning message that appears in Google Docs will appear: “Options to download, print, and copy have been disabled on this file.”
However, if you must, you can use the below approach to copy information from a Google Sheet that is password-protected.
On your computer, open the secure Google Sheet. The document URL will conclude with /edit and a string of alphanumeric characters in the address bar. The term “edit” and all other characters should be deleted. Type preview immediately after the / sign. The data from the Google sheet will then appear in a preview similar to the one below:
To select and copy all data, hit CTRL+A and then CTRL+C on your keyboard. Then click Edit > Paste from the menu after opening a new Google Spreadsheet.
It’s done now. The new sheet has all of the protected Google Sheet data that has been copied and pasted there. The sheet is yours to edit and save anyway you choose.
FAQ: How Do I Copy From Secured Google Docs/Sheets?
Can Google Documents restrict copying and pasting?
Yes. With Google Docs/Sheets/Slides, you can deactivate downloading, printing, and copying from the advanced sharing option. Click the Settings icon in the Share window to the right of the document you want to share. To prevent the Google Document from being duplicated, tick the box that says, “Block options to download, print, and copy for comments and viewers.”
Can you make a copy of a Google Doc that is only available for viewing?
There isn’t a simple way to replicate a protected Google Doc other than asking the owner’s permission, according to Google. To copy information from a Google Doc that is only available for viewing, you can disable JavaScript by going to Developer tools.
In Google Sheets, is it possible to replicate a protected sheet?
Yes. You can copy data from a secured Google sheet and paste it into a different spreadsheet by changing the protected sheet’s URL.
4) /mobilebasic
Enter the URL into https://outline.com/. At the time of writing, URLs ending in /edit are working, if google ever patches this I’d recommend trying to replace /edit with /mobilebasic.
https://webapps.stackexchange.com/questions/126526/how-to-copy-from-a-protected-google-doc/155776
https://stackoverflow.com/questions/40296831/is-it-possible-to-force-a-copy-of-a-protected-google-doc
https://gist.github.com/Snarp/6c06f60899ca3f43bdd3d8170885f83f