Read multiple xlsx files from a directory

[guigui17]

hello the community,

I am trying to upload 12 excel files that are all similar (name of sheets and directory location.

I have tried to use the tool here below but I don't know which to use after that (Macro ?).

Could you recommend which tool palette to use ?

Thanks a lot in advance for your advice.

 

[Qiu · Accepted solution]

@guigui17 
If you search by key word *Multiple Excel*, you get many answers, for example

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Importing-multiple-excel-files/td-p/15...

[Emil_Kos]

Hi @guigui17,

You can try this macro. It is really helpful and easy to use:

https://gallery.alteryx.com/#!app/Read_All_Excel_Files/58dd51b3a18e9e18fca64172

[smoskowitz]

Hi @guigui17 --

While @Emil_Kos is spot on with this recommendation of a macro to use, I would like you to also consider trying to build the macro yourself. I don't think its to difficult and is just a great learning opportunity. I am sure we can provide some guidance but give it a go. Once you get how the macro works, you will realize you can no longer live without it. 🙂

Thoughts?

Thanks,

Seth