Extract Data table from Google Spreadsheet


#1

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)


#2

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


#3

Workaround: download the spreadsheet as Excel.


#4

Check this out Google Spreadsheet Activities