Importing multiple XLSX files which are in the same folder and has different sheet names

[dizy_11]

Hi I'm working with large number of xslx files which are in same folder but has different sheet name. I want to import these files in the designer without importing all with different input tools. Can anyone please tell an easy solution for this.

Thanks!

[atcodedog05 · Accepted solution]

Hi @dizy_11 

This blog might help you out https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/The-Ultimate-Input-Data-Flowchart/t...

[Alteryx_AR]

@dizy_11 

Hope this link helps you-

https://community.alteryx.com/t5/Interactive-Lessons/Connecting-to-Multiple-Sheets-at-Once/ta-p/8287...

All the best 👍

[wlau]

You basically need two things:

1. You need a list of all the different sheet names.  

2. You need to configure a dynamic input to use the different sheet names.

There are different ways to create your sheet names,

If all your workbooks have the same sheet names, then you can use a normal input Tool, connect to any of your workbooks and "import only the list of sheet names". 

If you have a situation where you have different sheet names in different files, it's a bit more complicated.  You would need to build the full path somewhere and then use that in the dynamic input and change the Action "Change Entire File Path".  

Hope this helps

[shreyanshrathod · Accepted solution]

@dizy_11 ,

Something like this should work for you.

Attaching a workflow for reference.

Let me know if it helps.

Regards,

Shreyansh Rathod