Reviewlist › Guides
App Store reviews in Excel and Google Sheets
Load an app's reviews above and open them in a spreadsheet: a free CSV that Excel, Numbers and Google Sheets read as is, or a ready Excel workbook with Pro.
| Date | Stars | Review | Version |
|---|
Free: CSV
- Excel and Numbers: double-click the downloaded file. It is UTF-8 with a byte order mark, so non-English text and emoji show correctly without the import wizard.
- Google Sheets: File → Import → Upload, then choose the CSV.
- Text that starts with =, +, - or @ is escaped, so no review can run as a formula.
Pro: Excel workbook
With Pro, the Excel button downloads one .xlsx file with three sheets:
- Reviews: every loaded review with all columns, header row in bold.
- Summary: one row per app and country with the store rating, number of ratings, current version, reviews loaded, their average, the share of 1–2 star reviews and the count for each star.
- Versions: each app version with its number of reviews, average and latest review date.
Formulas for the CSV
In the CSV, column E is Stars and column G is the review text.
| What | Formula |
|---|---|
| Average stars | =AVERAGE(E:E) |
| Number of 1-star reviews | =COUNTIF(E:E, 1) |
| Share of 1–2 star reviews | =COUNTIF(E:E, "<=2") / COUNT(E:E) |
| Reviews that mention "crash" | =COUNTIF(G:G, "*crash*") |
| Translate a review (Google Sheets) | =GOOGLETRANSLATE(G2, "auto", "en") |
For a view by release, insert a pivot table with Version in rows and the average of Stars in values. With several countries, put Country in columns.
Questions
Can the sheet update by itself?
Not from the website: download a fresh file when you need it. For a schedule, the App Store Reviews Scraper on Apify delivers the same data through an API and its integrations.
Why are dates in UTC?
Reviews come from stores in many time zones. UTC keeps them in one order. In a spreadsheet, add or subtract hours to show your local time.