Combine multiple excel files

Learning Hub Academy Feedback
, ,
1

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

2

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: Merge Content of Multiple Excel Files - RPA Component | UiPath Marketplace

CombineExcelFiles.xaml (7.4 KB)

Cheers!