Importing controls and responsibilities

This article provides a step-by-step guide to creating controls and responsibilities under a control set by importing XLSX or Excel files using our pre-defined templates

Controls template

Navigate to the controls module and click on Create control set.  Provide a name and description when prompted in the modal and then click on Create control set. 

This will open the Controls page, displaying all your organization's control sets stored in 6clicks. Click Create Control Set at the top-right corner of the screen.

The Control Set modal will then open. Enter a unique name for the control set under the Name field, include relevant details under the Description then click Create Control Set.  

At the Control Set Builder page for your new control set. click on More at the top-right corner and choose Import controls (XLSX) from the drop-down list. 

An alert message will appear.  Read it carefully and select Yes to continue.

This opens the Import Data modal. Select Download Template to download the Excel file that provides a template for formatting your controls.

Open the template to see column headings that correspond with field names. Populate the respective information in each column:

• Control ID: Input the control ID(s) in this column. Each ID should be unique to the respective controls.
• Control Title: Enter a name or title for each control in this column
• Control Description: Describe the function of each control
• Control Domain: Indicate the domain that each control falls under

Import Controls

Upon completing and saving the template, return to the Control Set Builder page, click More, choose Import Controls (XLSX), and select Browse to upload the edited template that now contains information on your controls. You can also drag and drop the file directly into the Import Data modal.

Click Upload to import your controls.

Once the file finishes uploading, you can return to the Control Set Builder page to see that the control set you created now displays the controls you listed in the Excel template.

Responsibilities template

Responsibilities are tasks that are attached to a control to ensure its implementation.

Going back to the control you previously created, navigate to the Control Set Builder page, click More, then choose Import Responsibilities.

The Import Data modal will open. Select Download Template to download the Excel file that provides a template for formatting your control responsibilities.

Open the template to see column headings that correspond with field names. Populate the respective information in each column:

• Control ID: Input the control ID(s) in this column. Each ID corresponds to a control to which you are attaching a specific responsibility
• Name: Enter a name or identifier for the responsibility in this column
• Description: Describe what course of action the responsibility entails
• Due Date: Indicate when the responsibility is due
• Owner: Enter the email of a user or advisor who will oversee the responsibility. When linking a user group, enter the group name. Multiple entries need to be separated by commas.
• Recurring: Type Yes in this column if the responsibility is a recurring task. Write No if the responsibility is a one-off task.
• Time Period: Add the duration of the responsibility task in this column. Options are 2 years, 1 year, 6 months, 3 months, 1 month, 2 weeks, and 1 week.
• Assigned Members: Enter the email of a user or advisor who will perform or complete the responsibility task. When linking a user group, enter the group name. Multiple entries need to be separated by commas.

Import responsibilities

Upon completing the template, return to the Control Set Builder page and again click More, choose Import Responsibilities, then this time, select Browse to upload the edited template that now contains information on your control responsibilities. You can also drag and drop the file directly in the Import Data modal.

Click Upload to import your control responsibilities.

Once the file finishes uploading, you can return to the Control Set Builder page to see that the control set you previously created now displays the responsibilities you imported under the Linked Data column for the respective control.