Hey Guys,
I'm looking to import data from a specific sheet in a Google Spreadsheet document to my Excel worksheet.
Now I know that we can, in Google Spreadsheet do "Publish to the Web" then receive a link, but when I go to Excel and want to import data from web (Data -> From Web) then paste the link that I received from Google Spreadsheet - I got an error "Object doesn't support property or method "addEventListener" (if I ignore and refresh, the data is badly imported).
On the other hand, if I copy the URL of the Google Spreadsheet document (without publishing to web) and paste that URL in Excel (data from web), then it works but it basically import everything from the G-spreadsheet (including editing options) + the number of rows is limited to 234 in Excel.
It's nice but problematic if I want to import the data from one specific sheet and not all the Google Spreadsheet.
Is there a way to import the data only from a specific sheet?
Many thanks!
Bookmarks