Reviewlist

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.

Example: https://apps.apple.com/us/app/duolingo-language-lessons/id570060128, 570060128, com.duolingo.DuolingoMobile or just "Duolingo".
More countries Pro Each country store has its own reviews. With Pro, one run collects them from every store you choose. See Pro

Free: CSV

Pro: Excel workbook

With Pro, the Excel button downloads one .xlsx file with three sheets:

Formulas for the CSV

In the CSV, column E is Stars and column G is the review text.

WhatFormula
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.

More guides