Read multiple xlsx files from a directory

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.

Capture read several files at the same time.PNG

Input

Tips and Tricks

Macros

Best Practices

Preparation

Accepted answers

@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/158871

All comments

@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/158871

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

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

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

Quick Links

Tags

This months top contributors

atcodedog05 19458

Qiu 15866

MarqueeCrew 13708

apathetichell 13703