Export responses filtered by respondent

I'm disappointed in the new Survey results format. I am unable to print out individual survey responses, except to "Export Results" which gives me a very jumbled looking Excel file (csv), that prints in a very tiny space on letter sized paper due to the table style. This is poor design. If I attempt to File-Print the view of one individual survey response, I get a print preview that doesn't supply the entire survey, and yet provides me with a repeated page three times. This is nonsensical. Am I missing something?

5 Comments
Caitlin_M
Administrator
Status changed to: Open Questions

Hi @JenniferC0794. To clarify, are you looking to see how one respondent answered each question and export this information?

JenniferC0794
Occasional Participant

No. I know how to do that. However, when I export all of the survey questions for one particular individual response, it gives me a csv file with a jumbled looking table, and it's very small upon printing it out. The excel file that it creates does not display in a very legible format.  I would rather open an individual survey, and print it out as displayed on screen. This doesn't seem like a possibility however. It doesn't print the entire survey - only what fits on one page. And it strangely lists the same page three times, as in, three pages (but with the same info on each one). It doesn't continue the rest of the survey questions onto the next page for printing.

Caitlin_M
Administrator
Status changed to: Voting Open

@JenniferC0794, thank you for clarifying. I'll open this idea up for voting and update if there are any changes to the reporting for survey pages. 

JefferyCorbett
Occasional Participant

I agree with @JenniferC0794 -- the export on the new survey is HORRID. Instead of giving me a Column A = Respondents, Column B = Q1, Column C = Q2, etc.; now we get Column A =Q1, Q1, Q1 (every respondent with their own line for Q1), then IN THE SAME COLUMN A... Q2 (followed by every respondent).

 

So, I have to manipulate the spreadsheet to see all of one respondents answers in one row (frustrating).

Also, if a respondent skips a question, then there is no line for that blank response. Making it even harder to move responses so there is one row per respondent.

 

Ex: 

Question - Response - First Name - Last Name - Email -Date/Time

How Old? -    25          -   Larry           - Smith         - Larry@abc.com - 4/5/21

How Old? -    32           - Susan          - Bradley     - SB@123.com        - 4/7/21

Hair Color - Brown   - Larry              - Smith         - Larry@abc.com - 4/5/21

Hair Color - Blond    - Regina          - Jones         - Regina@you.com - 5/4/21

 

 

Please consider changing the export so that a single respondent's information is all in one row.

 

Ex: 

First Name - Last Name - Email - Q1 (response) - Q2 (response) - Q3 (response) - Date/Time

 

JC_Area_YMCA
Occasional Participant
This new survey option is awful! Before I could filter by more than one category and get easy to read results. Can't do that with this one. I decided to run reports for each respondent and the questions/answers are in the same order as any of the other respondents so that's a nightmare. If the legacy survey goes away and this remains as terrible as it is, we'll use a different survey company.
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