Hi All,
I work a lot with XLsb files and want to ask if anyone has come up with a way to read only XLsb files. I want to extract some data from these files to run some analysis.
Thanks
@Dynamomo
Love this macro
@LordNeilLord
Part time Tableau, Part Time Alteryx. Full Time Awesome
Hi @JulianV,
xlsb files are now supported in Alteryx 2018 so if you upgrade to that, you should be good.
If you don't want to upgrade, another option is the Excel Holiday Macro that was built by an Cameron Steele at Alteryx. IT's a really awesome macro that makes bringing in Excel files a lot easier. check out the blog post - https://community.alteryx.com/t5/Engine-Works-Blog/The-Ultimate-Alteryx-Holiday-gift-of-2015-Read-ALL-Excel-Macro/ba-p/9988
if you scroll to the bottom of it, you will see a link to it in the Gallery.
Hi Dynamomo,
I have the latest version of Alteryx (11.8.4) but still does not support xlsb files. The Excel Macro Holiday works for me so thank you for your help
The latest version of Alteryx is 2018 (not 11.8). Here is a blog post on the release - https://community.alteryx.com/t5/Analytics-Blog/Alteryx-Analytics-2018-1-The-Modern-End-to-End-Platform-that-is/ba-p/141520
at the bottom of the post is a link to how you can download 2018.
I've updated the version to 2018.1 while I still could not see xlsb files when I try to use "Input Data" to import file. Could you please help guide me how to import xlsb files in 2018.1 version? Do I need to use other button instead of "Input Data"? Thanks!
Version Number 2018.1Only xlsx can be recognized in Input dataTest source files xlsb & xlsx
Just found that I could solve this issue via installing 2010 Access driver (https://help.alteryx.com/current/index.htm?_ga=2.179904551.2045524413.1524734394-1043496302.1517290158#DataSources/SupportedDataSources.htm). No worries about this. Thanks for adding this feature in 2018.1 version!
Hi @Dynamomo,I am connecting to some .xlsb files but I can not see the option in the dropdown of the input tool. I am using Alteryx 2019.1 version which I download recently, I have 2018.3 on another laptop and I can find that option easily, any idea why this might be happening? Thanks,
I am using 2020.4 and have MS Access 2016 installed, still cannot handle xlsb file. I am not allowed to install MS Access 2010 driver in my office. Any solution ?
