I created a survey in Asana using a form to collect inputs. The form inputs are connected to custom fields I added to the project such that every reply has a column for each question in the form.
All appears as expected when I open the project in Asana. However, when I export a CSV file and open it in Excel, the column headers appear in Excel but all the data (the question responses) are in the Notes column.
Is there a workaround to this problem?
When I use Project Actions > Export/Print > CSV, data cells in custom field columns do get populated, and the values may also be found in Description, depending on the setting in your form.
It sounds like you’re not seeing that, so perhaps support@asana.com can help.
Larry
It seems like if you so to Edit form > Settings then unslide the bar next to Copy all responses to task description, that should fix it.
However, the spreadsheet still populates a lot of unneeded fields and data. I’m not sure how to change that.