CSV export is inconsistent / produces too many cells
Opened this issue · 4 comments
Unfortunately I can't share a screenshot of the data (for privacy reasons) but I have 11 responses in the survey, however, the CSV export produces 18 rows of responses.
What appears to be happening is some of the long answers are being split into multiple cells. One respondent typed up a list of 6 apps they're using and each word was placed in its own cell. I have a feeling that commas are the issue.
Agh, yeah, that seems likely. The content of each value should probably be escaped and put in an encapsulating string. Though that seems like it would cause multiple columns, not rows. Do the results have newlines in them maybe?
The result is that data that would normally only take up 1 cell (in a column) now take up multiple cells. So the answer for Question 1 may show up under the the Question 1 column as well as the Question 2 column, etc. For a given row, once each cell in each column is taken up, new row is created to accommodate for the additional cells (produced by this error).