Combine multiple excel files

Hi,

How do I create a pivot table based on data combine from multiple files based on the months?

For example in my folder I have files using dates.
File1_01012020.xlsx
File1_02012020.xlsx
File1_03012020.xlsx
File1_04012020.xlsx
etc…

I want to combine all this file from that month for example all files from January in one excel and produce a pivot table based on the combine data.

For the pivot part, I might use Macro to do it.

Thanks in advance

Hi @jenkim,
You can try merging them with a simple Read Range, Write Range combination (See example below) or you might find this Marketplace Component helpful: https://connect.uipath.com/marketplace/components/merge-content-of-multiple-excel-files

CombineExcelFiles.xaml (7.4 KB)

Cheers!