Extract Data table from Google Spreadsheet


How can we extract data table from Google Spreadsheet which is in structured format?

(Webscrape is not able to recognize individual elements.)

I tried using Get OCR Text but that’s not feasible for a big excel report. Any idea how can we do it? (without downloading the excel)


I have also tried below method which gives us result,

Click on Spreadsheet
Send hot key (Ctrl + A)
Open excel in local system
Send hot key (Ctrl +V)
Process it further

but was looking for something which directly gives a datatable


Workaround: download the spreadsheet as Excel.


Check this out Google Spreadsheet Activities