How to Export Google Reviews & Review Data

Use this guide to export Google reviews and review data from any Google Business Profile.

⚡ Updated

Phantom makes it possible to easily download exported Google review data from any Google Business Profile including star rating, total review count, review content, review date, and author info.

Follow these steps to export Google reviews and review data:

  1. Find a business profile in Google Search or Maps
  2. Click the export data button
  3. Use the Export buttons to download Google review data
  4. Import the data to Google Sheets or Excel

Note: Phantom must be installed in order to access the export feature for Google My Business. You can install for free on the Chrome Webstore.

Once Phantom has been installed, it will be enabled by default for Google Chrome, allowing you to analyze and export Google review data using Phantom’s Review audit button, which will automatically display in Google Search & Maps on Google Business Profiles.

Find a business profile in Google Search or Maps

Search for the name of your business (or a competitor) in Google Search or Maps. I recommend using the the following branded search + locality format to ensure the results you want: business name + locality

For example, Miami Yacht Charters & Rentals OR Miami Yacht Charters & Rentals Miami (which is a little redundant in this example).

Click the Review audit button

Once you’ve found the business profile that you want to analyze in Google Search or Maps, click the Review audit button.

The review audit button

Use the Export buttons to download Google review data

Once the review audit has finished, you’ll have the option use the Export Data and the Export Reviews buttons.

Export Google review data from Phantom's graph

📈 Export Data: This button will export data associated with the graph, which tends to be more helpful for auditing your Google Business profile to understand how your review data stacks up against the competition.

Note: The data associated with the graph (which also appears below it) can be used to perform a Google review audit, which is a significant part of the Google Business Profile audit process for Local SEO.

Export Google review data for each individual Google review

Export Reviews: Alternatively, this button will export each individual Google review, along with data associated with each Google review.

Specifics about what is included in each export is detailed below…

Types of Google review data that can be exported

About the Export Data button

The Export Data button can be used to export data associated with the graph

Export Google review data from Phantom's graph
Graphed Google review data

The following review data can be exported using the 📈Export Data button…

Business nameThe name of the business from which the reviews were exported
Total number of reviewsThe total number of Google reviews associated with the business
Date of most recent reviewThe date (YYYY-MM-DD) of the most recent Google review
Review frequencyA calculation of review velocity (average daily reviews in last 90 days)
Average star ratingThe average star rating of Google reviews on the business profile
Average words per reviewThe average word count of all Google reviews
Average characters per reviewThe average character count of all Google reviews
Average number of reviews given by authorsThe average number of Google reviews given by all users (authors) who left a Google Review
Total number of reviews by Local GuidesThe total number of reviews that were left by users (authors) who have a Local Guide status on their Google account
Total number of reviews with photosThe total number of Google reviews that include at least 1 photo
Total number of reviews with videoThe total number of Google reviews that include at least 1 video

Note: You can easily export other types of data using Phantom’s Export button found in Google Search & Maps.

About the Export Reviews button

Phantom also makes it possible to export data about each individual Google review by using the ⭐Export Reviews button…

Export Google review data for each individual Google review
Export itemDescription
Review dateThe date that the reviewer left the Google review
Review URLThe link to the review
Author nameThe name of the author who left the review
Author URLA link to the author’s profile, which shows all of their reviews
Local GuideA true of false statement for whether the reviewer is a Local Guide
Author reviewsThe total number of reviews that the review author has posted
Star rating The star rating of the review
Review contentThe main content / text of the review (blank if only star rating)
Review imageA link to the image uploaded with the review (if applicable)
Review videoA link to the video uploaded with the review (if applicable)

Import the review data to Google Sheets or Excel

How to export Google reviews

To import the review data to Google Sheets follows these steps:

  1. Navigate to File
  2. Click the Import option from the dropdown
  3. Be sure that Cell A1 is selected, and use the Import data to selected cell option
  4. Select the CSV file containing the Google review data

Frequently asked questions

Can I export my Google business reviews?

Yes, you can export your Google business reviews using the Phantom – GMB Audit Tool. Install Phantom on the Chrome Webstore, and get your first export for free.

Where can I download Google review data?

Google review data can be downloaded from Google Search & Maps using the Phantom – GMB Audit Tool, a browser extension for Google Chrome.

What other Google review data can I export?

Currently, Phantom supports only the export items contained in the tables above. To request additional export items of features, please reach out and let us know what you would like to see (we’ll likely get it added ASAP!).

How should I analyze the exported Google review data?

You can access the Google Business Profile audit template & SEO Checklist to automate most of the analysis.

Install Phantom for Google Chrome

Audit any Google Business Profile & get better competitor insights.


Install for free on the Chrome Web Store