Export Google reviews and download review data to Excel/Sheets from any Google Business Profile.
⚡ UpdatedThat Phantom browser extension for Google Chrome makes it possible to easily export reviews to Excel / Google Sheets and download Google review data from any Google Business Profile including star rating, total review count, review content, review date, and author info. Just run the audit and click the the export button to download the data to Excel or Google Sheets.
Follow these steps to export and download Google review data:
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.
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).
Once you’ve found the business profile that you want to analyze in Google Search or Maps, click the Review audit button.
Once the review audit has finished, you’ll have the option use the Export Data and the Export Reviews buttons.
📈 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 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…
The Export Data button can be used to export data associated with the graph
The following review data can be exported using the 📈Export Data button…
| Business name | The name of the business from which the reviews were exported |
| Total number of reviews | The total number of Google reviews associated with the business |
| Date of most recent review | The date (YYYY-MM-DD) of the most recent Google review |
| Review frequency | A calculation of review velocity (average daily reviews in last 90 days) |
| Average star rating | The average star rating of Google reviews on the business profile |
| Average words per review | The average word count of all Google reviews |
| Average characters per review | The average character count of all Google reviews |
| Average number of reviews given by authors | The average number of Google reviews given by all users (authors) who left a Google Review |
| Total number of reviews by Local Guides | The 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 photos | The total number of Google reviews that include at least 1 photo |
| Total number of reviews with video | The 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.
Phantom also makes it possible to export data about each individual Google review by using the ⭐Export Reviews button…
| Export item | Description |
| Review date | The date that the reviewer left the Google review |
| Review URL | The link to the review |
| Author name | The name of the author who left the review |
| Author URL | A link to the author’s profile, which shows all of their reviews |
| Local Guide | A true of false statement for whether the reviewer is a Local Guide |
| Author reviews | The total number of reviews that the review author has posted |
| Star rating | The star rating of the review |
| Review content | The main content / text of the review (blank if only star rating) |
| Review image | A link to the image uploaded with the review (if applicable) |
| Review video | A link to the video uploaded with the review (if applicable) |
To import the review data to Google Sheets follows these steps:
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.
Google review data can be downloaded from Google Search & Maps using the Phantom – GMB Audit Tool, a browser extension for Google Chrome.
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!).
You can access the Google Business Profile audit template & SEO Checklist to automate most of the analysis.
There are many local ranking factors, however, Google tends to show businesses with the highest star rating and total review count. For most keywords and SERPs, you’ll generally want at least a 4.6-4.8 star rating. If you have less, you can use this calculator to find out how many more Google reviews you’ll need to improve your star rating.
You can start by reporting the review through Google’s review management dashboard. If that doesn’t work, which it unfortunately often doesn’t, you can try using Unreview’s removal service, which has a much higher success rate.
Audit any Google Business Profile & get better competitor insights.