Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

Input multiple xlsx files and union them

Alteryx Certified Partner

I always get the error no sheet specified. You must specify a sheet. I thought it would read all of them. Any help is highly appreciated!!!

Alteryx Partner



I applied the same method but there was success when one excel file contained one sheet only. But if we have many sheets in one excel file then this gave errors.


Can you please help in this?


Thanks in advance!


I encountered the same error. For all these records(#4, #26, #27) in the Directory tool, I had 1 sheet hidden in each Excel file.

alteryx multiple files Macro error.PNG



I believe you are supposed to specify the Sheet that you wish for Alteryx to read if you have more than one sheets in excel as Alteryx is unable to tell which sheet you are trying to read in.