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

"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."

Workflow

Output

Tips and Tricks

Macros

Transformation

Accepted answers

binu_acs

@adarsh2608 try the below batch macro

Write_To_Sheets_31052024.yxzp

All comments

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

@adarsh2608 try the below batch macro

Write_To_Sheets_31052024.yxzp

Quick Links

This months top contributors

hhaigh1 280

FláviaB 262

JORGE4900 235

caltang 177

DanM 167