How to download Google reviews data: the options
Teams that ask how to download Google reviews data usually want a spreadsheet of every review for every store, with rating, text, date and reply. Google offers several downloads, but only one of them is designed to return full review data for your own locations. This guide walks through each, using Google's own pages.
How to analyse reviews in a spreadsheet, and when to stop.
How to analyse reviews in a spreadsheet and when to stopOption 1: the Business Profile API
Google's Business Profile APIs let you list reviews for a location and batch-get reviews across several locations, with options such as page size, ordering and ignoring rating-only reviews. Review fields include the reviewer, star rating, comment, create time and the owner's reply. You need OAuth credentials and access to the locations.
Google's Business Profile review endpoints.
Work with review data, Google Business Profile APIs (Google for Developers)The Google Business Profile reviews API for multi-location brands.
The google business profile reviews api for multi location brandsOption 2: profile spreadsheet downloads
In Business Profile, select profiles, click Actions, then Businesses under Download, and choose whether to include Google updates and photos. Google's page describes profile fields, errors and Google updates; it does not say reviews are included. Use it for location data, not reviews.
Google on downloading profiles to a spreadsheet.
Download your Business Profiles to a spreadsheet (Google Business Profile Help)Option 3: performance downloads
From Business Profile Manager, Actions, then Insights, you can download performance reports for many profiles. They cover views, searches and interactions, not review text.
Google on downloading performance insights.
Understand your Business Profile performance & insights (Google Business Profile Help)Option 4: the Places API
The Places API returns at most 5 reviews per place, sorted by relevance, and Google's policies restrict caching or storing Places content. It is not a way to build a review dataset.
Google's Places API reference.
Places API (New) REST reference: places (Google for Developers)Google's Places API policies.
Policies and attributions for Places API (Google for Developers)Google Maps reviews and the Places API.
Google maps reviews and the places apiOption 5: Google Takeout
Takeout downloads data from Google products you use with your personal account. Google's Takeout help page does not mention Maps reviews or Business Profile data, so do not plan a business export around it.
Google Account Help on Takeout.
How to download your Google data (Google Account Help)Fields worth keeping
- Store code and location name.
- Review ID, so you can update rather than duplicate.
- Star rating.
- Review text and language.
- Create date and any update date.
- Owner reply text and date.
Free review snapshot
Want this done for your own reviews?
No commitment. We use your details only to send your snapshot and follow up. Privacy policy
Keep it current
Reviews are edited, deleted and added daily. Google says an edited review shows its edit date as the post date, and removed reviews are not reinstated. A one-off export goes stale quickly, so plan regular refreshes keyed on review ID.
Google on edits and removals.
Add, edit, or delete Google Maps reviews & ratings (Google Maps Help)Handle personal data carefully
Reviews contain reviewer names and sometimes personal details. Restrict access to exports, avoid emailing spreadsheets around, and remove data you no longer need.
What to do with the data
A spreadsheet of thousands of reviews is hard to read. Decide in advance what you want: topics by store, trends by month, complaint patterns, reply times. That decides whether a spreadsheet is enough or you need classification.
Sentiment analysis of Google reviews.
Sentiment analysis of google reviewsCommon mistakes
- Expecting reviews in the profile spreadsheet.
- Building a dataset from the Places API.
- One-off exports that go stale.
- No review ID, so updates duplicate rows.
- Sharing exports with reviewer names widely.
Common questions
Can I download all reviews for my stores?
Yes, through the Business Profile APIs for locations you manage.
Is there a download button for reviews in Business Profile?
Google's download pages we reviewed cover profile data and insights, not reviews.
Can I download a competitor's reviews?
Not through the Business Profile API; the Places API returns only 5 and restricts storage.
How often should I refresh?
As often as you act on the data; weekly or monthly suits most teams.
Checklist
- Purpose decided.
- Business Profile API access set up.
- Review ID and store code kept.
- Refresh scheduled.
- Access to exports restricted.
In short
To download Google reviews for your own stores, use the Business Profile APIs; Business Profile spreadsheet downloads cover profile data and insights, the Places API gives only 5 reviews, and Takeout is for personal data. Keep exports current and secure.
Doing this with Falcon
Falcon brings in the Google Maps reviews of your locations and classifies each one into themes, sub-themes and specific issues from your own taxonomy, with sentiment per mention and the exact supporting quote, filterable by location, period and source. Ask us how review data is connected for your locations.