Since changing the way survey data exports to reports, is there any advice on how to use this new format to analyze data?
We preferred the old format where survey data was displayed with the respondents in rows and the survey questions in columns. That way we could compare by question across respondents, or pull the information into a Word doc mail merge by individual respondents. Now we get an unusable spreadsheet with the questions displayed in rows rather than columns we are at a loss as to how to utilize our survey data.
We are looking into moving to another platform for surveys, but really hate to leave CC. Any suggestions on how to manipulate the data since this change are welcome.
Hello @INS1.org ,
Our engineers are still working on ways to improve the reporting formatting to be more easily readable / translatable, akin to the old legacy format. Your account has been marked as interested, and they'll notify you directly on any future developments regarding the survey reporting.
In the meantime, the best workarounds will require some degree of manipulation. Since the results export as a CSV file, you can sort a specific column so that it'll update the orders of the others respectively. For example, you can sort by first name or last name to see each individual's response to a question. You can sort by question so that you see all the different responses for that question lined up. From there it's just a matter of spreading out the width of the columns / formatting them to show all their data, rather than squishing everything up.
Our team has also had success when setting up pivot tables in Excel and other spreadsheet programs with similar functionality. Microsoft has an article on creating pivot tables in Excel, if you'd like to check out that setup.