Part 5 Exporting data from SurveyMonkey
(Advanced Spreasheet Format)
Choose download responses
- Under Choose Type of Download select all responses collected
- Choose spreadsheet format > Condensed > Numerical Values (IMPORTANT) you must do this before choosing the advanced spreadsheet option.
- Then choose advanced spreadsheet - when you do this the options under spreadsheet format will disappear.
- Click request download then wait for the file to be processed
(You may have to refresh the page several times.)
- Download data by clicking on the download link
- Choose the CSV folder then open sheet_1
- Once the file is downloaded you will have two options - Excel or CSV Chose CSV - The Excel and CSV files are identical with the exception of the data field. Excel has "issues" with SurveyMonkey date fields. CSV files read the data correctly.
- Open sheet_1.csv
- Save the csv file to your hard drive as an excel file.
|
