Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
srikanth1994
Contributor
Contributor

How to load excel from share point to Qliksense

Hi learners,

I am new to Qliksense how to load excel file from SharePoint to Qliksense,for me connection created but not picking the Excel 

Labels (3)
1 Solution

Accepted Solutions
Vinay_B
Support
Support

Hi @srikanth1994 

Below are the supported file types in Office 365 SharePoint connector:

You can select and load data from the following files types:

  • Delimited files: csv, txt, tab, qvo, mem, shv, prn, log
  • Excel files: xls, xlw, xlsx, xlsm
  • HTML files: html, htm, php
  • KML files: kml
  • Fixed record files: fix, dat
  • QlikView data files: qvd
  • QlikView data exchange files: qvx
  • XML files: xml

Please note that you cannot load or store a file that does not contain a filename extension. So please make sure that file has an extension. 

FYI: https://community.qlik.com/t5/Knowledge/How-to-load-a-file-from-SharePoint-365-using-Qlik-Using-Qlik... 

I hope this helps!

If this resolves your query, please click on "Accept as Solution" for confirmation. Thanks!

View solution in original post

1 Reply
Vinay_B
Support
Support

Hi @srikanth1994 

Below are the supported file types in Office 365 SharePoint connector:

You can select and load data from the following files types:

  • Delimited files: csv, txt, tab, qvo, mem, shv, prn, log
  • Excel files: xls, xlw, xlsx, xlsm
  • HTML files: html, htm, php
  • KML files: kml
  • Fixed record files: fix, dat
  • QlikView data files: qvd
  • QlikView data exchange files: qvx
  • XML files: xml

Please note that you cannot load or store a file that does not contain a filename extension. So please make sure that file has an extension. 

FYI: https://community.qlik.com/t5/Knowledge/How-to-load-a-file-from-SharePoint-365-using-Qlik-Using-Qlik... 

I hope this helps!

If this resolves your query, please click on "Accept as Solution" for confirmation. Thanks!