Go back to page
Project Basics
  • Getting Started!
    • CX Metrics
      • CX Dashboard
        • Customer Touchpoints
          • Analyze your drivers
          • Good to know
            • Getting Started!
              • Assessment Question types
                • Score and more
                  • Quiz participation
                    • Get Results
                    • Introduction to Poll
                      • Build your Poll
                        • Launch your Poll
                          • Analyze your Poll
                            • Build Project
                              • Project Style
                                • Launch Project
                                  • Analyze Project
                                    • Account Settings
                                      • Good to Know

                                        Import Offline Responses

                                        With SoGoSurvey, you can easily generate blank surveys for offline use. Simply print hard copies, ask participants to complete them, and then enter them back into the system. Importing data back into the platform can help simplify tasks such as entering offline responses, combining data from multiple projects, and more.

                                        To import responses, your data should be in a spreadsheet in SoGoSurvey1 format. If you need to add responses from a 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.

                                        Follow these steps to import your data.

                                        1. Select your project, then click Data. On the Data menu bar, click Import.
                                        2. First, upload your data.
                                          • Select a source file of .csv, .xls, or .xlsx format. (See Excel and CSV tips below.).
                                          • If the file contains a header row, select ‘Yes’ in response to ‘My data file includes a header row.’
                                          • If the file contains a column of email addresses or other unique identifiers, select ‘Yes’ in response to ‘My data file includes a column of unique IDs.’
                                        3. On the ‘Map Columns‘ step, match columns in the data file with the relevant questions.
                                        4. If any answer mismatches or blanks are found, they can be downloaded and reviewed.
                                        5. Lastly, click on Import Data to load your responses. This action submits the import request to the system.
                                        6. As confirmation, the message displayed identifies the approximate number of responses to be imported and notes that an email notification will be delivered to the account administrator when the import is complete.

                                          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.

                                        7. The imported responses will appear in the relevant survey after the import is successfully completed.
                                        8. Review your results.

                                        Before you import an Excel file, review these notes:

                                        • 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, both sheets should contain this same first column.
                                        • 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 answers, with each answer followed by a colon and then by the rank number assigned to that answer.
                                        • 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.

                                        Before you import an CSV file, review these notes:

                                        • The file size cannot exceed 10 MB.
                                        • The file’s first column should contain email/unique ID.
                                        • All questions must be separated by a comma.
                                        • Data for questions with multiple answers must be separated by commas between double quotes (“).
                                        • 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 between double quotes (“).
                                        • For Ranking questions, a comma should separate all options, with each option followed by a colon and then by the rank number assigned to that option between double quotes (“).
                                        • 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.
                                        ×