Qlik Community

Qlik Sense Cloud Discussions

HAAM
New Contributor II

connect to excel

Hello,

I am very new Qlik user. I use qliksense cloud to build an app and I have different types of data sources. My question is: 

can I connect an excel file to qliksense in a way where I can edit this excel file and the data will be updated on qliksense app? And can I save this excel file on OneDrive?

 

Thanks in advance

1 Solution

Accepted Solutions
Highlighted
VMR
New Contributor II

Re: connect to excel

Hi,

Welcome to Qlik!
There is a way to do it using Google Sheets. What you need to do is to import it to your google drive and then publish it in the web. You can see here how: https://support.google.com/docs/answer/183965?hl=en-GB

Attention this will be avaialble for anyone that have access to the published URL.
After publish create your data connecter using the URL of the published document.
Now each time you change your data the Web page shall be updated. To reload the data you will need to reload the data in the Qlik Cloud.

Have fun!

View solution in original post

1 Reply
Highlighted
VMR
New Contributor II

Re: connect to excel

Hi,

Welcome to Qlik!
There is a way to do it using Google Sheets. What you need to do is to import it to your google drive and then publish it in the web. You can see here how: https://support.google.com/docs/answer/183965?hl=en-GB

Attention this will be avaialble for anyone that have access to the published URL.
After publish create your data connecter using the URL of the published document.
Now each time you change your data the Web page shall be updated. To reload the data you will need to reload the data in the Qlik Cloud.

Have fun!

View solution in original post