Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
Contributor II

Loading xlsb file format in qlikview giving error

Hi

I am loading an excel file in qlikview having xlsb format and its not functioning properly why?

Paint1.png

2 Replies
Highlighted

Re: Loading xlsb file format in qlikview giving error

AFAIK, Qlik don't support .xlsb file. You have to convert it into either .xls,.xlsx, or .csv

Regards,

Great dreamer's dreams never fulfilled, they are always transcended.
Highlighted

Re: Loading xlsb file format in qlikview giving error

Hi Saksham,

You can load only xls, xlsx, xlsw, xlsm format files through qlikview wizard.

Capture.PNG

If you want to load xlsb format you can use ODBC connection. Below link may help you further.


How to get data from xlsb to QlikView