Alteryx Designer Discussions

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

read same sheet from xslm files

8 - Asteroid

I have nearly 65 excel(xlsm) files all have the exact same structure. Only the data is different. I have a summary sheet in all of the files and would like to input summary sheets into Alteryx designer from all the files. 


Please can someone show me how to do it. 

Alteryx Certified Partner
Alteryx Certified Partner

@ahsankhalid ,


I've worked through the reading of the xlsm's and used a Directory Tool to find them. Then used a dynamic input to read them all.  I also added the filename so that I know where each record comes from.









Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.