How to import .xlsb

[Kamran1991]

Alteryx does not give the option to import the excel file with extension .xlsb.

Somebody please help me on this.

Any support will be highly appericated.

Thanks,

Kamran

[ShankerV]

Hi @Kamran1991 

Please find the below link whether a similar issue has been resolved.

Hope this link will help to resolve your issue too.

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Excel-xlsb-Files-in-2018-1/td-p/159152

Many thanks

Shanker V

[Felipe_Ribeir0]

Hi @Kamran1991 

One way of doing this is by using one of these macros:

https://community.alteryx.com/t5/Community-Gallery/Read-All-Excel-Files/ta-p/897750

https://community.alteryx.com/t5/Community-Gallery/XLSB-Reader-and-SheetNameReader-macro/ta-p/951949

https://community.alteryx.com/t5/Community-Gallery/Convert-xlsb-into-xlsx-and-parse-the-input/ta-p/1...

[ArtApa]

Hi @Kamran1991 - Alteryx requires Microsoft Access Database Engine 2010 driver to be installed to natively read xlsb format: https://www.microsoft.com/en-us/download/details.aspx?id=13255 

This solution was also provided in one of the links above.

[DanielG]

@ArtApa - I know this is a late response on this thread, but was wondering if this is still the optimal solution for Windows 11 machines.  According to the Microsoft site this driver is only supported up to Windows 10.  Or does that not matter?

[subha11]

Thank you