Multiple excel output file into one output file with multiple sheets

Question

In an Alteryx workflow, we have 9 separate containers that generate the same output file (Firm.xlsx) but with different sheet names (A to I). Each container writes its own sheet to the file, resulting in multiple instances of the same file being overwritten.

Requirement: We need a single Firm.xlsx file that consolidates all sheets (A to I) into one final output file, ensuring that no data is lost due to overwriting.

binu_acs · Answer

@akvsachin try the below approach, this will make sure that first create the Film.xlsx with the Tab named A, then B, then C etc

Write_Same_File_24032025.yxmd

akvsachin · Answer

Hi @davidskaife ,

Attached an image of multiple containers

Elaborating my requirement:

Container 1: Output FileName:- Firm.xlsx, Sheet Name :- A
Container 2: Output FileName:- Firm.xlsx, Sheet Name :- B
Container 3: Output FileName:- Firm.xlsx, Sheet Name :- C
Container 4: Output FileName:- Firm.xlsx, Sheet Name :- D
Container 5: Output FileName:- Firm.xlsx, Sheet Name :- E
Container 6: Output FileName:- Firm.xlsx, Sheet Name :- F
Container 7: Output FileName:- Firm.xlsx, Sheet Name :- G
Container 8: Output FileName:- Firm.xlsx, Sheet Name :- H
Container 9: Output FileName:- Firm.xlsx, Sheet Name :- I

Now I need one output file.
New container: Output FileName :- Firm.xlsx, Sheets:- A, B, C, D, E, F, G, H, I

Ensuring no data is lost. because in this way the other processes are getting terminated as 1 file is generated.

davidskaife · Answer

Hi @akvsachin

Change the Output Option on the Output Data tool to 'Overwrite Sheet or Range'