Merge Two Excel Files without losing any data

[Karthik_Murugesan]

We have data in two types in excel files we want to Consolidted into single files without losing any headers and columns. Sheet Name are Same, If you sent your approach step by step helpful.

Type 1-

Type2-

Output-

Thanks,
Karthik Murugesan

[Parvathy (PS Parvathy)]

Hi @Karthik_Murugesan

Check out this thread. It might help you.

Merge multiple excel files

Hi Kinder, Merge datatable will not be applicable if that is the case. You may check on the updated workflow: MergeExcel_v2.zip (35.7 KB) I recommend you take the Basic foundation Training of UiPath on their academy platform. It is free BTW.

Regards,

[Yoichi]

HI,

Can you try the following step?

First Merge 2 datatables using MergeDataTable

Next, sort columns which you want, using FilterDatTable

Finally write it to xlsx.

Sample
Sample20231003-1L.zip (15.0 KB)

Regards,