Responding to a Requirement-Based Assessment using Excel

Learn how to respond to a Requirement-Based Assessment (RBA) by exporting it as a spreadsheet, filling it in, and importing the answers

This article only describes the Excel import/export functionality when responding to assessments. For responding to assessments within the platform, head here.

Exporting the response template

Make sure you are in the Response-1 tab of an assessment. Export the template by clicking More > Export.

Any answers already filled in will also be in the export file.

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.

Answers for dropdown columns must align with the given options in the assessment.

Importing the populated template

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