Others

How to Create Likert and Ranking Surveys in Microsoft Forms

Tauseeq Magsi Oct 22, 2026 868 views

Question details

The user needs to know if and how they can collect ratings for multiple items on a scale and ask respondents to rank items by importance using Microsoft Forms.

How to Create Likert and Ranking Surveys in Microsoft Forms

Product: Microsoft Forms
Device & OS: not provided
Scenario: Creating an advanced survey or questionnaire that requires respondents to evaluate statements on a scale and prioritize specific answer choices.
Observed behavior: The user is seeking instructions on implementing Likert and ranking question types to accurately measure respondent preferences and priorities.

Before you start

Ensure you are signed into your Microsoft account and have opened the specific form or quiz you wish to edit in Microsoft Forms.

Solution 1Recommended

Adding a Likert Scale Question in Microsoft Forms

Use the Likert question type to gauge attitudes or opinions across multiple related statements on a single scale.

Likert scales are ideal for measuring the degree of agreement, quality, or likelihood across a series of statements without cluttering your survey with individual multiple-choice questions.

Add a new question

Open your form in Microsoft Forms and click the '+ Add new' button.

Access more question types

Click the drop-down arrow (More question types) located on the right side of the standard question options.

Select Likert

Choose 'Likert' from the drop-down menu to insert the question block.

Customize statements and options

Enter your main question prompt. Then, customize the rating options across the top (e.g., Strongly Disagree to Strongly Agree) and input the specific statements you want rated down the left side.

Adding a Likert Scale Question in Microsoft Forms

Customizing the Scale: You can easily add or remove columns to adjust the scale size, and add or remove rows to modify your list of statements.

Solution 2

Adding a Ranking Question in Microsoft Forms

Use the Ranking question type to allow respondents to organize a list of options in their preferred order of importance.

Free Microsoft Office alternative

Analyze Your Survey Data with WPS Office

After collecting responses via Microsoft Forms, analyzing the exported data often requires a capable spreadsheet tool. WPS Office provides a free, lightweight, and highly compatible alternative to Microsoft Office for processing and visualizing your survey results.

1. Export Responses: In Microsoft Forms, go to the Responses tab and click 'Open in Excel' to download your survey data.
2. Open with WPS Spreadsheet: Launch WPS Office and open the downloaded .xlsx file.
3. Analyze Data: Use WPS Spreadsheet's built-in charts and pivot tables to summarize your Likert and Ranking data effortlessly.

Fully compatible with Microsoft Excel (.xlsx) formats for seamless survey data analysis.Free and lightweight suite including Spreadsheet, Writer, Presentation, and PDF tools.Familiar, intuitive user interface that makes pivot tables and charts easy to create.

microsoft office alternative - wps office

Frequently Asked Questions

Can I change the number of rating options in a Likert scale?

Yes, in Microsoft Forms, you can easily add or delete columns in a Likert question to adjust the scale from a standard 5-point system to your desired number of options.

How do respondents interact with ranking questions on mobile devices?

On mobile devices, respondents can tap the up and down arrows next to each option in a Ranking question to move items into their preferred order, rather than using a drag-and-drop motion.

Is it possible to make Likert or Ranking questions required?

Yes, you can toggle the 'Required' switch at the bottom right of the question card to ensure respondents must complete the Likert or Ranking question before successfully submitting the form.

Office Quick Solutions