I need to combine some excel files (multiple sheets within multiple files). I went to import the data (.xlsb file) from Excel 365. Alteryx will not recognize the files for import for some reason. I tried clicking on different file types under 'file format,' but none of them seemed to work. When I go to import, nothing appears in the folder I want to bring the files in from.
Thanks!
You most likely don't have the necessary driver installed.
See this article for more information on what you need to install, and step by step instructions: