How to format a spreadsheet to import survey responses
You can import survey responses into Makerble.
Steps
Download this template: https://drive.google.com/open?id=1Q4YSt-PXybZto0vgd0EMzBAXH1k4e2OJ&usp=drive_fs
Open it in Google Sheets, Microsoft Excel or another spreadsheet editor
Check there is a column called Respondent Name
Check there is a column called Date of Survey Response
Find the survey you want to import on Makerble
See your organisation’s surveys Manage your organisation's surveys
Find additional surveys: Explore surveys: discover publicly available survey templates
Then copy each of the questions into the title of a column
Add a column for each survey question
The column for Staff member who recorded the survey response is optional
Then fill out the table with the survey responses and the names of each respondent
Note: the survey responses should match the Answer Choices that are available for that question
Next, download your spreadsheet in CSV format
Now you can import your data into Makerble:
If your survey has verdicts enabled those verdicts will be calculated.