How to pull multiple excel worksheets from multiple excel files into Alteryx

[Bluesky]

Hi

Can someone help me with a formula or process for setting up and creating a workflow to pull data from multiple excel worksheets from multiple excel files into Alteryx? I'd like to add a date stamp column and transpose some rows into columns as well.

Thank you

[apathetichell]

Usually this is where@Qiu and @mceleavey take over...

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Read-sheet-with-same-name-from-multipl...

[DawnDuong]

Hi @Bluesky the community has many posts that address this question about importing multiple tabs from multiple files. I cannot find the post (really old one) that I used to refer to. The most comprehensive one I can find now is outside the community though

https://www.linkedin.com/pulse/how-import-multiple-excel-sheets-files-different-schema-bingqian-gao

Dawn.