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

Popular: ChatGPT · Duolingo · Spotify · Instagram · TikTok · Uber · all apps

Free or Pro

Free: one app, one country, up to 500 reviews, CSV and JSON. Pro: all 183 countries in one run, both review lists (up to 1,000 per country), compare up to 5 apps, star, version and date filters, Excel export and a shareable HTML report (sample). $9 a month or $49 a year, 14-day refund.

See Pro No card, no account.

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.

Real examples from our reports

Every number in our category reports can be rebuilt from the same export in a spreadsheet: a pivot of star rating by version, and a count of reviews containing a word. For example, Sainsbury's "SmartShop" is in 106 of its 337 bad UK reviews (UK supermarkets), and Anova Culinary's "subscription" in 163 of 371 (smart kitchen apps).

Need more than one country or app?

Reviewlist Pro loads all 183 countries in one run, both review lists (up to 1,000 per country), up to 5 apps side by side, and exports to Excel or a ready-to-send HTML report. $9 a month or $49 a year, cancel any time, 3-day free trial in the browser.

See what Pro adds

More guides

More reports