by Mike Cronley
Exporting the data you collect in Alchemer to a CSV or Excel format can create some challenges when you try to sift through the exports to view your survey response data simply. Fortunately, we have a few tips to help!
In the example survey below the respondent answered the first two questions this way.
Problem:
The export generated for those questions will look like this:
However, this is not the easiest export to read for three reasons:
Each column’s width needs to be expanded to view the complete question title.
The question numbers aren’t visible. Where does question one end and question two begin?
The answers for the two checkbox questions are spread out across numerous columns.
Solutions:
1. Use an alias for the question titles.
Using an alias, such as Q1 for Question 1 will give you a clearer export.
Customize the Header Format to Show Question Numbers.
You can also customize your header format to Show Question Numbers, making the export easier.
Select Show checkboxes as a Single Column.
Before exporting, go to: Results > Exports > CSV/Excel > Create Report > Settings to make these selections.
Now when the export is run it will display like this:
The question numbers and the aliases appear in the headers. The checkbox answer options selected are grouped together in one column.
The post Three Ways to Make Your Exports Easier to Read appeared first on Alchemer.