Skip to main content

Exporting Survey Results

A short guide to help you get survey result data out of smartcrowds and into Excel / CSV

D
Written by David Kerr
Updated over 2 years ago

smartcrowds offers a wide selection of reports for analysing survey result data, but sometimes good old Excel is what you are looking for.

To export raw survey result data, follow the steps below:

STEP 1. Open the ‘Survey Report Pack’ menu option from the Reports menu

STEP 2. Choose your Survey from the list and tap the ‘Go’ button

STEP 3. Choose the ‘View Raw Data’ option

STEP 4. From the appropriate data table, tap the ‘More Options’ ellipses menu at the right hand side.

STEP 5. Choose the ‘Export Data’ option.

STEP 6. Choose the ‘Data with current layout’ option

Click the 'Export' button to export response data from each respondent to an Excel CSV file in a matrix format, with each question/responses presented in columns, and Respondent names in rows.

Please note that respondent names will only be displayed if a non-anonymous survey has been sent. If the survey was a public URL survey, or a list of recipient email addresses was uploaded but the anonymous option was chosen for the survey, a hash-code will be used be instead of the respondent name.

Did this answer your question?