/ Google Sheets

Copy data from Google Sheets in a view only mode

This morning, I came across a Google Sheet in view only mode.

I needed the data in an excel for further analysis.

Here is a trick that worked.

Simple, go to URL and change the word after the document id (edit in my case to preview)!

;tdlr => change edit to preview in the URL

Then, simply select the data, copy the data, and paste it into an excel workbook. Works, perfectly.

The Google Sheet that I needed had only 100 rows and I was able to get all the data.

I am guessing the preview option would limit the data to a certain limit. Tough luck!

I'll try to find a different solution some other day! ;-D