How to Copy Data From View Only Google Sheets (Updated Works in 2024)

[@udhayamanikandan4309]

This is amazing, thanks for sharing ! Pro -tip: If you're using Mac - It will save as Complete Webpage - Open with Notes - Everything is pre-formatted and you can copy directly to new sheet :)

[@erjonameti]

Thanks Max!
You got a subscriber!

[@xes2318]

saved me hours, works as shown thanks

[@Tobeornototbe1003]

It works perfectly

[@samdamzy4004]

Thanks very much, worked perfectly

[@ayushgemini]

Thanks a lot man you are gr8❤

[@dieuquangluu3337]

Thank you so much!!!

[@harshjaiswal8264]

thanks buddy!
That works

[@Enjurin]

Thanks for sharing 😘

[@worth_mawa]

Awesome great Job

[@adamlevi87]

it works. thanks

[@SyedTalha7]

THANKKK YOUUUUUUUUUUU ❤🎉

[@nightcreeper24]

Does not work for subsheets :(

[@duyle42]

thank you so much love you bro

[@omgitispewdiepie4072]

F for Mr Beast

[@Anhkisudaytoan]

thank you so much

[@azogue8668]

Thanks

[@Mattferraro11]

I don’t think it works for apple any suggestions

[@Yesasa6]

Awesome, is there any way to do the same in a restricted zohoo sheet?

[@camiilepmoreno]

can I use an import syntax (e.g. importrange, importdata, importhtml) to automate copy from the view only google sheet?

[@_kienguyxn205_]

god damm bro!!!! so fk good

[@TiếnĐứcTrần-e4c]

hi, i have done as you said and successfully copied 1 page from sheet. however, when i tried to do the same with the 2nd, 3rd, etc, the sheet reloaded and i couldn't copy it. how can i fix the prob? tks

[@moanasangeo2384]

When you are saving the doc, have it viewing on the sheet that you are trying to do. Then repeat the process. You have to save a file for each individual sheet you are trying to copy

[@TiếnĐứcTrần-e4c]

@@moanasangeo2384 thanks for your suggestion. i have found a way to fix the problem. turning out wifi before selecting next page helped me fix it.

[@logueaswaramoorthy1033]

@@moanasangeo2384 It did not work even when I navigated to page 2 and saved it. Do you have any other method?

[@logueaswaramoorthy1033]

Please let me know if you found any work around

[@allelingtv]

but you cant download the formulas. btw thank you

[@alinmarian3922]

Doesn't work!

[@_kienguyxn205_]

its old

[@avgshroud7805]

Not working now

[@xes2318]

skill issue

[@its_antz]

does not work