How to Add a Linear Scale Question in Google Forms

Getting someone to open a survey is hard; getting them to finish it is harder.

When faced with a wall of text boxes, most people simply close the tab.

A linear scale fixes this by turning complex opinions into a single, effortless click.

Here is exactly how to build, format, and analyze linear scale questions in Google Forms without skewing your data.

What is a linear scale question in Google Forms?

A linear scale is a specific question type in Google Forms that asks respondents to choose a single rating along a numeric continuum.

Instead of typing out an answer or selecting from a list of disparate text options, the user clicks a single radio button corresponding to a number.

This format is universally understood, visually compact, and highly effective for measuring sentiment, satisfaction, or frequency.

The visual anatomy of a linear scale question consists of three main components.

First, there is the prompt itself, which establishes the context of what you are measuring.

Second, there is the numeric range.

Google Forms forces this range to start at either 0 or 1, and it can end anywhere up to 10.

These numbers appear as a horizontal row of clickable radio buttons on desktop screens, or a tightly stacked horizontal row on mobile devices.

Third, there are the optional endpoints.

These are text labels that sit directly beneath or beside the lowest and highest numbers on your scale.

While Google Forms marks these labels as optional, they are critical for survey clarity.

Without endpoint labels, respondents are left guessing whether a "1" means terrible or excellent.

From the creator's view in the editing interface, the linear scale looks like a set of dropdown menus where you define the minimum and maximum values, followed by two text fields for your labels.

From the respondent's view, it renders as a clean, continuous line of options that requires almost zero cognitive load to process.

Because the underlying data is captured as a pure number, linear scales make post-survey analysis mathematically straightforward.

How to add a linear scale question in Google Forms

Adding a linear scale to your form takes only a few clicks, but setting it up correctly requires attention to the specific settings menus.

Follow these exact steps to insert and configure your scale.

1. Open your survey in Google Forms and click the + icon on the floating toolbar on the right side of the screen.

2. Click the question type dropdown menu in the top right corner of the newly created question box.

3. Scroll down and select Linear scale from the list of options.

4. Click the first numeric dropdown (which defaults to 1) and choose whether your scale should start at 0 or 1.

5. Click the second numeric dropdown (which defaults to 5) and set your maximum value, up to a limit of 10.

6. Click into the text field labeled Label (optional) next to your starting number and type your minimum extreme.

7. Click into the text field next to your maximum number and type your maximum extreme.

8. Type your actual question into the main Question field at the top of the block.

Once the basic structure is in place, you should add context to ensure respondents understand exactly what they are rating.

Click the three-dot menu icon in the bottom right corner of the question block and select Description.

This opens a smaller text field directly below your main question prompt.

Use this space to clarify the timeframe or the specific interaction you are asking about, which prevents users from applying their own shifting criteria to the numeric scale.

Finally, you need to decide if this rating is mandatory.

If you are using the rating as a core metric for your business or classroom, click the Required toggle at the bottom right of the question box so it turns purple.

If you leave it optional, users skipping the question will result in blank cells in your data export, which can complicate your average calculations later.

Expert tip: If you are building a long survey with multiple identical scales (like rating five different presentations from 1 to 5), build your first linear scale perfectly, then click the Duplicate icon next to the trash can. This copies your numeric range and endpoint labels, saving you from retyping them every time.

How to set up a 1 to 10 scale for NPS surveys

The Net Promoter Score (NPS) is the most common use case for a 0 to 10 linear scale.

NPS is a standardized metric used to gauge customer loyalty by asking one specific question about likelihood to recommend.

Because the NPS methodology relies on a strict mathematical formula sorting respondents into Detractors (0-6), Passives (7-8), and Promoters (9-10), you must configure your Google Form to match these rules exactly.

If you start your scale at 1 instead of 0, or end it at 5 instead of 10, you are no longer measuring NPS and cannot benchmark your results against industry standards.

Here are three concrete examples of how to set up industry-standard rating scales, starting with the classic NPS configuration.

Example 1: The standard NPS configuration

• Question prompt: How likely are you to recommend our service to a friend or colleague?
• Scale range: 0 to 10
• Left label (0): Not at all likely
• Right label (10): Extremely likely

This exact wording is the gold standard for NPS.

Do not alter the labels to be overly clever or brand-specific, as it introduces friction for the reader.

If you want to deploy this quickly, you can review a complete Google Forms NPS survey template to see how the follow-up questions should be structured.

Example 2: The Customer Satisfaction (CSAT) configuration

While NPS measures long-term loyalty on an 11-point scale, Customer Satisfaction (CSAT) measures immediate satisfaction with a specific event, usually on a 5-point scale.

• Question prompt: How satisfied were you with your support interaction today?
• Scale range: 1 to 5
• Left label (1): Very dissatisfied
• Right label (5): Very satisfied

A 1 to 5 scale is highly effective for CSAT because it provides a clear midpoint (3).

This allows respondents to express a truly neutral opinion if the interaction was neither notably good nor notably bad.

Example 3: The Customer Effort Score (CES) configuration

Customer Effort Score measures how easy or difficult it was for a user to accomplish a task.

Behavioral economics suggests that reducing friction is often a better driver of loyalty than creating delight, making CES a vital metric.

CES is traditionally measured on a 7-point scale to capture nuanced degrees of difficulty.

• Question prompt: To what extent do you agree with the following statement: The company made it easy for me to handle my issue.
• Scale range: 1 to 7
• Left label (1): Strongly disagree
• Right label (7): Strongly agree

Notice that CES flips the usual paradigm: it asks for agreement with a statement rather than a direct rating of a noun.

When setting up any of these three examples in Google Forms, the visual layout on mobile devices will dictate how easily the user can read the labels.

Because Google Forms automatically stacks numbers horizontally, a 0 to 10 scale on a narrow smartphone screen can look crowded.

Keeping your endpoint labels short and punchy ensures they do not wrap into unreadable blocks of text beneath the numbers.

How does a linear scale differ from a Likert scale?

People often use the terms linear scale and Likert scale interchangeably, but they are fundamentally different tools in survey design.

A linear scale uses numbers to represent a continuum between two extreme endpoints.

A Likert scale uses descriptive text for every single option along the continuum, forcing the respondent to read and evaluate the specific wording of each choice.

In Google Forms, you build a linear scale using the Linear scale question type, which gives you numbers.

To build a true Likert scale in Google Forms, you must use the Multiple choice grid question type and type out words like "Strongly Agree," "Agree," "Neutral," "Disagree," and "Strongly Disagree" as your column headers.

Understanding when to use numbers versus when to use words comes down to the cognitive load you want to place on your respondent.

Numbers are abstract and process quickly.

Words are concrete but require more reading time.

Here is a breakdown of how the two formats compare in practice.

If you are simply asking someone to rate a speaker out of five, a linear scale is the right choice.

If you are conducting academic research or trying to measure complex employee sentiment, a text-based format is often necessary to ensure precision.

You can learn more about the specific structure and history of text-based options in our detailed guide to the Likert scale.

In practice, the most common error is trying to force a linear scale to do the job of a Likert scale by cramming too much instruction into the question description.

If you find yourself writing "1 means you hated it, 2 means you disliked it, 3 means..." in the description field, you are using the wrong tool.

Switch to a multiple choice grid so you can label every point clearly.

What are the common mistakes to avoid when using rating scales?

Building a linear scale takes ten seconds, which makes it remarkably easy to build a bad one.

Poor scale design does not just annoy respondents; it actively corrupts your data.

When users are confused by the options, they tend to click the middle number just to move on, or they abandon the form entirely.

Here are four critical design pitfalls to avoid when setting up your scales.

1. Unbalanced or biased labels

The most damaging mistake you can make is skewing the endpoint labels to favor a positive result.

If your lowest possible score still sounds mildly positive, respondents have no way to express genuine dissatisfaction.

This leads to artificially inflated scores that hide real problems in your business or classroom.

• ❌ Weak: 1 = Good | 5 = Fantastic

• ✅ Strong: 1 = Terrible | 5 = Excellent

2. Asking two questions at once (Double-barreled prompts)

A linear scale only allows for a single numeric click.

If your prompt asks the user to evaluate two different concepts simultaneously, they will not know how to answer if they feel differently about each one.

This is known as a double-barreled question, and it renders the resulting data entirely useless because you cannot know which half of the prompt the user was scoring.

• ❌ Weak: How would you rate the speed and friendliness of our staff?

• ✅ Strong: How would you rate the speed of our staff?

• ✅ Strong: How would you rate the friendliness of our staff?

3. Flipping the numeric polarity mid-survey

In most cultures, higher numbers represent a better, stronger, or more positive outcome.

If you establish a pattern where 5 means "Excellent", your respondents will quickly learn this rhythm and start clicking rapidly.

If you suddenly insert a question where 1 means "Excellent" and 5 means "Terrible", many respondents will misread it and give you the exact opposite of their true opinion.

Keep your polarity consistent: always place the negative extreme on the left (the lowest number) and the positive extreme on the right (the highest number).

4. Using too many points on the scale

The paradox of choice dictates that offering too many options makes decision-making harder.

Google Forms limits you to 11 points (0 to 10), but even that is often too many.

Unless you are running a strict NPS survey that requires an 11-point scale by definition, asking a user to distinguish between a 7 and an 8 on a satisfaction scale is largely meaningless.

When faced with a 0 to 10 scale for a simple question, users experience higher cognitive load trying to justify their exact number.

For general feedback, stick to a 1 to 5 scale.

It is wide enough to capture nuance but narrow enough that the difference between a 3 and a 4 is obvious to the reader.

How to analyze and export your rating scale data

Collecting the responses is only the first half of the process.

To make decisions based on your linear scales, you need to understand how Google Forms aggregates this data.

When you click the Responses tab at the top of your Google Form, you will see a native summary view.

For linear scale questions, Google Forms automatically generates a horizontal bar chart.

The X-axis displays your numeric scale (e.g., 1 through 5), and the Y-axis shows how many respondents selected each number.

This visual distribution is incredibly useful for spotting trends at a glance.

If your bar chart looks like a bell curve with a massive spike in the middle, your respondents are largely neutral or indifferent.

If your chart shows a "U" shape with spikes at both 1 and 5, your audience is heavily polarized, meaning the average score will be completely misleading.

While the visual charts are helpful, serious analysis requires looking at the raw numbers.

Click the green Link to Sheets button in the top right corner of the Responses tab.

This creates a Google Sheet where every row is a respondent and your linear scale questions have their own dedicated columns.

Because linear scales output pure integers, you can immediately run basic spreadsheet formulas.

In your Google Sheet, type =AVERAGE(B2:B100) (replacing the range with your actual column) to find the mean score.

However, be cautious with averages when analyzing rating scales.

Ordinal data - where the distance between a 3 and a 4 might feel different to a user than the distance between a 4 and a 5 - is often better analyzed using the median or the mode.

Type =MEDIAN(B2:B100) to find the exact middle score, which ignores extreme outliers that might drag a standard average down.

Type =MODE(B2:B100) to find the most frequently chosen number, which tells you the most common experience your users had.

Expert tip: Once your data is in Google Sheets, highlight the column containing your linear scale scores and apply Conditional Formatting using a color scale. Set the lowest number to red and the highest number to green. This creates an instant visual heatmap, allowing you to spot unhappy respondents as you scroll through hundreds of rows.

If you are dealing with a massive volume of historical data on paper or in PDFs, manually typing those old survey results into a new Google Form for analysis is incredibly tedious.

You can often bypass this manual entry by using a tool to convert a survey PDF to Google Form format, letting you digitize your old rating scales and standardize your data collection moving forward.

FAQ

Can you use emojis as labels in a Google Forms linear scale?

Yes, you can insert emojis directly into the minimum and maximum label fields. Simply copy the emoji you want from an external site or use your computer's native emoji keyboard shortcut, and paste it into the Label text box. This works exceptionally well for visual scales, such as placing a 😡 at the 1 and a 🤩 at the 5.

How do I make a linear scale question required?

Click anywhere on the linear scale question block to make it active. In the bottom right corner of the question box, you will see a toggle switch labeled Required. Click this toggle so it slides to the right and turns purple, which will prevent respondents from submitting the form without clicking a rating.

Can I change the starting number of a linear scale to something other than 0 or 1?

No, Google Forms restricts the starting value of a linear scale to either 0 or 1. You cannot start a scale at a negative number like -5, nor can you start it at a higher number like 5. If you need a custom numeric range that does not start at 0 or 1, you must use the multiple choice or dropdown question types instead.

Why can't I add more than 10 points to my Google Forms linear scale?

Google Forms enforces a hard limit of 10 as the maximum value to prevent the user interface from breaking. If a scale contained 20 or 100 radio buttons, it would become unreadable and impossible to tap accurately on a mobile device screen. Limiting the scale ensures the form remains responsive and accessible across all screen sizes.

Clean rating data relies on making the respondent's job as easy as possible, and a well-labeled linear scale does exactly that. If you are migrating a stack of old survey documents and do not want to rebuild every scale by hand, Doc2Form can automatically read your files and generate the entire Google Form for you in seconds. Keep your scales short, label your endpoints clearly, and let the numbers tell you exactly what your audience thinks.