contador web Skip to content

How to create a survey form in Excel Online | Productivity

Excel online allows you to create survey forms. The free tool produces a quiz that can be shared with friends and business contacts via a link. Excel surveys make it possible to add multiple questions that receive different answer patterns. Therefore, users can define questions with yes or no style answers, multiple choice and text answers. The resource is suitable for students who need to conduct academic research or for businesses and professionals who want to receive feedback from their clients.

Excel formulas: the 68 most important functions of the program

To access Excel Online, users must use access credentials from a Microsoft account. Documents created on the platform are saved online and can be accessed at any time. For searches, data with results are displayed by clicking on the document in Excel Online files. Check out in the following tutorial how to create and track search results in Excel Online.

Tutorial shows how to create a survey form by Excel Online Photo: Divulgao / MicrosoftTutorial shows how to create a survey form by Excel Online Photo: Divulgao / Microsoft

Tutorial shows how to create a survey form by Excel Online Photo: Divulgao / Microsoft

Want to buy a cell phone, TV and other discounted products? Meet the Compare TechTudo

How to create a survey form

Step 1. Access Excel online enter your email using to access Microsoft services;

When to log in to Excel online with a Microsoft account Photo: Reproduo / Marvin CostaWhen to log in to Excel online with a Microsoft account Photo: Reproduo / Marvin Costa

When to log in to Excel online with a Microsoft account Photo: Reproduo / Marvin Costa

Step 2. Enter your Microsoft password and click the "Sign In" button;

When to log in to a Microsoft Excel account online Photo: Reproduo / Marvin CostaWhen to log in to a Microsoft Excel account online Photo: Reproduo / Marvin Costa

When to log in to a Microsoft Excel account online Photo: Reproduo / Marvin Costa

Step 3. Open a blank document using the "New Blank Workbook" option;

When to open a blank document in Excel online to create a survey Photo: Reproduction / Marvin CostaWhen to open a blank document in Excel online to create a survey Photo: Reproduction / Marvin Costa

When to open a blank document in Excel online to create a survey Photo: Reproduction / Marvin Costa

Step 4. Select the temporary document title at the top of the screen and enter a name for the search;

By naming an Excel document to be set to search Photo: Reproduction / Marvin CostaBy naming an Excel document to be set to search Photo: Reproduction / Marvin Costa

By naming an Excel document to be set to search Photo: Reproduction / Marvin Costa

Step 5. In the "Insert" tab, click on search and then on the "New Search" option;

By creating an Excel survey online Photo: Reproduction / Marvin CostaBy creating an Excel survey online Photo: Reproduction / Marvin Costa

By creating an Excel survey online Photo: Reproduction / Marvin Costa

Step 6. Retype a search name instead of the phrase at the top of the screen. Then click on the gear icon next to the "Type your first question here" description, as shown in the image below;

When to create a question in an Excel Online survey Photo: Reproduction / Marvin CostaWhen to create a question in an Excel Online survey Photo: Reproduction / Marvin Costa

When to create a question in an Excel Online survey Photo: Reproduction / Marvin Costa

Step 7. In the "Edit Question" tab, type your question, add a subtitle and define which type of answer you want to add. You can choose "Text", "Paragraph Text", "Number", "Date", "Time", "Yes / No" or "Option". For this example, we will use "Opo";

Actions to edit a question in a new survey created in Excel Online Photo: Reproduction / Marvin CostaActions to edit a question in a new survey created in Excel Online Photo: Reproduction / Marvin Costa

Actions to edit a question in a new survey created in Excel Online Photo: Reproduction / Marvin Costa

Step 8. Under "Default Answer", type three answer options. To proceed, click "Done";

When to set answer options for a question in a survey form created in Excel Online Photo: Reproduction / Marvin CostaWhen to set answer options for a question in a survey form created in Excel Online Photo: Reproduction / Marvin Costa

When to set answer options for a question in a survey form created in Excel Online Photo: Reproduction / Marvin Costa

Step 9. Keep adding new questions until you finish your quiz. To do this, click on the option "Add a new Question";

When to add new questions in a survey form created in Excel Online Photo: Reproduction / Marvin CostaWhen to add new questions in a survey form created in Excel Online Photo: Reproduction / Marvin Costa

When to add new questions in a survey form created in Excel Online Photo: Reproduction / Marvin Costa

Step 10. When finished the search, click on the option "Save and Display";

By saving and displaying a survey created in Excel Online Photo: Reproduction / Marvin CostaBy saving and displaying a survey created in Excel Online Photo: Reproduction / Marvin Costa

By saving and displaying a survey created in Excel Online Photo: Reproduction / Marvin Costa

Step 11. Review your search data and click the "Share Search" button located at the bottom of the screen;

When to view the sharing link for a survey created in Excel Online Photo: Reproduo / Marvin CostaWhen to view the sharing link for a survey created in Excel Online Photo: Reproduo / Marvin Costa

When to view the sharing link for a survey created in Excel Online Photo: Reproduo / Marvin Costa

Step 12. Just copy the generated link and send the search to person via email, social networks and messengers.

Share link to Excel Online survey Photo: Reproduo / Marvin CostaShare link to Excel Online survey Photo: Reproduo / Marvin Costa

Share link to Excel Online survey Photo: Reproduo / Marvin Costa

Tracking Search Results

Step 1. Go to the Excel Online homepage and click on the search name in the list of saved documents;

By opening results from a survey created in Excel Online Photo: Reproduction / Marvin CostaBy opening results from a survey created in Excel Online Photo: Reproduction / Marvin Costa

By opening results from a survey created in Excel Online Photo: Reproduction / Marvin Costa

Step 2. You can check the answers of each person who received the questionnaire.

When viewing Excel Online survey results Photo: Reproduction / Marvin CostaWhen viewing Excel Online survey results Photo: Reproduction / Marvin Costa

When viewing Excel Online survey results Photo: Reproduction / Marvin Costa

Ready. Take advantage of the tip to conduct academic research or customer activities using Excel Online.

How to delete all blank lines in Excel at once

How to delete all blank lines in Excel at once