Allow selecting, copying, pasting and right clicking in some restricted sheets.
Sheet Copier opens a google sheet in a new tab in preview mode for previewing a sheet. 1. Click 'Open Copyable Sheet' 2. Select all and copy (Cmd/Ctrl+A, Cmd/Ctrl+C) 3. Open new Google Sheet 4. Paste into new sheet (Cmd/Ctrl+V)
- (2022-02-21) Alex Duffy: Worked for me!
- (2021-10-18) LeQuall James: Worked thanks bro!
- (2021-10-18) Sufian Naeem: I am looking to get the formulas as well. Its not working. The sheet is in View Only mode. Export options are disabled. Sheet is protected. Here is the link: https://docs.google.com/spreadsheets/d/1sr5Av6CMM2OutWgIW6T4IO5IKw2kd5QzusX-vB9LpnI/edit#gid=1276218007
- (2021-08-25) Duc Thien Tran: Worked as advertised, but only work for text data only, i cant copy the charts or formula of some sort.
- (2021-07-28) Eduardo Hernandez: Doesn't work with https://docs.google.com/spreadsheets/d/e/2PACX-1vQkSQpSMq7ARPy2jTjn4amWPe_mX39NVZRe9v3LHZC11wGEOHHnETP18pfSITU3thsGvFH6LRzFKEit/pubhtml# When I click “Open Copyable Sheet” it opens: https://docs.google.com/spreadsheets/d/e/preview
- (2021-07-02) Josh Downing: did not work. i tried to copy and paste this locked sheets spreadsheets and it did not work https://docs.google.com/spreadsheets/d/1YHgVjAd2vMRN96oHcD1HC-MPL50q5S4w2zxc6Uk9wrU/edit#gid=0
- (2021-04-18) S P: It's not working, unable to download locked spreadsheet. On clicking add-on, it opens the web version of google spreadsheet.
- (2021-02-12) Candy Beauchamp: Worked perfectly!
- (2021-01-25) Patrick Gallagher: Worked well for the sheet I needed. I was able to copy the values, paste them into Excel, grab what I needed and put them into my google sheet. Thanks for this!
- (2021-01-06) Hopeton Wilson: I cannot copy a spreadsheet that is view only and export options disabled. I have a spreadsheet and it cannot copy the sheet at all.
- (2020-12-08) Wilbert Cheng: Sorry, the file you have requested does not exist.
- (2020-11-02) Manish Sinha: Fantastic, works as advertisted.
- (2021-07-17, v:0.3) Jameson Carter: So Far So Good!
I have been researching any possible option for how to copy a "View-Only" file on Google Docs & finally came across this one. Was a bit skeptical, but it appears to be working! Thank you SO much!
- (2021-01-06, v:0.3) Hopeton Wilson: This app doesn't work for me
I cannot copy a spreadsheet that is view only and export options disabled. I have a spreadsheet and it cannot copy the sheet at all. Here is the spreadsheet https://docs.google.com/spreadsheets/d/1ckO1W-rZe0OxGLfgTdBSVRYQIuHbWOUys4FwkGsSHTk/edit#gid=2065273203 and the it is not copying the data tab.