Merge 64 excel files into a consolidated sheet

Help StudioX
,
1

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:

2

Hi @Super_Sonic

Welcome to UiPath community

Check out the video link

Regards
Gokul

1 Like
3

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

4

Thank you, Gokul.

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

5

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

6

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

7

Sure, let me try that :slight_smile:

Thank you!

8

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

9

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

Thanks

1 Like
10

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
11

Good to hear that :grinning:

1 Like
12

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