Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
BOYERWMAP
Contributor III
Contributor III

QlikSense: Connect an Excel Spreadsheet

I created an app to track campaign activity on accounts listed on a spreadsheet as our CRM system doesn't tag accounts with a campaign, only activity.  

I would like this spreadsheet to be a live connection in Qlik from where it lives on my OneDrive vs having to load a new spreadsheet every time I add something to it.  Is there a way to do this?

Labels (1)
1 Solution

Accepted Solutions
hugo_andrade
Partner - Specialist
Partner - Specialist

Hi @BOYERWMAP ,

Qlik Sense has built-in connectors to Onedrive and Sharepoint.

I'm attaching the documentation for you: https://help.qlik.com/en-US/connectors/Subsystems/Web_Connectors_help/Content/Connectors_QWC/Data-So... 

If you run into issues, paste them here for assistance 🙂

Live and Breathe Qlik & AWS.
Follow me on my LinkedIn | Know IPC Global at ipc-global.com

View solution in original post

2 Replies
FedericoDellAcqua
Creator II
Creator II

Yes of course, you need to create a data connection to your onedrive and then take the data from that.

feel free to leave a  like to this comment if it helps you out!
Federico

hugo_andrade
Partner - Specialist
Partner - Specialist

Hi @BOYERWMAP ,

Qlik Sense has built-in connectors to Onedrive and Sharepoint.

I'm attaching the documentation for you: https://help.qlik.com/en-US/connectors/Subsystems/Web_Connectors_help/Content/Connectors_QWC/Data-So... 

If you run into issues, paste them here for assistance 🙂

Live and Breathe Qlik & AWS.
Follow me on my LinkedIn | Know IPC Global at ipc-global.com