Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Converting Excel Type

Highlighted
8 - Asteroid

I currently have a lot of excel files that I am importing into excel as binary (xlsb). I would like to convert them to excel XLXS format in the Alteryx workflow. Is that even possible instead of converting them in the workflow instead of out the workflow.

Highlighted
Alteryx
Alteryx

You can use Input Data tool in Alteryx to read a xlsb file in and Output Data tool to write it into xlsx. So the answer is yes.

Highlighted
5 - Atom

Hi, Good wishes.  Can you help me in getting a sample with screenshots so that I have a better understanding and implement in my process?

 

Currently, I am using 2018.3

 

Thanks in advance. 

Highlighted
Alteryx
Alteryx

@Sathishu1985 

 

In order to read in xlsb file into Alteryx, you will need the 2010 Access driver which can be downloaded here

 

https://help.alteryx.com/current/DataSources/SupportedDataSources.htm?Highlight=xlsbhttps://help.alteryx.com/current/DataSources/SupportedDataSources.htm?Highlight=xlsb

 

Once installed, you can bring the file in using the Input Data tool and write it as XLSX using the Output Data Tool (example attached)

 

xlsb-to-xlsx.png

 

 

 

Highlighted
14 - Magnetar
14 - Magnetar

Hi @chughes49 

 

If you're working with the data in Alteryx, there is no need to convert it from an xlsb to an xlsx. If Alteryx can read it, it can work with it.

 

As long as your data can fit in an xlsx file, you can use the Output data tool to save it out with a different format than you read it in with, or a Table and Render tool if you need to apply different formatting.

 

Let me know if that helps.

 

Cheers!

Esther

Highlighted
7 - Meteor
I need to convert XLS to XLSX for files with multiple tabs to be processed properly. Would the download of the driver help address this? Workflow will run on Alteryx server so any added information regarding that is appreciated. I’m thinking driver method might mean we don’t need to convert.

Thanks.
Highlighted
Alteryx
Alteryx

@TimN 

 

What do you mean by processed properly please?

Highlighted
7 - Meteor

Hi,

I meant that we have problems dealing with multiple tabs dynamically in an XLS file whereas we have no problem in an XLSX.

 

Thanks,

 

Tim

Highlighted
6 - Meteoroid

Getting error as not known file type!

Highlighted
6 - Meteoroid

I have Alteryx 2018 x64 version 2018.4.4.54346 and still i could not see xlsb in the Input tool list. 

Labels