How to export Google reviews to Excel?
Whether you're performing an audit for a client, or just want to get a clear picture of what's being said about your business, exporting your google reviews is as easy as it sounds, even though Google doesn't exactly make it easy.
The easiest way is to use Reviewflowz's review exports at $0.01 per review.
Exports are almost instant, with an unlimited number of reviews.
The cheapest way is to use an SEO chrome extension called PhantomLocal. We've tested it. It's free and it works fine, although you're limited to 1000 reviews per listing, and it takes a while to scrape all reviews. And it does so on your browser, so you can't really do anything else while it's scraping, at the risk of having to restart.
The easiest way to get a review export is to use our very own pay as you go review exports.
We charge $0.01 to make it a no brainer for anyone looking for a serious solution. You can download a sample of 25 rows for any google maps listing to double check before making your purchase.
Access review exports and download Google reviews in minutes
The exports include all available data points on Google Maps:
The Google My Business listing name
The review ID (Google's)
The review content
The review score (between 1 & 5)
The review link
The date the review was published
The reviewer's name (when available)
Here's a screenshot of an example export
Access review exports and download Google reviews in minutes
Phantom is a google chrome extension that Dalton Luka built to help SEOs with Google My Business audits.
It does provide a download reviews functionality, which will pull the last 1000 reviews and download them to a CSV file.
You can then import this file into a spreadsheet or excel file to work on the reviews directly.
The biggest upside is that this is entirely free.
The downside is that it's entirely free.
Because it's free, it needs to run on your browser to avoid server costs, which makes it a bit of a slog, loading 15 reviews at a time, with images etc, Also, because it runs on your laptop, you'll need to basically watch it scrape reviews while you can't do much of anything else if you don't want to break the scraping process.
Long story short, if you're looking for a one time export of a few reviews, and you're willing to spend 10 - 15mn installing the extension etc. to save a couple of bucks, this is a life saver. If you're looking for a quick & cheap option, I still think (although we're biased obviously) our Pay As You Go exports are a lot simpler & faster.
I actually did not know about Google Takeout until I looked into this topic of exporting Google Reviews.
Takeout basically offers an interface from which you can download all (and I mean _all_) the data Google has on you.
This includes your Google My Business data, including your businesses' reviews.
Obviously, this won't let you download reviews for GMB accounts you do not own (such as competitors, or clients if they didn't share access, etc). so it's of limited value to be honest.
Also, I was baffled to realise they only allow JSON exports, no CSV.
JSON is a computer-language friendly data storage format, but it is an absolute nightmare to transform into a table friendly format like CSV because of its nested structure.
For that reason, unless you have a readily available Google review json parser, I would definitely not recommend this approach.
It is still a valid option if you need to export more than 1000 reviews, have a lot of time on hand, and cannot spend more than $0.01 per review, which is why we included it.
The easiest way is to use Reviewflowz's review exports at $0.01 per review.
Exports are almost instant, with an unlimited number of reviews.
The cheapest way is to use an SEO chrome extension called PhantomLocal. We've tested it. It's free and it works fine, although you're limited to 1000 reviews per listing, and it takes a while to scrape all reviews. And it does so on your browser, so you can't really do anything else while it's scraping, at the risk of having to restart.
1 Review exports by reviewflowz
The easiest way to get a review export is to use our very own pay as you go review exports.
We charge $0.01 to make it a no brainer for anyone looking for a serious solution. You can download a sample of 25 rows for any google maps listing to double check before making your purchase.
Access review exports and download Google reviews in minutes
The exports include all available data points on Google Maps:
The Google My Business listing name
The review ID (Google's)
The review content
The review score (between 1 & 5)
The review link
The date the review was published
The reviewer's name (when available)
Here's a screenshot of an example export
Access review exports and download Google reviews in minutes
2 Download reviews using PhantomLocal's chrome extension
Phantom is a google chrome extension that Dalton Luka built to help SEOs with Google My Business audits.
It does provide a download reviews functionality, which will pull the last 1000 reviews and download them to a CSV file.
You can then import this file into a spreadsheet or excel file to work on the reviews directly.
The biggest upside is that this is entirely free.
The downside is that it's entirely free.
Because it's free, it needs to run on your browser to avoid server costs, which makes it a bit of a slog, loading 15 reviews at a time, with images etc, Also, because it runs on your laptop, you'll need to basically watch it scrape reviews while you can't do much of anything else if you don't want to break the scraping process.
Long story short, if you're looking for a one time export of a few reviews, and you're willing to spend 10 - 15mn installing the extension etc. to save a couple of bucks, this is a life saver. If you're looking for a quick & cheap option, I still think (although we're biased obviously) our Pay As You Go exports are a lot simpler & faster.
3 Download reviews using Google Takeout
I actually did not know about Google Takeout until I looked into this topic of exporting Google Reviews.
Takeout basically offers an interface from which you can download all (and I mean _all_) the data Google has on you.
This includes your Google My Business data, including your businesses' reviews.
Obviously, this won't let you download reviews for GMB accounts you do not own (such as competitors, or clients if they didn't share access, etc). so it's of limited value to be honest.
Also, I was baffled to realise they only allow JSON exports, no CSV.
JSON is a computer-language friendly data storage format, but it is an absolute nightmare to transform into a table friendly format like CSV because of its nested structure.
For that reason, unless you have a readily available Google review json parser, I would definitely not recommend this approach.
It is still a valid option if you need to export more than 1000 reviews, have a lot of time on hand, and cannot spend more than $0.01 per review, which is why we included it.
Updated on: 14/10/2024
Thank you!