is there a limit to number of columns for xlsb file input?

[Kate]

the file I want to use has ~460 columns in but only 255 are currently being input.  Is there a way of inputting all 460 for an xlsb file?

THanks

[JakeS · Accepted solution]

Hi @Kate

Looking at the Alteryx Excel help documentation under the "lengths and limits" section:

While this documentation is for xlsx files, the binary files are read using the Legacy Driver for Microsoft Excel, putting a limit at 255 columns. You can get around this by converting the file to xlsx if possible. 

Jake