Combining Multiple individual excel file in One Workbook

[sriniprad08]

Hi Team,

Hope you are well. 

I have 10 individual excel file. I need to combine all of them into one workbook with different tabs.

For e.g 

Individual excel file - A, B, C,D

Output - One workbook - E ( with A, B, C ,D ) as individual sheets.

Please let me know,

thanks,

Sri

[binuacs]

@samson211 the attached workflow should work for you

[samson211]

@binuacs Showing error

ErrorLink: Formula (5): https://knowledge.alteryx.com/index/s/article/Parse-Error-at-char-n-Unknown-variable-variable-name-E...Parse Error at char(47): Unknown variable "Sheet Names" (Expression #1)

I updated Formula as Replace([FileName], 'EQUIPMENT DETAILS LIST', [Sheet Names]), where EQUIPMENT DETAILS LIST is my sheet name, is this correct?

[binuacs]

@samson211 what is the output of the first macro?

[sanjeevmansotra]

Hello, my name is Sanjeev Mansotra a core educator. Here are the steps to combine 10 individual Excel files into one workbook with different tabs:

Step 1: Organize Your Files

Place all your individual Excel files in a single folder for easy access.

Step 2: Open Excel

Launch Microsoft Excel.

Step 3: Open the First Excel File

Open the first Excel file that you want to combine.

Step 4: Create a New Workbook

In Excel, create a new workbook by pressing Ctrl + N or by going to File > New.

Step 5: Rename the First Sheet

In the new workbook, rename the first sheet (tab) to match the name of the first Excel file by double-clicking on the sheet tab at the bottom and typing the new name.

Step 6: Copy the Data from the First File

In the original Excel file, select all the data by pressing Ctrl + A, then copy it by pressing Ctrl + C.
Go to the newly created workbook, click on the first sheet, and paste the data by pressing Ctrl + V.

Step 7: Add a New Sheet for Each Additional File

For each additional Excel file, repeat the following:
Click on the + button at the bottom of the workbook to create a new sheet.
Rename the sheet to match the name of the next Excel file.
Open the next Excel file, copy all its data, and paste it into the corresponding sheet in the new workbook.

Step 8: Save the Combined Workbook

After all files have been added to the workbook, save the combined file by going to File > Save As and choosing a name and location for the file.
Make sure to select Excel Workbook (*.xlsx) as the file type.

Step 9: Review and Organize

Review the workbook to ensure all the data has been transferred correctly.
If needed, reorder the sheets by dragging their tabs to the desired positions.

Now you have all your Excel files combined into one workbook with different tabs!

[samson211]

I will get back, @binuacs 

[samson211]

I tried this workflow, for sample work, I just parked 4 files in my folder.

result shows 4 iterations were run, but it seems it run same excel all four time

 since 1 excel had 2 sheets, it is listing 2 ssheets, which is fine. we can deal that later. However point is we need merge all files in my folder irrespective of different names.

 

 

[binuacs]

@samson211 can you screenshot your first macro action tool settings, i think the replace part need an update

[samson211]

@binuacs please find attached setting.

[binuacs]

@samson211 

can you check the action tool property has the below part selected (second screen shot),if yes unselect that part and rerun

[samson211]

after changing the setting, now its not going thru first marco @binuacs