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

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
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