Hi @Analyst_12345 ,
I hope the below link will helpful for you.
https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/File-Paths-and-Alteryx/ta-p/847200
Regards,
Ariharan.R
@Analyst_12345 when you go to save your workflow to the gallery, ensure that in manage workflow assets, you have the (OUTPUT) you want ticked. This way, the workflow will package the output as an asset and publish it to the externals folder. When this is run on server you’ll be given the ability to choose the output file type and download it.
You can utilize a Render tool within the reporting category. This will generate a preview of the output within the gallery when running the workflow.
From here, you will be able to download an excel file as a file format if you'd like to download the excel file directly.
Hope this helps, if it does please like this post and if it helps resolve your problem, mark it as a solution. If you have any other questions, please let us know.