Merge multiple Excel files into a separate work sheets in single excel file

Help Studio
1

  • How to merge multiple Excel files into a multiple worksheets in single excel file?

  • Keep the file name as a worksheets name

Input files :
sample_file2.xlsx (9.2 KB)
sample file1.xlsx (9.2 KB)

Expected Output:

details_data__2025-04-10.xlsx (10.0 KB)

2

Hi @Sathish_Kumar_S

Can you try this

A UiPath automation workflow for processing Excel files from a specified folder, copying data from each sheet of input files to a new output file. (Captioned by AI)
A UiPath automation workflow for processing Excel files from a specified folder, copying data from each sheet of input files to a new output file. (Captioned by AI)774×1828 57 KB

Sequence5.xaml (19.4 KB)

Regards,

3

Hi Sathish,

Here’s the solution and I have also attached the solution file.

Forum1.zip (21.6 KB)

image
image373×505 17.9 KB

Happy Automation :slight_smile:

Regards,
Pavan Kumar Gente

4

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