how to convert .xlsb file to .xlsx ?

[Alteryx_user_aK]

Hi,

One of the input file I am receiving is .XLSB (binary format). I am not able to read it thru input file tool.

What is the best way to covert/read .xlsb file in Alteryx ?

thanks in advance

aK

[PhilipMannering]

You should be able to read the file in using the Output Data Tool as an xls file type.

You may need to install the Microsoft Access Driver, available here: https://www.microsoft.com/en-US/download/details.aspx?id=13255 

I just installed the 32 bit version and it worked for me,

[Felipe_Ribeir0]

Hi @Alteryx_user_aK 

Another options,

1-You can convert .xlsb to. xlsx - and import the xlsx data to the same workflow - using this macro: https://community.alteryx.com/t5/Community-Gallery/Convert-xlsb-into-xlsx-and-parse-the-input/ta-p/1...

2-You can try to read them directly with this macro: https://community.alteryx.com/t5/Community-Gallery/Read-All-Excel-Files/ta-p/897750

[Alteryx_user_aK]

Hello Felipe,

Appreciated your reply. I have downloaded the macro to read the .xlsb file but getting below error. Tried to fix it but somehow did not work.

going with option#2.

Excel File Opener (5) Tool #3: Record #1: Tool #26: The external program "..\SupportingFiles\unzip.exe" returned an error code: 9
Tool #30: The field "Sheet Names" is missing. Compare the tool configuration with the input stream.

Any points on fixing these issues.

Thanks

aK

[Felipe_Ribeir0 · Accepted solution]

Hi @Alteryx_user_aK 

I tried here, unfortunately got the same error with the Read_All_Excel_Files macro. Maybe it need to be updated for some reason, it used to work fine.

So, i suggest you to try the first option (convert xlsb to xlsx). This macro is mine, so i can help you more if you have any issue using it: ttps://community.alteryx.com/t5/Community-Gallery/Convert-xlsb-into-xlsx-and-parse-the-input/ta-p/1....