Major updates to the Response section in SurveySparrow

Announcements
1

We’re excited to announce a series of powerful updates to the response section in SurveySparrow! These enhancements are designed to give you greater flexibility, improved usability, and more control over how you manage and analyze your survey data. Here’s a detailed breakdown of the changes:

1. Default Column Order

image2
image21999×1357 207 KB

  • New Default Order for CX and Classic Surveys:
  1. Respondent Name
  2. Submitted On
  3. Questions and Answers
  4. Variables
  5. Expressions
  6. Contact Properties (new addition)
  7. Tags
  8. Hidden Columns
  9. Response Properties
  10. Started Date

2. Rearranging Columns

  1. Drag-and-Drop: You can now rearrange columns directly in the UI by dragging and dropping them.
  2. Multiple Options for Rearrangement: Columns can also be rearranged through the “show/hide columns” menu or the “move” option within each column.
  3. Grouped Columns Stay Together: Grouped columns like sections, matrix, group rank, and contact forms will always move together and remain grouped.
  4. Persistent Arrangements: Any arrangement made by the user will be saved and maintained even after logging out or refreshing the page.

3. Resizing Columns

Adjustable Widths: Columns can be resized to ensure full visibility of long questions or other data.
Persistent Resizing: These changes will also persist across page refreshes.

4. Infinite Scroll
Goodbye Pagination: The 50 responses-per-page limit is being replaced with an infinite scroll, allowing for seamless browsing through all responses.

5. More Options Inside Columns

Sorting:
Columns can now be sorted in ascending or descending order.
Supported columns include:

  • All scale questions (including CX)
  • Yes/No questions
  • Consent questions
  • Expressions
  • Variables
  • String-type contact properties

Pinning Columns:
Up to two columns can be pinned to the start of the table for easier access.

Moving and Inserting Columns:
Columns can be moved left or right, and new columns can be inserted to the right.

6. Grouping Data

  • Group by Column Values: Data in the table can be grouped based on the values of a specific column. For instance, grouping by a Yes/No question will create two groups: one for Yes and one for No.

image3
image31999×1303 258 KB

  • Multiple Groupings: Up to three groupings can be applied simultaneously.
  • Persistent Grouping: Grouping settings will persist on refresh but will not be included in exported data.
  • High Capacity: Up to 10,000 rows can be created.
  • Supported Columns for Grouping:
    MCQ
    Yes/No
    All scale questions (including CX)
    Matrix
    String-type variables
    String and dropdown-type contact properties
    String and dropdown-type response properties
    Dropdown questions
    Group rating
    Tags

7. Filters

  • Filters at the Top: Filters applied will now appear at the top of the page by default.

image1
image11999×1362 212 KB

  • Submission Time Sorting: By default, the responses will be sorted based on submission time.
  • Filter for Upload Questions: You can filter upload questions by “answered” or “not answered.”

8. Partial Response Indicator
Visual Indicator: A dedicated indicator for partial responses is now available.

9. Tags
Add Tags Easily: Tags can now be added directly from the first pinned column, eliminating the need to scroll to the end of the table.

10. Tickets
Create Tickets Efficiently: Tickets can be created directly from the first pinned column.

11. Attachment Viewer
Supported Questions: Attachments from upload, signature, and picture choice questions can now be viewed directly.

12. Question and Answer Format Changes (UI)
Heatmap: Displays the count of clicks in each group.
Group Rank: Shows choices grouped in ranked order.
Bipolar: Displays choices in a “column-choice” format.

13. Changes in Export

New Formats:
Multiselect MCQ, dropdown, matrix, and group rank questions will now follow updated formats.
SPSS Download: All fields are now supported.
Filter Support: Applied filters in the UI will now reflect in the exported data.
Default Order for Scheduled Responses: When scheduling responses, the default column order will be used, and custom rearrangements will not be applied.

14. Enhancements in Integrations (Coming Soon)
Future Enhancements: Only in upcoming updates will the enhanced default view be available for integrations with Excel Online, Google Sheets, Power BI, and Tableau. Until then, the column order from the older version (prior to this revamp) will be used

Stay tuned to your SurveySparrow account for exciting new enhancements! :wink: