How to merge different excel files into single excel file

[AJ_Ask]

How to merge different excel files into single file as different sheets

Hi @anjani_priya You can use this Method for each file in a folder in that use filter to get all excel files, replace the folder path with your folder path [image] Use read range to store the data of excel sheet into the datatable [image] Use another excel file which will add the new sheet with file name & write the datatable to newly added sheet using insert sheet & write datatable to excel activity [image] Use this workflow for your ref: Excel_auto (2).zip (124.8 KB) Hope this help…