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

  

[vj28]

Did you manage to find out whether this works for Win 11 machines?

[NISHA_373]

Hi, I have a similar problem, but instead of .xlsb, I want to read and write .cmd files. This extension is not available in alteryx. Is there any way to output .cmd files. I am using directory tool to import the files. I do not want anything to be changed inside the file, I just want to copy .cmd files from 1 folder and paste it to another folder.