Is there a way to get the collumns to auto fit so we will not have to format when opening a excel spreadsheet? Also is coloring the bottom sheet tabs possible?
You will not be able to do both of those with Alteryx alone. You will need a VBA Script / Macro that Alteryx can trigger after the data is written to the file. There are a number of post dedicated to running VBA with Alteryx so no need to rehash here, but below is the link to one of the most useful IMO.
Alteryx Run Command: Executing Excel Macros (VBA) - Alteryx Community
Hi @maddoxs
You could also leverage an excel template using either blob tools or run commands:
https://intersectionsandoverlaps.wordpress.com/2019/09/27/alteryx-excel-templates-with-blob-tools/