How to export output in Excel Template?

[Kinetic_analytics]

Good morning great minds:

I have a question. How may I export workflow output as a preprepared excel template? Appreciate your advice.

Thanks

[binuacs · Accepted solution]

@Kinetic_analytics I think the Blob tool would be useful for your use case. The below post will give you an idea of the Blob tool

https://community.alteryx.com/t5/Engine-Works/The-Blob-Reporting-That-Isn-t-From-a-Horror-Film/ba-p/...

[MarioAA]

Hello,

another workaround I use is to do it directly in excel, let's say I have a sheet where I have the template formatted as I want directly in excel, which is then linked through whatever formula (sumif, sumifs, vlookups or even pivots) to a second data sheet written by Alteryx.

So when I run Alteryx I select in the output tool overwrite sheet and that refreshes the data base and ultimately my template sheet.

Not super clean but kind of effective.

Mario

[Emmanuel_G · Accepted solution]

Hi @Kinetic_analytics ,

Find attached a way to export in excel template.

Let me know if you have any question.

[Kinetic_analytics]

Brilliant! aha! Thank you :) Appreciate your help in my learning process.