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.

Here are 3 ways to export any listing's Google reviews to a nice, clean excel file.

I actually did not know about Google Takeout until I looked into this topic of exporting Google Reviews.

When I saw they did, I thought "Brilliant, surely this is how everyone does this".

Until I realised they only allow JSON exports, no CSV.

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.

It is still a valid option if you need to export more than 1000 reviews & have a lot of time on hand.

You might have seen online scrapers or free extensions that claim they can export google reviews to excel for free, or almost free.

Most of them kind of work. They're a little slow and clunky because they work by loading entire google pages on your browser, but they should get the job done.

They'll mostly work on limited amounts of reviews.

But here's the biggest problem with those scrapers.

They all need to use your Google credentials because Google does not show reviews otherwise.

This effectively means you need to be logged in to access the reviews, and you'd be infringing Google's TOS directly by scraping those reviews, which is against the law, and could get you in trouble with Google as well – which incidentally, can super easily identify you, because ... you're logged in!

It gets worse, you won't even get exact review dates for your reviews.

Google uses relative dates for reviews when showing reviews publicly. "3 days ago", "3 weeks ago", "3 months ago", etc.

And because these scrapers just scrape whatever Google is showing, they'll group all reviews for 2 years ago on a single date, 2 years ago exactly.

If you're exporting your google reviews for analysis, this makes those scrapers pretty much entirely useless.

The only way to get all of your google reviews legally, including exact dates – is through the Google My business API.

At Reviewflowz, you can access all your reviews, and export any subset of them to Excel at any point in time.

It's a subscription model, and you're probably tired of running I don't know how many subscriptions. Especially if you just need an export this one time.

Hear me out though.

You can try it first.

Sign up for a free trial and you'll be able to play around for 14 days for free. You'll get to test filters, reports, automations, etc.

Before you export, you'll be able to apply tags automatically to all past reviews, and to bulk assign reviews to team members by having AI look for their names & nicknames in your past reviews.

Exports are limited to samples of 20 rows during the trial, but you can upgrade at any time to get the data you need.

Plans start from $45 / month for one location, down to $20 / month / location from 3 locations, and $15 / month / location from 20 locations. Pricing is publicly available here and depends on the number of review profiles. You can move the slider to get an exact price point.

You can subscribe and cancel immediately if you're worried about forgetting. You'll still have access for the entire billing period (1 month).

Give the subscription a shot though, you'll be surprised at the number of things you can automate and professionalise, even with a Lite subscription.

Our exports include all available data points on Google Maps:

Here's a screenshot of an example export