Combine Tabs into a single worksheet

Hi Everyone,

I hope you can help me with the below situation. I have separate tabs in different excel files that need to be combined into one excel files (while remain separated)

So for example, I have Sheet 1 in Excel1.xlsx and Sheet 2 in Excel2.xlsx. Is there anyway that I could create an Excel3.xlsx containing Sheet 1 and Sheet 2 as separated tabs.

Sorry if my demonstration is confusing. Appreciate any inputs!

Tips and Tricks

Accepted answers

grazitti_sapna

Hi @hieule1809 , Yes you can collaborate 2 different sheets from different excel into a new one. Here is the screenshot of the result.

You just need to configure your input tool where you an select the sheet for excel.Like this,

In the output tool you need to create an excel file where you can simply change the sheet number such as Sheet1, Sheet2 etc.

Attaching the workflow along for a better understanding. I hope this solves your purpose.

Excel.yxzp

All comments

jacob_kahn

Hey!

Try this link for help https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Combine-Multiple-Excel-Workbooks-into-One-Workbook/td-p/181998

please like and accept if it did help!

grazitti_sapna

Hi @hieule1809 , Yes you can collaborate 2 different sheets from different excel into a new one. Here is the screenshot of the result.

You just need to configure your input tool where you an select the sheet for excel.Like this,

In the output tool you need to create an excel file where you can simply change the sheet number such as Sheet1, Sheet2 etc.

Attaching the workflow along for a better understanding. I hope this solves your purpose.

Excel.yxzp

hieule1809

Works like a charm! Thank you

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703