Copying data from one excel file to another file

learn_alteryx11

Hi all, 

I am looking for a way out where we can copy the entire data from Sheet 'ABC' in excel file (say- master file) to multiple excel files containing data (say test 1) which may or may not contain Sheet 'ABC'. 

Basically, the data in Sheet 'ABC' of master file can be overwrite data in other files (test 1.xlsx, test 2.xlsx, test 3.xlsx, .. test 30.xlsx).

Thanks in advance! 

jdminton

The output tool will overwrite or add the sheet (image 1). If you add the filename to your workflow (can be a formula tool) to identify the path needed for the file, that can be used for the output to multiple files. (image 2)