Showing results for 
Search instead for 
Did you mean: 
Regular Visitor

Stars rating - convert stars to number

For several days now, I have been grappling with the challenge of getting the number of stars rating from for each customer rating ... I've tried everything and haven't been able to do it so far




I have no idea how to get number of "yellow" stars to put it into my Excel file as a number

Using simple "Extract from web into Excel" function I have got only [][][][][] (5 double brackets or some strange signs ) no matter how many stars are yellow... they are still the same

I will be very grateful for any suggestions

New Member



I have this problem now, you found the solution?

New Member

hello, i met the problem as well, any solution?

Super User
Super User

Can you upload the HTML code of the exact page? Hard to help from a single image, and URL does not lead anywhere meaningful.

Helpful resources

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Top Solution Authors
Top Kudoed Authors
Users online (2,037)