article How to Load an Excel File on SharePoint in Qlik Cloud in Official Support Articles

How to Load an Excel File on SharePoint in Qlik Cloud

Troy_Raney — Fri, 08 Sep 2023 12:15:58 GMT

Using Office 365 Sharepoint Connector (single file)

Identify base URL and site/Subsite Path. For example:
- BaseURL:
- Site/subsite path: sites/SupportTrainingandEnablementDevelopmentArea
Configure the Connection
Click on the Authenticate button
Copy the Authentication code from the Authentication tab into the field and click 'Verify'
Proceed to the app by clicking on the Create and Analyze button
Locate and select file in the folder
Select Table and Fields
Apply and necessary table associations
Load the data

Environment

Qlik Cloud

The information in this article is provided as-is and to be used at own discretion. Depending on tool(s) used, customization(s), and/or other factors ongoing support on the solution below may not be provided by Qlik Support.

Click here to see the video transcript

@Bjorn_Wedbratt

Re: How to Load an Excel File on SharePoint in Qlik Cloud

FedericoDellAcqua — Thu, 04 Jan 2024 11:05:49 GMT

Good morning Troy!

Thank you very much for the detailed explanation!

I'm implementing the connector but I have a question: is it possible to connect only to a specific subfolder using only the basic sharepoint connector?

Thank you in advance!

Federico.

Re: How to Load an Excel File on SharePoint in Qlik Cloud

Sonja_Bauernfeind — Mon, 08 Jan 2024 10:07:35 GMT

Hello @FedericoDellAcqua

Please post your query in the Qlik Sense Connectivity and Data Prep forum. This will give you a broader audience and allow our active support agents to see your question.

All the best,
Sonja