How to merge multiple excel files into a new file

i have all my three excel files in single folder and now i have to merge all together in a new excel file can anyone suggest me how to do it?

1 Like

@kaavya

Is the Schema of all three Excel sheets are Same.?

Regards,
Mahesh

If all of your files have the same columns, you can do the following:

  1. Get list of all files in your folder
  2. For Each loop on your result from 1
  3. Read range on workbook
  4. Use the Merge Datatable activity to append each Datatable to a master Datatable

yeah.

Hi @kaavya

You can also try to use this component. This has a template that supports your need

https://go.uipath.com/component/merge-content-of-multiple-excel-files

1 Like

thank you

1 Like