How to Create a Survey in Excel (2 Easy Methods)

We will use Microsoft 365 as the first method, and Microsoft OneDrive as the second method to create a survey.

Watch Video – Create a Survey in Excel

Method 1 – Manually Creating a Survey in Excel

The following table has Question, Response 1, and Response 2 columns. We will add a box for the Option button, and then we will add Option Buttons.

Steps:

Go to the Developer tab >> select the Insert option >> select Group Box (Form Controls).

A plus sign will appear, marked here with the red box.

Click on the plus and hold until a box is drawn.

You can edit or remove the box name according to your needs.

Type a question in the Question column.

To add Option Buttons, go to the Developer tab >> select Insert option >> select Option Button (Form Controls).

A plus sign will appear marked here with a red box.

Click on the plus sign with the mouse and hold until a button is inserted.

Edit the name according to the survey requirements.
Here the Option Button is named Yes.

To add a second option, again go to the Developer tab >> select Insert option >> select Option Button (Form Controls).

Now we have one question column with two response options.

Repeat these steps to add any further questions.

Method 2 – Using Microsoft OneDrive App to Create a Survey

Steps:

Go to Microsoft OneDrive >> click on New >> select Forms survey.

A Survey form will appear.

Add a title to the title box and enter a description in the description box.

We will see the title and description of the survey.

Click on Add New.

There will be several options to add content to the survey.

Text is selected here.

A question box appears where the question can be entered.

Click Add new to add another question.

Here, Choice is selected.

This returns a question box with two options. Edit both the question box and the options.

You can add more options by clicking on Add option.
Click on Add new to add another question to the survey.

You can add a Rating option.

Enter a third question box. You can choose the Symbol and Levels according to your needs.

You can select the Date and More question type from the Add new options, and you can add more questions according to the survey requirements.

However, we need three questions to create a survey.