Analyze Google reviews in ExcelTurn star ratings into sales signals
A spreadsheet full of review text is a goldmine of pain points and buying signals. Here is how to scrape the reviews, score them in Excel, and act on them.
Reviews··7 min read
Key takeaways
Get reviews into rows first: a free Chrome extension captures a business's Google reviews into a clean file, so Excel is your analysis layer, not a data-entry chore
Excel handles practical sentiment: keyword lists plus COUNTIF and SEARCH flag pain points and positives across hundreds of reviews in minutes
The payoff is not a chart. It is a list of buying signals: recurring complaints you can sell against, business by business
Why reviews, why Excel
Reviews are unstructured sales data
Star ratings tell you almost nothing. A 4.2 average hides the two complaints that show up in every third review. The value is in the text, and the text is unstructured, which is exactly what a spreadsheet is good at taming once each review sits on its own row.
Reviews also matter to the businesses you want to sell to. According to the BrightLocal Local Consumer Review Survey, the vast majority of consumers read reviews before choosing a local business. That means a recurring complaint is not just feedback, it is lost revenue the owner already feels. If your product fixes that complaint, the review is your opening line.
The workflow has two halves. First you capture the reviews (the mechanical part). Then you analyze them in Excel to find patterns (the valuable part). The extension is the means; the insight is the end.
Capture the reviews first
Scrape any Google Maps business's reviews into a clean file, then open it in Excel. Free download. No trial, no credit card.
Copying reviews by hand does not scale. Google shows them a few at a time, sorts them oddly, and there is no export button, as its own Business Profile reviews documentation makes clear. Doing 300 reviews manually is an afternoon lost.
Instead, open the business on Google Maps and let the Vonsel Chrome extension capture the reviews for you. Each review comes out as a structured row: reviewer, star rating, date, and the full review text, plus the owner reply when there is one. You can add reviews to a business you already captured, so a lead list and its reviews stay together. For the deeper mechanics, see how to scrape Google reviews and adding reviews to captured businesses.
Export the result as CSV or XLSX and open it in Excel. If you want the exact export steps, our guide on exporting Google reviews to Excel walks through it. Now you have a real dataset instead of a screenshot.
1
row per review, ready to filter and score in Excel
3
columns that do the work: rating, date, and full text
0
copy-and-paste, no API key, no code required
Step 2
Score sentiment with plain Excel formulas
You do not need a machine-learning add-in to find patterns. Build two small keyword lists, one for complaints and one for praise, then flag every review that mentions them. It is transparent, it is fast, and you can read exactly why a review was tagged.
Put the review text in column A. In a helper column, count how many negative keywords appear using a combination of COUNTIF and SEARCH against your keyword list. A review with two or more complaint words is a strong negative. Do the same for positives. Subtract one from the other and you have a simple sentiment score per review.
Then add theme columns. One column asks "does this review mention the website or booking online?" One asks "does it mention wait time or slow service?" One asks "does it mention price or being overcharged?" SEARCH returns a position when the word is found, so wrap it in ISNUMBER to get a clean TRUE or FALSE. Now every review is tagged by theme, not just polarity.
Finish with a PivotTable that counts negative reviews per theme. In two clicks you can see that eleven of forty complaints are about the online booking flow. That is the pattern you came for.
Step 3
Turn themes into buying signals
A sentiment score is interesting. A clustered complaint is actionable. When the same theme shows up again and again at one business, that is a documented, dated problem the owner is living with. Match it to what you sell and you have an outreach angle nobody can argue with.
Owner replies are a hidden column. A business that answers negative reviews cares about its reputation and has budget to fix things. A business that ignores a wall of complaints is either overwhelmed or checked out. Both are useful to know before you write the first line.
Skip the copy and paste
Let the extension pull every review into a file, then spend your time on the analysis, not data entry. Free to download, no trial and no credit card needed.
SEARCH does not understand sarcasm or context. "Not slow at all" gets tagged as a wait-time complaint unless you handle negations. Fine for triage, weak for precision.
It does not scale to a whole list
Analyzing one business in Excel is quick. Doing it for 300 businesses in a territory means 300 spreadsheets and 300 manual reads. That is where it breaks.
The insight lives away from the lead
Your findings sit in a file while the contact details sit somewhere else. When you finally email, you have to stitch the pain point back to the business by hand.
It teaches you the pattern
Doing it once by hand is worth it. You learn which themes matter and what customers actually say, so the automated version later means something.
The end state
From spreadsheet to a mapped CRM that does the reading
Excel is the training wheels. Once you know the patterns you want, the Vonsel dashboard runs the same logic across an entire list. Attach reviews to every business in a territory, and Reviews Intelligence clusters the complaints, surfaces buying signals, and scores each lead without a single formula.
Because the reviews live next to the lead in a mapped CRM, the pain point travels with the contact. Email Intelligence can then draft an AI email per business that opens with the exact complaint you found, so outreach is personalized at the level of a single dentist or plumber, not a generic template. Comparing a whole market instead of one shop? See scraping competitor reviews.
The spreadsheet proves the concept on one business. The dashboard turns it into a repeatable pipeline. Reviews go from data you export to context you sell with.
A star rating is a summary. A complaint you can name is a sale
Start reading reviews the smart way
Capture Google reviews, analyze them in Excel or let Reviews Intelligence do it for you, and reach out with the exact pain point. No trial, no credit card, free to download. Explore features or browse the Reviews blog.
Capture the reviews first, then export them. The free Vonsel Chrome extension scrapes reviews from a Google Maps business into a structured file, so each review becomes a row in Excel with the rating, date, and text ready to analyze. No copy and paste and no API key.
Can Excel do sentiment analysis on reviews?
Excel can do a practical version of it. You build keyword lists for pain points and positives, count matches with COUNTIF and SEARCH, and score each review. It is not a language model, but for spotting recurring complaints across hundreds of reviews it is fast and transparent.
How do I turn review complaints into sales opportunities?
Group complaints by theme, such as slow response, pricing confusion, or an outdated website. A cluster of the same complaint at a business is a buying signal for whatever you sell that fixes it. Vonsel Reviews Intelligence does this clustering automatically once reviews are attached to a lead.
Add Chrome Extension