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.
Popular: ChatGPT · Duolingo · Spotify · Instagram · TikTok · Uber · all apps
| Date | Stars | Review | Version |
|---|
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.
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.
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.
More guides
- Download App Store reviews
- App Store reviews by country
- App Store reviews by star rating
- App Store reviews by app version
- Compare reviews of competing apps
- Analyze App Store reviews: bugs, requests, prices
- App Store reviews RSS feed and API for developers
- Find ASO keywords and competitor gaps in reviews
- App Store reviews as JSON, and analysis with a chatbot
- A free alternative to AppFollow for review exports
- A free alternative to Appbot for review exports
- Check App Store keyword rankings for free
- App Store keyword rankings by country
- Monitor new App Store reviews (Slack, email, Sheets)
- Export reviews from App Store Connect to CSV
- Mac App Store reviews to CSV or Excel
- One update can cost a star: 31 real examples
- Which country writes the angriest App Store reviews?
- App Store review reports by category
- Find app ideas in 1-star reviews
- How to reply to App Store reviews
- Deutsch: App-Store-Bewertungen exportieren
- Español: exportar reseñas de la App Store
- Français : exporter les avis de l'App Store
More reports
- Report: 2,500 reviews of food delivery apps
- Report: 2,500 reviews of dating apps
- Report: 2,500 reviews of shopping apps
- Report: 2,500 reviews of travel and ride apps
- Report: 2,500 reviews of streaming apps
- Report: 3,000 reviews of short drama apps
- Report: 3,000 reviews of cash back apps
- Report: 3,000 reviews of budgeting apps
- All 163 App Store review reports