With SoGoSurvey, you can easily generate blank surveys for offline use. Simply print hard copies, ask participants to complete them, and then scan them back into the system. Importing data back into the platform can help simplify tasks such as creating synthetic data, merging/combining data for multiple surveys, as well as other, more complex tasks.
To import responses, your spreadsheet of data should be in SoGoSurvey1 format. If you need add responses of the previous survey into the new one, simply export via SoGoSurvey1 and then edit your spreadsheet (by copy-pasting or deleting) to include the responses which you would like to import back into the system.
When importing through Excel,
- File size cannot exceed 10 MB.
- Only the first two sheets of a Microsoft Excel file will be imported.
- The file’s first column should contain email/unique ID. If data appears in two sheets, the first column of both
- sheets should have this same column first.
- Each question should be in a separate column.
- Data for questions with multiple answers must be separated by commas.
- For Numeric Allocation questions, a comma should separate all options, with each option followed by a colon
- and then the number assigned to that option.
- For Ranking questions, comma should separate all options, with each option followed by a colon and then by
- the rank number assigned to that option.
- For Other (please specify) questions, values should be preceded by a colon.
- Data should contain only text and no html tags like [bold] or commas. Any commas in answer options should be replaced with /~/ (front-slash tilde front-slash).
If the data in the first column is not unique, not all of your data will load.
- Under the Data tab, select your survey and then click Import Data.
- On this step, upload your spreadsheet. Select ‘Yes’ for appropriate fields, referring to the notes above, and click on Map Columns.
- On the ‘Map Columns‘ step, match columns in the data file with questions in the chosen survey.
- Lastly, click on Import Data to load your responses online.
It will normally take 15-20 minutes for the system to load the responses into the survey. While the data is being imported, you may continue to use other features of the platform.
- Review your results. If there is a mismatch in responses or any questions have not been answered, the system will identify a data mismatch. You may continue to import or review your file again for mismatches.