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

How to Copy Data From View Only Google Sheets

How to update the URL:

Replace the end of the url which may look like "edit?gid=0#gid=0" with "htmlpreview"

What to look for in the html file:

docsshared-disable-image-copy docsshared-no-select

Copy and paste that line into the find tool in notepad.

Fluff description:

Greetings, in this google sheets tutorial we shall be looking at how you can copy and paste data from a view only google sheet. This tutorial is great for if you have a google sheet you can view, but you can't make a copy, you can't export it, you can't download it and you can't copy and paste the cells containing the data.

Well with this tutorial on how to copy data from a view only google sheet, you can copy and paste the data with no issue. So to to copy data from view Only Google sheets you need to go to your url address bar and at the end where it says "edit?gid=0#gid=0", change that text to "htmlpreview". Then hit enter and your will load the google sheet you want to copy data from in preview mode. Htmlpreview mode for a google sheet will allow you to copy and paste data, even if you couldn't in edit mode. This works perfectly for view only google sheets.

However, there is more you must do to be able to copy the data from your google sheet. Right click on this preview sheet and save as html. Make sure it is a complete html webpage. After that right click on the html file in the file explorer and open in notepad or whatever text editing software you want.

Now remove this from the html file:
docsshared-disable-image-copy docsshared-no-select

You can use ctrl key and the F key to open the fine and replace tool to find the text:

docsshared-disable-image-copy docsshared-no-select

Once you have removed docsshared-disable-image-copy docsshared-no-select save the file. Now open the html file in your web browser.

If you copy the entire google sheet and paste it into a new google sheet, all the data will be pasted in the correct rows and columns! So this method allows you to basically make a copy of a view only google sheet. Then in this new google sheet you have made and pasted data into from the view only google sheet. You can then download, export, make a copy of or do whatever you want to the sheet you made. So this basically lets you download a view-only google sheet online.

One thing to note about this way to copy a view only google sheet. You can only copy data you are able to access in view only mode for the google sheet. You won't be able to copy anything in the view only google sheet that you don't have access to when viewing the document in view only mode. Some formatting changes also down't work with this method to copy data from a view only google sheet. For example BOLD text, italic text or text with a line through it. So there are limitations to this way of copying data from a view only google sheet.

This method to copy data from a view only google sheet will also work if you want to copy data from a view only google doc. So this tutorial on how to copy data from a view only google sheet also works when you want to download view-only Google docs.

Thanks for watching this tutorial on how to download view only google sheets.

If this tutorial on how to copy froma view only google sheet helped, then be sure to subscribe to keep notified when I upload.

This tutorial should help answer the following questions:

How to Copy Data From View Only Google Sheets
Download View-Only google sheet online
How to Download View Only Google Sheet
How to Make Copy of View Only Google Sheet
How to Copy Data from View Only Google Sheets/Docs
How to Save View-Only Protected Google Docs File
How to Save View-Only Protected Google Sheets File
Copy Protected Google Sheets
Copy View Only Google Sheets