Review CSV Analyzer: Rating Distribution, Themes & Sentiment — What Each Layer Tells You
A review CSV answers three different questions, and they need three different depths of analysis: what's the rating picture (free, instant), what are the themes (free, one click), and how does sentiment break down per theme (the full-report layer). This page maps all three — and unlike analyzers locked to one marketplace's product URL, everything here works on any CSV you already have: Amazon, Shopify, Judge.me, Google Play, App Store.
Layer one and two, right now
Analyze your review CSV — free, in your browser
Upload any review CSV and instantly see review count, average rating, star distribution, monthly movement, and top keywords. Computed locally — your file never leaves your device.
Free · No credit card required
Open the Review CSV Analyzer →The three layers of review analysis
| Layer | What it answers | Where to get it |
|---|---|---|
| Rating distribution | Is feedback healthy? Is it sliding? A 4.2 average with a growing 1★ share is a warning the average alone hides. | Free analyzer — instant, whole file, local |
| Themes | What do customers actually talk about? Top keywords and recurring phrases — sizing, packaging, battery — with counts. | Free analyzer keywords, sharpened by the full report's clusters |
| Sentiment | Is each theme loved or hated? Positive/negative split per theme, with example quotes as proof. | Full AI report from the same CSV (free during beta) |
The honest framing: the free analyzer is a statistics overview, not a root-cause analysis. It tells you where to look — the month the 2★ share jumped, the keyword that suddenly appears. The full report tells you why, with sentiment per theme and the exact reviews that prove each finding. Skipping straight to layer three is possible; starting at layer one costs you nothing.
Any CSV source — no marketplace lock-in
Many review analyzers only work when you hand them a single marketplace's product URL. That breaks the moment your reviews live somewhere else — and multi-channel sellers always live somewhere else. The KnowVault analyzer takes the file itself:
- Amazon — reviews you exported yourself (see the export guide).
- Shopify / Judge.me — the standard reviews CSV from the Judge.me export.
- Google Play & App Store — CSVs saved from Console reports or the free App Review Exporter.
- Surveys & feedback exports — anything with a rating, a date, and text columns.
If the columns are named differently across sources, the analyzer's column mapping handles the common layouts — and the same file flows into every other tool on the site, so one export feeds distribution, themes, sentiment, and the summarizer.
The workflow: free stats first, full report when it pays
Upload the CSV to the free analyzer
Thirty seconds later you have the shape of the data: stars, months, keywords. Most questions end here — “did the relaunch fix the complaint spike?” is visible in the monthly trend alone.
Promote the same CSV for the full report
When the stats surface something worth acting on — a theme growing, a star sliding — upload for the AI report: sentiment breakdown per theme, root causes, prioritized recommendations, every claim citing the reviews that prove it.
Act, then re-run monthly
The pair works as a habit: the free layer is your monthly smoke test, the report layer is the deep dive when the smoke test finds fire. Re-running takes minutes because the file format never changes.
From overview to root cause
Want the full evidence-cited report? Free during beta
Sentiment split per theme, root-cause ranking, and example quotes for every finding — the analyzer's statistics, promoted into a decision document.
Free during beta · No credit card required
See what's in the report →Frequently Asked Questions
What does the free Review CSV Analyzer show?
A statistics overview of the whole file: review count, average rating, star distribution, monthly movement, and top keywords — computed locally in your browser the moment you upload. It is deliberately not a root-cause analysis; for sentiment breakdown and prioritized recommendations you promote the same CSV into a full report.
How do I get sentiment analysis from a review CSV?
Three layers exist. Rating distribution is the free instant layer — a rising 1–2★ share is sentiment moving before your average shows it. Keyword clusters approximate themes for free. True sentiment breakdown — positive/negative split per theme, with quotes as proof — comes from the full AI report you can generate from the same file.
Which CSV sources does the analyzer accept?
Any review export with the basics: a rating, a date, and review text. That covers Amazon exports, Shopify apps like Judge.me, Google Play and App Store reviews saved as CSV, and survey exports. There is no marketplace lock-in and no product URL required — you bring the file you already have.
Is my review data uploaded when I analyze it?
Not for the free analyzer: parsing, counting, and trending all run client-side in your browser, so the file never leaves your device. An upload only happens if you choose to create a full AI report — and that report is yours.