Alteryx Designer Ideas

Share your Designer product ideas - we're listening!
Submitting an Idea?

Be sure to review our Idea Submission Guidelines for more information!

Submission Guidelines
Nominations are open for the Alteryx Excellence Awards through March 26! We want to celebrate the impact you've had and give you the visibility you deserve! Make your submission here.

Output Option for Excel: Overwrite Data but not the Formatting

It would be great if there was an output option for excel files where you could overwrite the data in the sheet, but keep the formatting in the sheet. Similar to how the Paste Values option works in Excel. This would allow me to create a template with data validation, conditional formatting, column widths, cell fill colors, etc and set a workflow to run on a schedule and just paste the data into the existing template.


To get around this right now I have to output it to a separate tab and then paste the columns as values over the existing template. This is fine unless I am out of the office and need to bother someone else to do it. I know there have been many times where i wish this was an option outside of the report I am currently building. I am honestly surprised I couldn't find an idea already submitted about this!




Status changed to: Coming Soon

Thank you for posting to the Alteryx Designer Idea Board!


This feature will be available in an upcoming release! We'll update this idea again once the release is publicly available for download.

Status changed to: Implemented

Thank you for suggesting this! For the 2020.1 release, we have added the ability to write to a range and preserve the formatting of those cells. To enable this functionality you will need to check the 'Preserve Formatting on Overwrite' option. There are also some other Excel enhancements in this release as well. You can view the 2020.1 release notes here.