Identify sheet names in multiple excel files

[sn2200]

hi,

I have multiple excel files with differently named multiple excel sheets inside them. How can i use Alteryx to identify all the excel files with the set criteria sheet names?

[alexnajm]

You can use the Input Data tool to read in the excel file, but instead of reading in a specific sheet you can select "Import only list of sheet names"!

[sn2200]

Thank you Alex for your quick assistance. 

Your approach is listing out all the sheet names but is there a way to get the file name also along with the sheet names? And then read the excel sheets which meets the set criteria.

[alexnajm]

Yes - in the same input data, you have the option to "Output File Name as Field"!

[Luke_C]

Hi @sn2200 

For multiple files you can follow the approaches in this thread: 

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/List-the-Excel-Worksheet-Names...

[_JAA_]

hi, is there a way to do this with the directory tool and without the batch macro? 

thanks-

[_JAA_]

i ended up using a solution from another thread. formula between directory input and dynamic input:

[FilePath] + "|||<List of Sheet Names>"

[alexnajm]

That's correct - you can do Directory --> Formula to add <List of Sheet names> --> Dynamic Input to get this list --> Formula to replace <List of Sheet Names> with actual sheets --> Dynamic Input to read in sheets