Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

working with xlsb files in Alteryx

JulianV
5 - Atom

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 

12 REPLIES 12
Dynamomo
11 - Bolide

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-AL...

if you scroll to the bottom of it, you will see a link to it in the Gallery.

LordNeilLord
15 - Aurora

@Dynamomo

 

Love this macro

 

@LordNeilLord

Part time Tableau, Part Time Alteryx. Full Time Awesome


Data Lover

JulianV
5 - Atom

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

Dynamomo
11 - Bolide

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-Platf...

at the bottom of the post is a link to how you can download 2018.

 

 

SilviaPeng
5 - Atom

Hi Dynamomo,

 

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.1Version Number 2018.1Only xlsx can be recognized in Input dataOnly xlsx can be recognized in Input dataTest source files xlsb & xlsxTest source files xlsb & xlsx

 

SilviaPeng
5 - Atom

Hi Dynamomo,

 

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.15172901...). No worries about this. Thanks for adding this feature in 2018.1 version!

 

CharlesColeman
5 - Atom

Here's another vote for that.  Just downloaded 2018.1, had the same issue, and, as I have 32-bit Office installed on this (64-bit) machine, the 32-bit Access driver took care of it.

 

This is fantastic; thank you!

MarcSchoenwandt
5 - Atom

You can get the drivers here. You will need Admin permissions to be able to install the drivers.

 

Khuzai
5 - Atom

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, 


-- Solved -- My bad, noticed the Access driver fix after posting this comment.
Labels