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.

Spreadsheet

How to analyse reviews in a spreadsheet, and when to stop.

How to analyse reviews in a spreadsheet and when to stop

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

API guide

The Google Business Profile reviews API for multi-location brands.

The google business profile reviews api for multi location brands

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

Source

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.

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.

Places API

Google Maps reviews and the Places API.

Google maps reviews and the places api

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

Source

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.

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.

Analysis

Sentiment analysis of Google reviews.

Sentiment analysis of google reviews

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