Save as PDF

Auto-Identifying drop-downs in Excel

Overview

When you import an Excel worksheet with defined drop-downs, the Auto-Identify button allows you to populate all drop-down fields within the worksheet.

You need to convert drop-down options in Excel into convenient drop-down options in Responsive.

Auto-Identifying drop-downs in Excel

  1. Upload the Excel file to your project, then select the Answer column and map it with Answer from the Options menu.
  2. The drop-downs in the sheet are auto-identified. Click Auto-Identify-Drop-Downs to view all fields.
  3. Select the checkbox to change the answer header (if required), then click Apply. The Answer Configuration pop-up appears.
  4. Click Save.
  5. Import the configured question and answer. Users can select the answer from the drop-down and export back to the source.

Was this article helpful?

/