Is there a simply workflow to merge a lot of excel files at once?

[rmartori]

Basically I can have upwards of 20 files and I need to make them one file but each file ends up on its own sheet in the output file.

I thought just copying and pasting input and output over and over but was curious if there was another way.

[christine_assaad · Accepted solution]

Hi @rmartori 

If all your files share the same schema (headers, types,..etc), you can use the

1-  "Directory" tool and point it to the folder where your excel files are saved.

2- Add a dynamic input to loop thru the different files and stack them on top of each other.

Hope this helps! Cheers!

[oracleoftemple]

If the files have different schema, which might be the case even if they look identical (same fields and data types), you can use this macro that merges the files in spite of their different schema.