Combine multiple excel files

[taymadar]

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.

[atcodedog05 · Accepted solution]

Hi @taymadar 

Try this workflow:

Hope this helps : )

[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?