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

Question

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

DawnDuong · Answer

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.

apathetichell · Answer

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

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Read-sheet-with-same-name-from-multiple-excel-files/td-p/770769