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