Copy Data from View-Only Google Sheets 📋

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

How to update the URL:

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

Greetings, in this google sheets tutorial we shall be looking at how you can copy and paste data from a view only google sheet for a google sheet that has multiple pages, 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 located in multiple sheets within the google spreadsheet.

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. Htmlview 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.

The next fun step is you need to open up your developer tools using F12 on your keyboard. I advise yoy use Google Chrome so you can follow along with this tutorial but any web browser will work. You want to go to the network tab, then in the activity table you want to find an entry called htmlview. Click on it and then click on the response tab. Now you will see the html code for your htmlview of the google sheet.

Now navigate to the items.push section and notice you will see entries for each sheet your google spreadsheet has. Copy one of the URLs and paste it into another browser.

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 webpage only html file. After that right click on the html file in the file explorer and open in notepad or whatever text editing software you want.

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! You can either drag to select everything or simply press the "CRTL" and "A" keys on your keyboard at the same time to select all the data of the Google Sheet. Control + A on the keyboard is more reliable than trying to drag select all the data.

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

How to Copy Data From Multiple Pages on a View Only Google Sheets (Works in 2025)