Creating a survey in Constant Contact is easy. However, the formatting of the .csv file that can be downloaded from Constant Contact and summarizes the survey responses needs to be improved. Currently, all of the respondent's responses to survey question 1 are in cells B2, B3, B4, etc. Instead, row 1 should contain the column headers, row two should have all the responses for responder #1, row three in the .csv should have all the responses for responder #2 and so forth. Our company didn't use Constant Contact's survey because of this and used different survey software that puts each respondent's responses in a row in the .csv file. Perhaps provide two formatting options for the .csv file: one option to summarize responses as is being used currently and introduce a new option that formats the .csv as detailed above (each row contains all the responses for each respondent).
... View more