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.

How to Create a Survey in Excel

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.

How to Create a Survey in Excel

 

  • 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).

How to Create a Survey in Excel

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).

How to Create a Survey in Excel

Now we have one question column with two response options.

Repeat these steps to add any further questions.

 

How to Create a Survey in Excel


Method 2 – Using Microsoft OneDrive App to Create a Survey

 

Steps:

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

How to Create a Survey in Excel

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.

How to Create a Survey in Excel

A question box appears where the question can be entered.

 

  • Click Add new to add another question.

How to Create a Survey in Excel

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.

How to Create a Survey in Excel

  • 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.

  • The Theme option allows users to select a new style.

 

  • The Purple color is selected in this example.

  • Click on Preview to see the preview of the survey.

 

How to Create a Survey in Excel

  • Click Send to share the survey. Alternatively click Copy to copy the link.


Practice Section

In the practice section of your sheet, you can practice the explained methods.

How to Create a Survey in Excel


Download Practice Workbook


Survey in Excel: Knowledge Hub


<< Go Back to Excel for Statistics | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Afia Kona
Afia Kona

Afia Aziz Kona, a graduate of NAME from Bangladesh University of Engineering & Technology, Bangladesh, serves as a technical content creator in the ExcelDemy project. Possessing a passion for innovation and critical thinking, she actively embraces challenges. Beyond her engineering background, Afia exhibits a keen interest in Excel, having authored numerous articles on Excel & VBA-related issues to simplify the experience for users facing obstacles in Excel. Apart from creating Excel tutorials, she is also interested... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo