Combine multiple excel files

Hi experts,

There are several excel files in a folder, all the files have a single sheet the schema is same but the sheet names are different for each file.
The ask is to import all the data and combine to a single output file along with the file name and sheet name in two separate columns in the output file.

I used a Directory tool to import all the files using wild card then used a batch macro to combine all the files, however I am not sure how to get file name and sheet name in two separate columns in the output file.

Macros

Accepted answers

atcodedog05

Hi @taymadar

Try this workflow:

Hope this helps : )

Multiple Sheets Multple Excel Files.yxzp

All comments

atcodedog05

Hi @taymadar

Try this workflow:

Hope this helps : )

Multiple Sheets Multple Excel Files.yxzp

taymadar

Hi @atcodedog05 thank you so much for the prompt response. This solution worked perfectly 🙂

atcodedog05

Happy to help : ) @taymadar

Cheers and have a nice day!

ACampbell1

Thank you, this helped my issue as well.

Is the red symbol a macro?

AnkitDwivedi6

Hi , i am looking for workflow where i need to consolidate multiple excel files in the folder but few excel doesn't have sheet available but the ones have need to be merged in single file.

flying008

Hi, @AnkitDwivedi6

As your said "but few excel doesn't have sheet available..." , What's your mean?

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703