Import Form Responses

It is only possible to import form responses to Survey and Demographic types of forms.

The most common scenarios for importing form responses is to import Demographic Survey responses to use as a filter in reporting, or to enter information that was collected outside of Chalk & Wire.

It is easiest to import form responses by creating a spreadsheet containing the desired information and then creating a form to import these responses into. Follow the steps below to import your demographic responses.

If you are importing Demographic Survey responses to use for filtering data in Results Live, you should import to the Single- or Multiple-Choice question types to ensure more accurate and complete filtering.

Step 1: Create Spreadsheet

Step 1: Create Spreadsheet

1. In the first column, enter the heading Student Name with the respondent's full names below, as they appear in Chalk & Wire.

If you are importing form responses from Guests, include an exclamation point in the column header. i.e: Student Name!

2. In the remaining columns, the headings should be exactly the same as the form's questions OR exactly the same as the questions' abbreviations. Enter the corresponding answers for each respondent.

If you use responses with unique values (such as age or years-experience, etc.) set up ranges rather than individual values for the responses. For example, possible response options for age may be:

  • 18 - 25
  • 26 - 35
  • 36 - 45
  • 46 and above
How to Import Multiple-Selection Responses:
NOTE ABOUT IMPORTING RESPONSES TO QUESTIONS WITH MULTIPLE SELECTIONS:

If you are importing into a multi-choice response type question, enter the choice numbers instead of text responses. Separate each choice number by a comma or a pipe within a single column.

Step 2: Access Form

Step 2: Access Form

3. Click on the Main Menu icon.

4. Select Curriculum.

5. Select Forms.

Step 3: View Form

Step 3: View Form

6. Locate the form that you would like to import responses to and click anywhere on its row to reveal its options. You can either:

  • Select Import Responses (skip ahead to Step 4).
  • Select View.

Step 4: Import Responses

Step 4: Import Responses

7. Click on the Import Responses Button

8. Enter a Response Date for the imported responses.

9. Select a Delimiter for the content that you are pasting in the text-entry area. If you are copying your content from Microsoft Excel, select 'Tab'.

10. Paste your content in the Paste Responses Text area.

11. Click Continue.

Step 5: Import Confirmation

Step 5: Import Confirmation

The importation of the responses will be confirmed in green.