Merge 64 excel files into a consolidated sheet

Hi Community! Good Morning!

Every month, I’m downloading 64 excel sheets with similar columns and would like to consolidate it into a master excel sheet.

Is it possible to do this through StudioX? I’m sort of lost trying to figure this out.

Thanks in advance! :slight_smile:

Hi @Super_Sonic

Welcome to UiPath community

Check out the video link

Regards
Gokul

1 Like

Hello @Super_Sonic
Yes, It is possible to merge all data into a single Worksheet.

Just read all 64 excel files and merge or append data in a master excel file.
Kindly refer to this thread, it may help you

Thank you, Gokul.

I’m trying this on StudioX and not Studio. Will this work on StudioX too?

Hello @Super_Sonic

Welcome to Uipath community…!

Are you trying to read different excel and write that to different sheets in the master excel or do you need to write all data to the same sheet? If yes, you can use Append Range activity.

Thanks

Yes it will work. Can you check and let us know if you have any issue @Super_Sonic

Sure, let me try that :slight_smile:

Thank you!

Are you trying to read different excel and write that to different sheets in the master excel or do you need to write all data to the same sheet? need to write all data to the same sheet

Then you can use as in the video and use Append range instead of Read range activity. Provide the same sheetname.

Thanks

1 Like

I tried your solution and used append instead. It worked for me.

Thank you so much, Rahul! :slight_smile: You are the best! The video was simple and straightforward to understand.

Cheers!

1 Like

Good to hear that :grinning:

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.