Learn how to respond to a 6clicks Assessment using the Excel import
This article only describes the Excel import/export functionality when responding to assessments. For other information on responding to assessments, please refer to Responding to an Assessment.
Creating an Assessment Response Template
To create a response template, click 'Data' on the top right of the screen and click 'Export'. This button is available when responding to assessments within 6clicks.
6clicks will generate a tailored template for your response in the below format.
The 'Response' column captures the assessment response, and the 'Response Explanation' captures any additional details the respondent wants attached to that particular response.
Data entered in the 'Response' column must align with the response options available within the Assessment.
Handling Looped Questions
See Assessment Questions Overview for more information on the different assessment question types.
Looped Questions have a dynamic number of responses available and require some manipulation of the response template. The template will generate with a single response available for the Question Group.
The 'Question Number' column shows the question group with an alphabetical suffix. Each looped question within this group includes an additional numeric suffix to show its order in the question group.
To respond with multiple loops, copy all questions within the group and insert below (do this as many times as needed for the response). Finally, edit the alphabetical suffix in the 'Question Number' column for each subsequent loop to reflect its order.
The response template is now ready to collect response data and import into 6clicks.
Responding via Excel Template
To respond using a populated template, click 'Data' again and this time click 'Import'.
Drag and drop the response file or browse for it in the file directory.
Click 'Upload' to finish importing the response into 6clicks. The dialogue box will close, and the response data will be loaded into the assessment.
From here the assessment response can be submitted as detailed in Responding to an Assessment.