How can I concatenate many excels?

Hello, I want to concatenate a number of 15-20 excel files and I need to keep the headers just for the first excel and the other ones to be appended from the bottom without the headers.

How can I do this?


Use write range for the first file and for all others use append range activity


Alternately…read each file and use merge datatable activity to merge the data and write using write range for once

Hope this helps


Hi @adrianab.98

Use a read range to read the first excel, make sure the option add headers is enabled, then follow this example
Main.xaml (12.9 KB)

make sure to replace all the corresponding values


I can’t open the file. “Document is invalid” I tried to open in multiple ways but failed

Try again with this
ForumW (2).zip (10.4 KB)