Responding to an Assessment via Excel

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 'More' 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. The format will depend on both the requirements that the Assessment is linked to and the response fields that are configured.

Only enter or change data within the response columns. These are located in the right-most rows and have a "CF" prefix.

Data entered in the response columns must align with the response options available within the Assessment.

Responding via Excel Template

To respond using a populated template, click 'More' 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.