How To: Import some worksheets from one Excel file

[eduardomarchesin]

Hi team,

I have an excel file with some worksheets, so, only some worksheets have the same schema. I would like to import only worksheets with the same schema. 

I was thinking to create a text file and include the name of the worksheets that have the same schema, and after that to do a filter in the excel file. Is it possible, do you have another way to do that? Could you help me, please?

I've got the all worksheet's names:

Rgds

Eduardo

[BrandonB · Accepted solution]

You might find this macro helpful: https://community.alteryx.com/t5/Engine-Works/The-Ultimate-Alteryx-Holiday-gift-of-2015-Read-ALL-Exc... 

It allows you to point at a directory and bring in as many sheets as you want from the Excel files regardless of schema. You can add additional logic if desired.