How to extract data from an excel file on google drive

[#1]

Hi All,

I am trying to link my excel sheet to my dashboard, my excel sheet is on google drive and I have set the permission to public.

But qlikview cannot access the file and is giving this msg.

Any Ideas?

[Gysbert_Wassenaar · Accepted solution]

Then the link you have is not the download link. If you open that link in a browser you'll probably see a preview version rendered in html. And there'll be a link somewhere on that page to actually download the real xlsx file. If you use that link in qlikview then you will be able to retrieve the data.

This one doesn't work: https://drive.google.com/file/d/0B9CnVNY_TWtTYUF2RU91SUhpVVk/view?usp=sharing

But this one does: https://doc-0c-60-docs.googleusercontent.com/docs/securesc/ha0ro937gcuc7l7deffksulhg5h7mbp1/hci5f4gq...

T1:

LOAD Dim1,

     Dim2,

     ID,

     E,

     D,

     C,

     B,

     A

FROM

[https://doc-0c-60-docs.googleusercontent.com/docs/securesc/ha0ro937gcuc7l7deffksulhg5h7mbp1/hci5f4gq...]

(ooxml, embedded labels, table is Sheet1);

[#3]

Thank you Gysbert, it is working great now.