how to add a drop down list in excel file when generating output from Alteryx

Question

I have a requirement to add the following list as a drop-down in my Excel file. Can I use Alteryx to add this drop-down in the STATUS column so that the user can select the value from this drop-down while updating the status of the record?

StatusClosedIn ProgressErrorCanceled

ayush_mishra · Answer

I have been using Excel for my status report where a drop-down was added using Data Validation. Now, I am generating this report using Alteryx and trying to explore if I can still have a drop-down on my excel file, an example enclosed. Note: I am overwriting the Status column (entire sheet) using Alteryx.

example.xlsx

apathetichell · Answer

Are you creating a dropdown in Alteryx, or trying to export an Alteryx field to a dropdown in excel?  If it's the later - your best bet would is probably to create an excel dropdown to call on a cellrange and have alteryx write to that cell range....