How to Add Star Rating System in Google Sheets – Track 5 ⭐️ customers easily

How to Add Star Rating System in Google Sheets – Track 5 ⭐️ customers easily
Reading Time: 5 minutes
Creating a Star Rating System in Google Sheets

Learn how to create a Star Rating System in Google Sheets.

Introduction

Ever given a product or service 5-stars for excellent service? Maybe 1-star if you were disappointed?

Star rating systems are usually used to score/rate the quality of products, services or experiences. A star rating system in Google Sheets is an easy visual way to analyse data related to user feedback. It becomes easier to visualize and interpret the user ratings this way than just displaying the corresponding scores.

Star rating system in Google Sheets is often used by Customer Support teams to monitor the feedback given by their users.

If you are an online seller and want to quickly visualize the rating shared against the corresponding customer ID, you might find this guide on how to create Star Rating system in Google Sheets especially helpful to identify 1-star or 5-star customers!

Inserting the star symbol in Google Sheets

In this article, I will explain the following two methods to create a Star Rating System in Google Sheets- 

  1. Method 1– Using the CHAR function
  2. Method 2– Using the emoji keyboard

Now let’s have a look at both methods.

Method 1- Using the CHAR function 

  • The CHAR function returns a character when a valid character code is given as input.
  • To insert a star symbol using the CHAR function, select a cell, type in the following formula, and hit ENTER.

=CHAR(9733)

  • As shown below the star symbol now gets inserted in the selected cell. 
Using CHAR function to insert star symbol in Google Sheets
Fig 1: Using CHAR function to insert star symbol

Method 2- Using the emoji keyboard

  • Select a cell. 
  • Pressing the Windows key and ‘.’ or Control + Command + Spacebar keys on Mac simultaneously, displays the emoji keyboard on your screen. 
Emoji keyboard is displayed on the screen
Fig 2: Emoji keyboard is displayed on the screen
  • In the search box, type in ‘star’ and click on the star emoji. The star symbol gets inserted into the selected cell. 
Inserting star symbol using the emoji keyboard in Google Sheets
Fig 3: Inserting star symbol using the emoji keyboard

Next, let’s learn how to create your own star rating system.

The REPT Function

The REPT function returns some specified text repeated a number of times. Since I will use the REPT function to create this star rating system in Google Sheets, first let’s have a look at the anatomy of this function.

The syntax of this function is as follows:-

=REPT(text_to_repeat, number_of_repititions)

  • text_to_repeat– the string or character you want to repeat.
  • number_of_repititions– the number of times you want that string or character to repeat. 

Example 1

Here I will insert the star symbol using the CHAR function.

  • In this example, I will create a star rating system to rate the following books. 
Table showing score ratings for different books
Fig 4: Books to be rated
  • Firstly select a cell and start typing ‘=’ followed by the name of the function ‘REPT’ in the cell. As you type, Google Sheets will automatically suggest the required function. Choose this function. 
Using REPT Function in Google Sheets
Fig 5: Using REPT Function
  • For the REPT function CHAR(9733) is the character that we want to repeat and the score value in column B refers to the number of repetitions, so we type in the following formula. 

=REPT(CHAR(9733), B2)

REPT Function formula in Google Sheets
Fig 6: REPT Function formula
  • The star rating for the corresponding score value is displayed. 
Star ratings displayed in the corresponding cell in Google Sheets
Fig 7: Star ratings displayed in the cell
  • After following all the above-mentioned steps, our spreadsheet looks like this. 
All corresponding Star ratings displayed in Google Sheets
Fig 8: All Star ratings displayed | Example – Star Rating System in Google Sheets

Example 2 

In this example we will use the emoji keyboard star symbol to create the rating system. 

  • Select a cell and start typing ‘=’ followed by the name of the function ‘REPT’ in the cell. As you type, Google Sheets will automatically suggest the required function. Choose this function. 
  • Now, press the Windows key and ‘.’ simultaneously. This opens the emoji keyboard. 
  • Type star in the search box of the keyboard, and select the star symbol. 
Inserting star symbol from the emoji keyboard in Google Sheets
Fig 9: Inserting star symbol from the emoji keyboard
  • Ensure you add opening and closing double quotation marks (“ “) around the star emoji to avoid getting an error. 
  • The star rating for the corresponding score value is displayed. 
Star ratings displayed in the corresponding cell in Google Sheets
Fig 10: Star ratings displayed in cell | Example – Star Rating System in Google Sheets
  • After following all the above-mentioned steps, our spreadsheet looks like this. 
Star ratings displayed in the corresponding cell in Google Sheets
Fig 11: All Star ratings displayed | Example – Star Rating System in Google Sheets

Why am I getting a #ERROR in REPT Function in Google Sheets?

A formula parsing error message is displayed when you don’t include opening and closing double quotation marks (“ “) around the star emoji.

#ERROR! message displayed while using REPT Function in Google Sheets
Fig 12: #ERROR! message displayed | Example – Star Rating System in Google Sheets

As already mentioned, to avoid getting this error make sure you add opening and closing double quotation marks around the star emoji. These quotation marks specify that the star emoji is a character. 

Conclusion

In this article, we learned two ways to create the Star Rating System in Google Sheets. For this, we also learned to use

Char FunctionREPT Function in Google Sheets.

Want to know more formulas and functions in Google Sheets? Look at our definitive guide on Google Sheets which covers hundreds of such topics. Enjoy reading!

See More

Arrayformula in Google Sheets – All you need to know about Arrayformula

How to Link Google Sheets to Excel – Automate updates from an Excel to Google Sheet

One response to “How to Add Star Rating System in Google Sheets – Track 5 ⭐️ customers easily”

Leave a Reply