Inputting Multiple Excel files with Multiple Sheets (Same Structure)

Question

Hello everyone,

I have many Excel files and each contains 4 sheets with same structure. I want an automated way to import 3 sheets from all of the Excel files. The sheets name are: Sheet_1, Sheet_2, Sheet_3, and Sheet_4. I don't want Sheet_4, only the first 3 sheets. The idea is to build a workflow so the next person will only need to run the workflow to have all of the data in one table.

Thanks in advance

AncientPandaman · Accepted Answer

this should be an old topic, but here the method.

* input sheet name with full file path(for 1st file)
* filter first three sheet
* use formula (replace list of sheet name to sheet name)
* dynamic input
* change the input filename in step 1 (Input_1.xlsx to Input_*.xlsx)

provided all structure. (included same header name, header sorting, data type and the number of empty column)

even the sheetname data type...

messi007 · Accepted Answer

@Maltaleb001,

Please have a look on :

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/How-To-Import-Multiple-Excel-Sheets-or-a-Specific-Excel-Range/ta-p/398220

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Read-All-Excel-sheets/td-p/504251

Hope this helps,

Regards