Excel .xlsb Files in 2018.1

I've seen references to the fact that Alteryx Developer 2018.1 (I'm using the non-Admin version) is able to recognize Excel's .xlsb file format as a data input source. However, I don't see that format in the dropdown list of available data files, and choosing any other source I've tried doesn't recognize the xlsb files either.

How does one use an Excel .xlsb format file as a data source in Alteryx Developer 2018.1?

Input

Accepted answers

pliskers_dup_528

Replying to my own message because I found, via another posting, that to recognize Excel .xlsb files, you must have a Microsoft driver installed for Access 2010. I found the driver here:

https://www.microsoft.com/en-us/download/details.aspx?id=13255

Once installed, the xlsb files will appear in the list of All Data Sources when adding a new input.

Alteryx, this should be more clearly communicated - I've seen a lot of posts from users who were eager for this feature.

All comments

pliskers_dup_528

Replying to my own message because I found, via another posting, that to recognize Excel .xlsb files, you must have a Microsoft driver installed for Access 2010. I found the driver here:

https://www.microsoft.com/en-us/download/details.aspx?id=13255

Once installed, the xlsb files will appear in the list of All Data Sources when adding a new input.

Alteryx, this should be more clearly communicated - I've seen a lot of posts from users who were eager for this feature.

MichalM

Hi @pliskers_dup_528

You'll need to make sure that you have the correct Access driver installed as specified in the Supported Data Sources page within Help section.

Please let me know whether this makes a difference.

Thanks

Michal

MichalM

30s too late

pliskers_dup_528

Yes, that worked for me. I was under the initial impression that the xlsb files would simply be recognized by Alteryx without the installation of other software. Problem solved. Thanks for the quick reply.

johnzrgu75

Just want to follow up if server side can read xlsb as well.

MichalM

Yes, the same is true for the server as long as the correct driver is available on the server infrastructure.

Sri9

Thanks

wingky

I am an Alteryx 2019.4 User. My workplace does not allow to install MS Access 2010 SP2 driver, but allowed me to install MS Access Runtime 2016 driver. Why does MS Access 2016 driver does not work ?

Is there any other solution to read xlsb files .. like using python as workaround ?

ThankForYourHelp

that link is no longer work @MichalM @pliskers_dup_528 do you guys have another link that I can use?

Thank you

curator_at_work

this driver is not there now

Screenshot 2025-03-04 181855.png

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335