Views:
This article is for Disclosers and provides guidance on how to import data into your questionnaire using the Excel template.
 
Contents:
  • Overview 
  • How to import data into your questionnaire 

  •  

Overview:

You can import the following questions into your response using an Excel template.  The Excel Import Feature is only applicable to certain questions as it aims to make entering long question responses easier. 

Corporate questions: 

 

Q 1.8.1 

Q 7.17.2 

Q 7.20.2 

Q 7.23.1 

Q 7.30.14 

Q 7.30.16 

Q 7.30.17 

Q 9.3.1 

 

CSTAR questions: 

 

Q 3.1.2 

Q 3.1.3 

 

How to import data into your questionnaire 

1. Sign in to the Portal and navigate to your questionnaire response  

2. Click on Import Data 

 

3. Click Download template (.xlsm) 

 

4. Click on Enable editing in your downloaded template. You will get an Excel document with the following tabs: 

  • Question text 
  • Response 
  • Options – DO NOT EDIT 

  1.  

5. Navigate to the Question Text tab.  

  1.  

Please note: When copy/pasting values into the template, ensure that you select “Values (V)” from the ‘Paste Options’ and do not edit the format of the excel template prior to importing. Please be aware that editing a column header (areas in dark grey) will result in the template not importing. 

 

The tab ‘Question text’ shows the question number, text and accompanying help text. 

Navigate to the Response tab. Write or copy and paste your data into the columns provided. 

 

 

 

The tab: Options - DO NOT EDIT as shown below shows the allowed character limit and decimal places for a column. Please do not edit this tab, it is for guidance only. 

 

 When you have prepared your Excel template with the populated data, navigate back to the Portal and questionnaire response. Click on Import data for the relevant question and go to Step 2.  

Select Click to upload or drag and drop to upload your file. 

 

 Your data will be imported into the question in your questionnaire. 

 

You can keep editing and importing your excel template as many times as necessary. 

Please review your response before submission. Disclosers are responsible for ensuring the accuracy of their submission 

You may find the following articles useful: 

 

If you have not found the answer you were looking for, please contact our support team through My Support. You will need to be signed in to access this. 

If you are a new user, you can register here. Once you are signed in, please return to the Help Center via the link at the top of the page. 

Keywords: import. response, Excel template, questionnaire, data, disclosers
Add a comment