Configuring multi-column dropdowns in Excel

Overview

A multi-column dropdown allows you to have multiple columns designated for each response. The issuer oftentimes wants you to place an X in the column indicating your response from the header above.

Configuring multi-column dropdowns in Excel

1. In the Excel file, identify your sections whether within the worksheet cells or the name of the worksheet itself.

2. Identify your questions.

3. Identify the columns containing your different answers at take note of their numbers (such as columns E, F and G).

4. In Responsive, select Response Projects and click Create New.

5. Compete the project metadata.

6. Click Upload Document, and browse and upload your document. The document will be auto-configured.

7. Select the Answer column and map it with Answer from the right menu options.
   

8. The Answer Configuration pop-up appears. Change the Answer Header to Response.

9. Select Multi-Column Dropdown as Answer Type.
   

10. Add the required answer options. You can add multiple options by selecting Add Answer Options and click Save.
    

11. Click Save and then Import.
    Note: If your dropdown options split after import it may be related to how your options are mapped during import. Verify the dropdown configuration by reviewing the screenshot of the expected mapping to ensure each row number is grouped under the dropdown column (not split) and edit if needed. If the behavior persists, contact our Support team to review the import configuration in real time.