Add a new tab on excel files which contains data generated using a render tool

Question

I have an excel file which has formatting and formulas and I need to duplicate for 14 other countries. For each country, I need to add a new sheet which  I generated for each country using an Alteryx workflow and the final output was generated using a render tool to achieve certain formatting. I have produced a sheet for each country. How do I duplicate the excel file 14 times and combine an excel file with a sheet for each country. This attached data has been masked

File with formula and formatting.xlsx

Render Tool Output.xlsx

ashleyharvey19 · Answer

Adding a new tab to existing Excel files in Alteryx is best handled using the Output Data tool with dynamic filenames. Setting “Append Sheet” in the configuration ensures new tabs are created without overwriting existing ones. I’ve also used batch macros to automate multiple file updates, which keeps workflows scalable and organized across large datasets.

dreldrel · Answer

You can also use a simple macro with an output tool inside, then just update the sheet name to output the new tabs

jrlindem · Answer

You can use the BLOB tool to copy that source file with it's formatting and then use it within your workflow to duplicate it for each output instance you need, playing your rendered/table data directly into the BLOB'ed copy for output.

Here's an article that goes over that tool which should help!  The Blob: Reporting That Isn’t From a Horror Film - Alteryx Community