How to Add a Likert Scale in Google Forms

Getting a clean, accurate measure of human opinion is harder than it looks.

If you hand someone a blank text box, you get messy, unquantifiable noise.

If you force them into a simple yes or no, you miss the nuances of how strongly they feel.

This is why the Likert scale remains the backbone of modern survey design.

Here is how to build them correctly in Google Forms, whether you need a single rating or a massive matrix of statements.

What is a Likert scale and when should you use it?

A Likert scale measures attitudes or opinions by asking people the extent to which they agree or disagree with a statement.

It was developed by psychologist Rensis Likert to capture intensity of feeling, rather than just a binary yes or no.

A true Likert scale is symmetric.

It balances an equal number of positive and negative options around a neutral midpoint.

In Google Forms, you have two primary ways to present this type of measurement to your respondents.

You can either use a standalone linear scale for a single question, or a multiple choice grid to bundle several related statements together.

Choosing the right format depends on how many items you are measuring and what device your respondents are using.

When deciding between the two, consider the physical screen your respondent is holding.

A matrix grid looks professional on a desktop monitor, but it collapses poorly on a narrow smartphone screen.

If you know your audience will be tapping answers on the bus or during a lunch break, standalone linear scales are much safer.

How to create a single Likert question using the linear scale option

The standalone linear scale is the simplest way to add a Likert item in Google Forms.

It presents a horizontal line of radio buttons, anchored by text labels at the extreme ends.

This visual layout naturally signals a continuum from low to high, or negative to positive.

Here is how to set one up:

1. Open your form and click the Add question button (the plus icon) on the floating right-hand menu.

2. Click the dropdown menu in the top right corner of the new question box.

3. Select Linear scale from the list of question types.

4. Type your statement into the Question field (for example, The software is easy to navigate).

5. Look at the numbered dropdowns below the question text.

6. Set the starting value to 1.

7. Set the ending value to either 5 or 7, depending on how much nuance you need.

8. Click into the Label (optional) field next to the number 1 and type your lowest anchor (for example, Strongly disagree).

9. Click into the label field next to your highest number and type your top anchor (for example, Strongly agree).

10. Toggle the Required switch at the bottom right if you want to force a response before the user can submit.

Google Forms only allows you to label the two extreme poles of a linear scale.

You cannot add a text label to the number 3 or 4 in the middle of the scale.

For most respondents, the visual layout makes the intermediate steps obvious, but if you absolutely must label every single radio button with text, you will need to use a multiple choice format instead.

Also, notice that Google allows you to start your scale at 0.

For a true Likert scale measuring agreement, you should generally start at 1.

Starting at 0 implies an absence of feeling or a completely void metric, which aligns more with a Net Promoter Score (NPS) than an attitude scale.

How to build a multi-question Likert matrix using a grid

When you have a block of related statements - such as evaluating different aspects of a single training session - asking them one by one is exhausting.

Grouping them into a matrix reduces survey fatigue.

The respondent only has to read the column headers once, and they can quickly work their way down the rows.

Google Forms handles this through the grid function.

1. Click the Add question button to create a new block.

2. Open the question type dropdown and select Multiple choice grid.

3. In the main Question field, write the overarching instruction (for example, Please rate your agreement with the following statements about today's workshop).

4. Look for the section labeled Rows.

5. Type your first specific statement into row 1 (for example, The presenter was engaging).

6. Press Enter or click Add row to type your second statement (for example, The materials were useful).

7. Continue adding rows until your theme is complete.

8. Look for the section labeled Columns on the right side of the editor.

9. Type your lowest scale point into column 1 (for example, Strongly disagree).

10. Add your remaining scale points in order across the columns (for example, Disagree, Neutral, Agree, Strongly agree).

11. Toggle the switch at the bottom right labeled Require a response in each row.

That last step is critical.

If you forget to require a response in each row, a respondent might skip a statement by accident, leaving you with incomplete data.

You also need to be careful about the width of your grid.

If you add a 7-point scale with long text labels in every single column, the table will stretch far beyond the margins of a standard screen.

Keep your column headers concise.

If you have more than seven statements in the rows, consider breaking the grid into two separate questions.

A massive wall of radio buttons triggers a psychological reaction called the paradox of choice, where the sheer volume of options causes respondents to abandon the survey entirely.

How should you label your scale points for clear responses?

The words you choose for your scale points matter just as much as the questions you ask.

If your labels are vague, respondents will interpret them differently, ruining the reliability of your data.

A good Likert scale is always symmetrical and usually bipolar.

Bipolar means it stretches across two opposite concepts (like disagreeing and agreeing) with a true neutral midpoint bridging them.

Unipolar scales, on the other hand, measure the presence or absence of a single concept (like going from not at all satisfied to extremely satisfied).

Here are three reliable ways to label your options depending on what you need to measure.

1. The classic agreement scale (Bipolar, 5-point)

This is the most common format. Use it when you present a definitive statement and want to measure the respondent's alignment with it.

• Strongly disagree
• Disagree
• Neither agree nor disagree
• Agree
• Strongly agree

If you need a 7-point version to capture slight leanings, you can insert Somewhat disagree and Somewhat agree on either side of the neutral midpoint.

2. The satisfaction scale (Unipolar, 5-point)

Use this when evaluating a product, a customer service interaction, or an event.

• Extremely dissatisfied
• Somewhat dissatisfied
• Neither satisfied nor dissatisfied
• Somewhat satisfied
• Extremely satisfied

Notice that this scale still has a neutral center, but it focuses entirely on the spectrum of satisfaction rather than agreement.

3. The frequency scale (Unipolar, 5-point)

Use this when you need to know how often a behavior occurs.

• Never
• Rarely
• Sometimes
• Often
• Always

When writing your labels, consistency is your best tool.

Do not mix formatting styles within the same survey.

If you use Strongly agree on page one, do not switch to Completely agree on page two.

Repetition helps the respondent learn the rules of your survey quickly, allowing them to focus their mental energy on the actual statements rather than deciphering your interface.

What design mistakes confuse respondents on a rating scale?

Even with the right labels and the right Google Forms settings, poor question design will ruin your survey.

When respondents get confused, they either drop out or start picking middle options just to get to the end.

Here are the most common pitfalls to avoid when writing your Likert items.

Unbalanced options

A scale must have an equal number of positive and negative choices.

If you skew the scale to make your results look better, your data is compromised.

• ❌ Weak: Poor, Average, Good, Very Good, Excellent
• ✅ Strong: Very Poor, Poor, Average, Good, Very Good

The weak example has three positive options and only one truly negative option, which artificially inflates the average score.

Double-barreled statements

This happens when you ask a respondent to rate two different things in a single sentence.

If a user agrees with one half but disagrees with the other, they will not know how to answer.

• ❌ Weak: The app is fast and easy to use.
• ✅ Strong: The app is fast.
• ✅ Strong: The app is easy to use.

Split double-barreled items into two separate rows in your Google Forms grid.

Inconsistent polarity

Polarity refers to which side of the scale is the "good" side.

Most people instinctively expect the right side of a scale (the higher numbers) to represent the positive or agreeing sentiment.

If you randomly flip this midway through the survey, placing Strongly agree on the left, respondents relying on muscle memory will accidentally give you the exact opposite of their true opinion.

Keep the positive end on the right side consistently throughout your entire form.

Missing "Not Applicable" options

Sometimes a statement simply does not apply to a user.

If you force them to answer a required Likert grid row about a feature they have never used, they will usually pick the neutral midpoint.

This pollutes your data, because you cannot tell the difference between someone who truly felt neutral and someone who was just forced to click a button.

Unfortunately, Google Forms does not let you add a separate "N/A" checkbox outside of a linear scale.

Expert tip: If you are using a multiple choice grid and suspect some rows won't apply to everyone, add a final column labeled Not Applicable alongside your 5 scale points.

Mixing questions and statements

A Likert scale is designed to measure agreement with a statement.

It is not designed to answer a direct question.

• ❌ Weak: How much did you like the new schedule? (Followed by an agree/disagree scale).
• ✅ Strong: The new schedule works well for my team. (Followed by an agree/disagree scale).

Keep your phrasing declarative.

How do you export and analyze your survey data?

Once the responses roll in, looking at the colorful pie charts in the Google Forms Responses tab is only mildly helpful.

To truly understand Likert data, you need to pull it into a spreadsheet.

Click the Link to Sheets button (the green spreadsheet icon) in the top right corner of the responses tab.

Google Forms will generate a new Google Sheet containing every submission.

If you used the Linear scale question type, your data will naturally export as numbers (1 through 5).

If you used the Multiple choice grid question type, your data will export as the exact text labels you typed into the columns (such as "Strongly agree").

Text labels are difficult to average.

To analyze grid data, you will need to convert those text strings into numerical values.

You can do this safely in a new column next to your raw data using an IFS formula.

For example, you could write a formula like: =IFS(B2="Strongly disagree", 1, B2="Disagree", 2, B2="Neutral", 3, B2="Agree", 4, B2="Strongly agree", 5)

Once your data is numerical, you face a common statistical debate: should you calculate the mean (average) or the median?

Technically, Likert data is ordinal.

This means the sequence is clear, but the exact mathematical distance between "Agree" and "Strongly agree" is subjective.

Strict statisticians will tell you to only use the median or mode for ordinal data.

In practice, in the business world, calculating the mean score of a 5-point scale is the industry standard.

It provides a quick, understandable benchmark that you can track over time.

Just be aware of its limitations.

If half your respondents choose 1 and the other half choose 5, your average will be 3.

Looking only at the average would suggest everyone felt neutral, completely masking the fact that your audience is deeply polarized.

Always look at the distribution of the responses, not just the final average score.

FAQ

Can you use emojis for a Likert scale in Google Forms?

Yes, you can paste emojis directly into the text fields for your labels or column headers. This works well for simple satisfaction surveys (using sad to happy faces) aimed at younger audiences or quick feedback forms. Just ensure the emojis are universally understood and do not rely solely on color, as this can cause accessibility issues.

How do I make a Likert scale question required in Google Forms?

For a standalone linear scale, toggle the Required switch at the bottom right corner of the question block. For a multiple choice grid, toggle the switch labeled Require a response in each row. If you leave this off, respondents can submit the form while leaving parts of the matrix blank.

Is a 5-point or 7-point Likert scale better for surveys?

A 5-point scale is generally better for general audiences because it is faster to read and fits better on mobile screens. A 7-point scale is better when you need finer granularity and are surveying an audience willing to spend more time, such as in academic research or detailed employee feedback. Avoid scales with 9 or more points, as respondents struggle to differentiate the middle options.

Can I randomize the row order in a Google Forms grid?

Yes. Click the three-dot menu icon in the bottom right corner of the multiple choice grid question block. Select Shuffle row order from the pop-up menu. This is a great way to prevent order bias, ensuring that respondents do not fall into a pattern of just clicking down the left side without reading.

Moving your questions out of a messy document and into a clean, structured interface is the best thing you can do for your response rates. If you have an existing questionnaire drafted in Word or Acrobat, you don't necessarily have to type everything out manually again; tools like Doc2Form can automatically convert a document to Google Form format for you. Whatever method you use to build it, keep your scales balanced, your labels consistent, and your matrices short.