Import multiple CSV excel files with different sheet name

[mihaicom20]

Hello everyone, 

I am trying to merge multiple excel files that have CSV extension and the sheet name is different for every file. The files schema is the same.

Is there any macro that can merge multiple CSV excel files? I tried to find smth similar on  community.

Thank you in advance!

[binuacs]

@mihaicom20  a batch macro should work in this scenario

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/The-Ultimate-Input-Data-Flowchart/t...

[mihaicom20]

@binuacs I tried this kind of macro, but the problem is that I don't know how to apply it to CSV files

[mihaicom20 · Accepted solution]

@binuacs I found this as a solution

[binuacs · Accepted solution]

@mihaicom20 thanks I made some changes in the batch macro which i initially to only read .csv files with different sheet name