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:

Result:

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.

Check out our list of digital marketing terms. You can then read Netpeak Journal articles with confidence and ease.

Duke Raul

Find other articles by this author

Topics:

How-to Guides Business

Found a mistake? Select it and press Ctrl + Enter

What Does the EU Green Claims Ban Mean for My Pet Brand's Amazon EU Listings?

Your Amazon.com listing can keep calling that bamboo cat litter "planet-friendly" for now. Your Amazon.de, .fr, .it, .es, .nl, .pl, .se, and .be listings cannot.

What Does Amazon’s Full-Funnel Campaigns Beta Mean for My Pet Brand?

Amazon’s Full-Funnel Campaigns beta lets you hand three products, a logo, and $200 a day to Amazon, which then builds and runs Sponsored, display, and video ads in one campaign.

Ecommerce Case Study: How UX Mistakes Made a Site Bleed Customers

This ecommerce UX case study for an online coffee retailer shows how a few thoughtful design fixes that don't take up a lot of resources or time can significantly boost conversion rates.