We all started somewhere! Share your experience on the Get Advice: Let's Get Started Sweepstakes thread and be entered to win a $100 credit on your Constant Contact account.

Export Excel File with Questions and Total Responses Side by Side

What were you thinking? I feel ripped off. I did my first survey in Fall 2020 and a follow up this April. I had to print the screen to get a report comparable to the report I had last Fall. What junk!

Consulting & Training

I completely agree with @MikeB82916. I would like to see the same results from the "survey page" that we used to get from the "Legacy survey." As it stands the results are unacceptable and I will most likely be switching platforms once my subscription expires. We run surveys for data analysis, and what is offered in the survey page is poor at best. 


Hi @DeniseC5392. Could you further explain what's missing from the results or what you would like to see? 

Status changed to: Open Questions

Hi @ShawnH02. How would you like your reporting to look? Is there a certain layout you prefer? Survey pages is a newer feature so we're welcoming any type of feedback to improve upon it.

Status changed to: Voting Open

Reply from @ShawnH02 


Attached are the results of a survey from last september...supposedly the version that was retired. I could not find a way to export such a report in the current version. I had to print the page which included items that were too small to read at the top. Not professional looking. Really cutting corners here.

What exported was just a list of names and email addresses next to each of the questions. No comparison percentages.

Thank you for the follow up. If you need anything else, please let me know.


Previous legacy survey resultsPrevious legacy survey results

Previous Legacy survey results

Thank you so much for the follow-up. I'm going to open this idea up for voting. I included a screenshot of your example for a visual with your information blurred out


Reply from @DeniseC5392:

Yes, in the older versions of the Legacy Surveys I could download a pdf with graphics such as pie charts and text of responses. Now, all that I can do is download an excel file. If you could allow us to analyze the data in the survey pages and we were able to do in the Legacy Surveys that would be great. Right now, it is almost pointless using CC for surveys as the data isn’t easily readable.


Thank you for the explanation. I'm going to merge your feedback into a larger thread surrounding the display of exported responses.


What is the best way to analyze survey data collected via Constant Comment?

Regular Participant
The way the results are exported are completely useless. Is there an alternative way to export that keeps the results of multiple questions with the person answering? this is a giant flaw in your platform.
The survey reporting is the worst thing I've ever seen. Yes it collects the information, but it formats it out of order when exported and also gives you no access to see the individual survey because all of the reports are combined together.
What a nightmare. When I download the results the questions don't even stay in the right order. Impossible to read in a basic excel spreadsheet. Only one format to download this mess is ridiculous. Am considering dropping this extra service and going back to Survey Monkey. (The survey feature as a whole is a huge disappointment. Not being able to send the actual survey as an email and only being able to put a link in another email- forcing another click is bad programming.)

The newer survey response export is a mess!  The questions and responses should be column headings, not additional data in the respondent's row.  C'mon!  This is basic spreadsheet stuff.  Get your constant and variable data straightened out.  Now I get a separate records (rows) for each time a respondent answers each question - not helpful, especially when I write follow-up questions.  I need to scroll through all the records pertaining to question one and hope I find that person's corresponding follow-up response among the rows of question two records.  How did this ever get past your test phase?

Frequent Participant

Has anyone researched alternatives to CC? If updates are not implemented to the survey tool asap, it will be worthless to us since we can't export data in a usable way. I was hoping we had longer, but from the email yesterday the legacy tool will end in June.


We are considering leaving as well due to the survey module. We have utilized CC to track client intake information. In addition to the survey reporting being a mess the new page survey module only leaves the survey open for six months. Pretty hard to track results for a fiscal year if the survey maximum is six months! If someone finds a good alternative to CC please post!


Frequent Participant

I understand CC wanting to streamline the survey feature, but I feel it's been stripped of so many nice features offered on the Legacy survey platform. 1. The pdf export to a bar chart summary is gone. This report was a nice snapshot of results for our managers. Now I have to screenshoot each question and throw in another document to create this summary. 2) The csv file exports as a mess, with the questions in backwards order. It took me hours to clean up. Plus the question is repeated for every survey respondent. The Legacy export of this document was organized in the manner of the survey, listed the question(s) once, listed the question(s) in order, and then the responses - a much cleaner export. 3) Additionally, the Legacy csv export had two tabs. There was a summary tab in which I would take the organized data and make pie charts for the managers. The new survey feature no longer includes that tab and information in the export. The new survey platform reporting feature is very disappointing.

For us the greatest value provided by Contact Contact was the way the results of the responses to the surveys we sent were formatted. All responses from a recipient were on a single row and so it made for easy comparison. The new format has a operate row for every response from every respondent, this is not functional from our perspective and we will have to revaluate using the service.
What happens with product feedback?

Find out about the life-cycle of a product idea when it is posted on our Feedback board.

Read More

What's New

See the latest Constant Contact product release notes and updates.

Learn More