Creating a questionnaire in Excel

Question

Hello, I would like to create an automatic questionnaire for my in-take client process. Basically, what I am trying to do is to automate the answer I get from the client. The client will receive a questionnaire with a list of options, the client will click whatever options apply to the service they need. Then, I will paste the answers that the client provide to an Excel file in which I have these options set up in a way that I have all the details I need to consider to provide the information related to the option the client clicked. Example: the client can click on option A, option B and option C. Client chose option A and option C. This client only sees these options. When I enter option A and option C in my Excel file, I would like the output to be what the different variables are for option A and option C so I will be able to know how to respond to this client's needs.

Answer 1

Hi MariaPatino1,

If you are looking to create a dependent dropdown lists and considering using Microsoft forms, this feature is not yet available. In Microsoft Forms you can only add branching i.e., it allows you to add a logic to a survey or quiz so that it changes according to the responses to specific questions. In a survey or quiz that branches, questions appear only if they are relevant to the respondent. If the questions don't apply, the respondent is redirected to a different set of questions or will skip a set of questions altogether.

Reference: Use branching logic in Microsoft Forms

Besides, if you want to create the list in Excel, please check the following links:

Create Dependent Drop Down Lists

How to Create a Dependent Drop-Down List in Microsoft Excel

---

***Third-party link disclaimer:***Microsoft provides no assurances and/or warranties, implied or otherwise, and is not responsible for the information you receive from the third-party linked sites or any support related to technology.

Regards,

Neha

Answer 2

Thank you!