Google Docs to Forms - Formswrite.com logo
BlogPricing

Linear Scale and Likert Scale in Google Forms

Dvir Atias

Dvir Atias

Sep 14, 2026

Linear Scale and Likert Scale in Google Forms

Linear Scale and Likert Scale in Google Forms: Setup, Examples, and Analysis

Google Forms has a built-in Linear scale question that asks respondents to pick one number on a scale, from a start of 0 or 1 to an end of anywhere from 2 to 10, with optional labels at each end. It has no dedicated Likert scale question, but you can build one with a Multiple choice grid, putting your statements in the rows and agreement options such as Strongly disagree to Strongly agree in the columns.
This guide explains when to use each one, how to set them up step by step, which labels work, and how to read the results.

Linear scale vs Likert scale vs rating in Google Forms

Linear scaleLikert scale (Multiple choice grid)Rating
What it looks likeA row of numbers with labels at both endsA table of statements and agreement columnsStars, hearts, or thumbs up
RangeStarts at 0 or 1, ends at 2 to 10Any number of columns you add3 to 10 icons
LabelsOnly the two ends (and the start and end)Every column has a labelNo text labels on each icon
Items per questionOneMany statements in one questionOne
Best forSingle ratings: confidence, difficulty, satisfactionAttitude surveys with several statementsQuick, informal ratings
Results viewOne bar chartOne grouped bar chart across rowsOne bar chart
A quick rule: if you are asking one thing, use a linear scale. If you are asking respondents to rate agreement with several statements on the same scale, use a multiple choice grid.

What is a Likert scale, exactly?

A Likert scale, named after psychologist Rensis Likert, is a set of statements that respondents rate on an agreement scale, usually five or seven points. Strictly speaking, a single item (one statement) is a Likert-type item, and the scale is the combined set of items measuring one topic. In everyday use, people call any agree to disagree question a Likert scale.
Common 5-point response sets:
  • Agreement: Strongly disagree, Disagree, Neutral, Agree, Strongly agree
  • Frequency: Never, Rarely, Sometimes, Often, Always
  • Satisfaction: Very dissatisfied, Dissatisfied, Neutral, Satisfied, Very satisfied
  • Confidence: Not at all confident, Slightly confident, Moderately confident, Very confident, Extremely confident

How to add a linear scale question in Google Forms

Step 1: Add a question and choose Linear scale

Open your form, click the plus icon to add a question, and select Linear scale from the question type dropdown.

Step 2: Set the range

Choose the start value (0 or 1) and the end value (2 through 10). A 1 to 5 scale suits most classroom and feedback questions. A 0 to 10 scale is common for likelihood questions.

Step 3: Add labels to the ends

Type labels for the lowest and highest values, for example 1 = Not confident and 5 = Very confident. Without labels, respondents have to guess whether 1 is good or bad.

Step 4: Make it required if needed

Toggle Required at the bottom of the question if you need an answer from everyone.

Linear scale examples

  • How confident do you feel about solving two-step equations? (1 = Not confident, 5 = Very confident)
  • How difficult was today's homework? (1 = Very easy, 5 = Very hard)
  • How likely are you to recommend this workshop to a colleague? (0 = Not at all likely, 10 = Extremely likely)
  • How clear were the instructions for the lab? (1 = Very unclear, 5 = Very clear)

How to make a Likert scale in Google Forms

Step 1: Add a Multiple choice grid question

Add a question and choose Multiple choice grid. Give it a title, such as How much do you agree with each statement about this unit?

Step 2: Add the statements as rows

Under Rows, type one statement per row:
  • The lessons were well organized.
  • I understood how the unit would be graded.
  • The practice activities helped me learn.
  • I would like more group work.

Step 3: Add the scale as columns

Under Columns, add your response options in order: Strongly disagree, Disagree, Neutral, Agree, Strongly agree.

Step 4: Set the grid options

Turn on Require a response in each row so no statement is skipped. From the three-dot menu, you can also choose Shuffle row order to reduce order effects. Leave Limit to one response per column off for a Likert scale, since several statements can share the same answer.

Writing better scale questions

  1. Label the scale clearly. Word labels on every point are easier to interpret than numbers alone. That is an advantage of the grid approach.
  2. Decide on a neutral option. A 5-point scale gives a middle choice. A 4-point scale forces a lean one way. Neither is always right; it depends on whether "no opinion" is a meaningful answer for your question.
  3. Keep the direction consistent. If 5 means positive in one question, it should mean positive in all of them.
  4. Avoid leading statements. "The excellent new schedule helped me" nudges agreement. "The new schedule helped me" does not.
  5. Keep grids a manageable size. Long grids are tiring on phones, where respondents may have to scroll sideways. Split a long list into two or three grids or sections.
  6. Include one or two negatively worded items with care. They can catch people clicking the same column for everything, but they also confuse younger students.

How to analyze linear scale and Likert results

In the Responses tab

Open Responses and then Summary. A linear scale question shows a bar chart with the count for each number. A multiple choice grid shows a grouped bar chart with every statement and how many people chose each column. This view is enough to spot the statements with the most disagreement. For more on reading this view, see how to view responses in Google Forms.

In Google Sheets

Click Link to Sheets in the Responses tab to send responses to a spreadsheet. Each grid row becomes its own column.
  • Linear scale: the values are already numbers, so use AVERAGE, MEDIAN, and COUNTIF directly.
  • Likert grid: the values are text labels. Add a helper column that converts them to numbers (Strongly disagree = 1 up to Strongly agree = 5), then summarize.
A few analysis habits:
  • Report the distribution, not just the average. An average of 3 could mean everyone chose Neutral or half the class chose 1 and half chose 5.
  • Use percent agree. Combining Agree and Strongly agree into one percentage is easy to explain to colleagues and parents.
  • Compare the same item over time. Asking the same confidence question at the start and end of a unit is more informative than a single snapshot.
For a broader look at charts and summaries, see Google Forms analytics.

Can a linear scale be graded in a quiz?

No. Google Forms answer keys work on short answer, multiple choice, checkboxes, dropdown, multiple choice grid, and checkbox grid questions, not linear scale. That is usually fine, because scales measure opinion or confidence rather than right answers. A common pattern is to add one ungraded confidence question at the end of a quiz, which gives useful context when you look at scores.

Build survey and quiz forms faster

If your survey statements or quiz questions already exist in a document, Formswrite can turn a Word file, Google Doc, or PDF into a form, and you add the scale questions at the end. See Word to Google Form or the Google Form quiz generator. Google Forms export is on paid plans; the free plan includes Formswrite forms and flashcards.

FAQ

Does Google Forms have a Likert scale question?
Not as a separate type. Use a Multiple choice grid with statements as rows and agreement options as columns. For a single statement, a Linear scale or a Multiple choice question with agreement options also works.
What range can a linear scale have in Google Forms?
The scale starts at 0 or 1 and ends at any value from 2 to 10. You can add a text label to the lowest and highest values.
Can I label every point on a linear scale?
No. Linear scale only supports labels on the two ends. If you want a label on every point, use a Multiple choice question or a Multiple choice grid instead.
What is the difference between linear scale and rating in Google Forms?
Linear scale shows numbers with optional end labels. Rating shows icons such as stars, hearts, or thumbs up, from 3 to 10 of them. Both collect one value per question.
Should a Likert scale have 5 or 7 points?
Five points is the most common and easiest for students to use. Seven points gives more nuance for adult respondents. Use the same number throughout a survey so results are comparable.
How do I calculate the average of Likert responses?
Link the form to Google Sheets, convert each label to a number such as 1 for Strongly disagree through 5 for Strongly agree, then use AVERAGE. Also look at the distribution, since averages hide split opinions.

Related guides

Generate multiple choice questions from any text

Paste a lesson or upload a document and Formswrite writes graded multiple choice questions with an answer key.

Generate questions

Or go straight to a converter: Google Docs to Forms, PDF to Google Form, Word to Google Form, Google Forms Quiz Generator


Share this post with your network

Back to Blog
Formswrite

Ask AI to compare Formswrite for you:

ChatGPTClaudeGeminiPerplexityGrok

Company

About usPricingContact usTerms of ServicePrivacy PolicyRefund PolicyAffiliate Program

Formswrite is the AI-powered form builder for educators, training centers, and businesses that need to convert documents into Google Forms, quizzes, and assessments without rebuilding from scratch. Upload a Google Doc, Word, PDF, image, or spreadsheet - Formswrite extracts the questions, structure, and grading rules, then exports to Google Forms, Canvas, Moodle, Kahoot, Quizizz, and more.

Trusted by educators, training teams, and HR departments worldwide. Formswrite's AI tools - quiz generator, worksheet generator, lesson-plan generator, rubric generator, and flashcard builder - are centralized in one platform.

Our brands

Docswrite logo

Docswrite

Zoral logo

Zoral

JobsPipe logo

JobsPipe

Français Prep logo

Français Prep

© 2026 Formswrite. All rights reserved.

Terms
Privacy
llms.txt
llms-full.txt