How to copy from a protected Google sheet in four steps?

Google Sheets plays an important role in Netpeak. They make your work clear, structured, and transparent. Here is another useful tip.

Protecting a sheet prevents you from downloading it or even copying some of its contents in the usual way. The following message appears when you try to copy it:

How to bypass this protection?

Open the protected sheet:

Switch to table preview mode. Replace everything from edit to preview in the URL:


Note: a large sheet may take a while to open because it's a large HTML file.

Select and copy the content as usual: Ctrl+A Ctrl+C.

Paste it into a new sheet:

Done. You've got a table almost identical to the original one, with little adjustments to format.

Found a mistake? Select it and press Ctrl + Enter