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