How to load data from google docs spreadsheet?

[#1]

Hi,

I have few files on google drive spreadsheet. Can someone kindly share a simply way of how to load the data from google drive

For example I have the same excel sheet on my drive locally and this is the loadscript for it

LOAD a,

     b,

     c,

     d

FROM

[test.xlsx]

(ooxml, embedded labels, table is [RAW DATA]);

How do I load the same file from google drive spreadsheet?

Arif

[omerfaruk]

Hi,

One alternative to loading Google spreadsheets is using a link in the following format:

https://docs.google.com/spreadsheets/d/1kIpJZ148hMFxN3nGPPKBhbQyov734um6ahBcMNG1xD0/export?format=xl...‌

This format allows you to export as xlsx. The document needs to be shared as anyone has the link can access the document.

[JuanCharleston]

Thank you so much @omerfaruk ! I have tried a couple solutions from various posts but only yours still work for now in 2021! My QlikView can load more than 100 lines (mine is 362 rows) from Google Sheets finally. Great Work!!!