On your guide dashboard in Builder, you can visit the Surveys area to quickly view survey responses. However, we understand you may want to export your survey response data - especially if you have numerous responses!
In this article, we will cover:
From the guide dashboard in Builder, click on the "More Options" ellipsis button (⋯) next to your guide title in the upper left. Then click on “Export data”.
From the page that appears, click on the name of your survey — for example, “Session Feedback (CSV)”
Note: A survey will not appear in this area until at least one response has been recorded.
Builder will email you a link to your spreadsheet.
When you first open your exported survey spreadsheet, the responses will be sorted by Question Text. You can filter your data but another column header, however. For example, you may want to sort responses by the session they came from.
Watch this video, or download the "Exporting Responses..." attachment linked at the bottom of this article for help with sorting and/or filtering your survey responses.
We understand that the way Builder presents survey data may not be the best way for you to view and manipulate your data. With this in mind, we have created a tool for an alternate format.
Run the Excel macro (attached at the bottom of this page) on your data to reformat your data. The macro takes the survey questions/prompts and makes them the column headers.
- Export your survey data.
- Download "Excel Macro.xlsm" from this support article. If you see an alert when opening this document, you’ll want to choose the “Enable Macros” option so the document can function.
- Copy your survey data from the export
- Click onto cell A1, and paste your data into the macro spreadsheet.
- Click the "Horizontal Form" button in the macro spreadsheet
- The Macro will generate a new sheet in the workbook, called "Sheet 1", with your reformatted survey responses. The survey questions/prompts will now be column headers.
Questions? We're here to help. Email us at firstname.lastname@example.org