Analyze thousands of customer reviews in Excel, with themes you can count
A pivot table can count star ratings, but not what people complain about. Upload the reviews as .xlsx or CSV and get two new columns, Sentiment and Themes, for every review, plus a summary that counts how many reviews mention each theme. The theme list is built from your own reviews first, so the counts are counts, not impressions. The first reviews are free; up to 20,000 reviews are $5.
- Sentiment and Themes columns added after your last column
- A theme list of at most 14 themes plus "Other", built from up to 150 reviews spread across the file
- Each review gets one to three themes from that list
- A summary CSV with counts, shares, sentiment split and two example reviews per theme
- Up to 20,000 reviews for $5, paid once
How to analyze reviews in a spreadsheet
-
1
Export one review per row
Use the CSV or Excel export from your store, app store or review platform. Ratings, dates and titles can stay; they help and come back unchanged.
-
2
Check the themes
The theme list and the first coded reviews appear on screen, free. If a theme you track is missing, type your own list and start again.
-
3
Pivot the result
Unlock for $5, download the file, and pivot Themes against your own columns, such as product or month.
Why the counts add up
The tool first reads a sample of up to 150 reviews taken evenly from the whole file and builds one theme list, each theme with a one-sentence description. Every review is then coded against that same list, 40 reviews at a time, and each answer is checked against it. The summary counts those codes, so "Late delivery: 412 reviews" means 412 rows carry that theme in your file.
A review can carry up to three themes, so the shares can add up to more than 100%. Reviews that fit no theme are coded "Other", which keeps them in the totals.
Working with the result in Excel
- Filter Sentiment = negative and Themes contains "Delivery" to read only the complaints that matter for shipping
- Use a pivot table with your product column to see which items draw which complaints
- Keep the theme list and reuse it next quarter, so the numbers compare
- Quote the example reviews from the summary in a report, after checking them
How the tool works, what it costs and how your files are handled is on the Analyze Customer Reviews page; prices for every tool are on the pricing page.
Last updated
Questions and answers
Can ChatGPT analyze 5,000 reviews from my Excel file?
It can summarize what it reads, but 5,000 reviews are more than it codes one by one in a conversation, so its counts are estimates. This tool codes every review against one theme list and counts the result.
Do I have to clean the file first?
No. One review per row is enough. Columns such as rating and title are read too, which helps; IDs, links and images are skipped.
Can I use my own themes?
Yes. Type them one per line before you upload; only your themes and "Other" are used.
How many reviews fit in one payment?
Up to 20,000 reviews for $5. Unlimited, $19 a week, covers files of up to 100,000 reviews.
Is it free?
Files of up to 100 reviews are free in full. For bigger files, the themes and the first reviews are free on screen.