Combining Multiple Excel Files into Separate Sheets in a Single Output File

[adarsh2608]

"I have five Excel files, each with different column names and containing approximately 55,000 to 100,000 entries. I want to combine these files into a single Excel file, where each input file is added as a new sheet in the output Excel file. I tried using the block command, but it didn't work because I encountered an issue with one of the Excel files."

[cjaneczko]

What is the error you are receiving and what does your workflow look like? 

[adarsh2608]

Hello @cjaneczko 

First i tried with render . But it is taking around 30 min to  complete the task

Then when i tried using union and forumula tool it is creating multiple sheets but columns are shared in all sheets where these columns are either of different excel.sheet

[binu_acs · Accepted solution]

@adarsh2608 try the below batch macro