Creating Excel Files with Specific Formatting from Another Excel File

[A1exW]

Hi all, I'm looking to create separate reports for different user IDs while maintaining consistent formatting across all generated files.

For example, I have user IDs 001-003 and would like to generate report-001.xlsx, report-002.xlsx, and report-003.xlsx, each containing data for the respective user ID. These generated reports should maintain the same formatting (font, color, fill, underline, bold, etc.) as a template file, let's call it report_format.xlsx.

I know Alteryx has an option to preserve formatting on overwrite, but it will requires copying the report_format.xlsx to output path and rename one by one to report-{user ID}.xlsx. Is it possible to generate multiple Excel files based on a specific format from another Excel file?

I would greatly appreciate any guidance or suggestions. Thank you in advance for your help!

[Raj · Accepted solution]

@A1exW 
you can achieve this using blob tools.
using the template you can create a file for each record with all the records and then write data into it.
Hope this helps.

[A1exW]

It works, thank you so much. First time using Blob.

[A1exW]

Here's my result