How to Export Google Reviews to CSV, Excel or JSON

There is no download button. Google Business Profile has no "export reviews" control anywhere in its dashboard, which is why this question keeps getting asked. There are four real routes out: the Business Profile API, a Google Takeout archive, a review platform that exports CSV, or copying them by hand. Only the first gives you every review with its reply, in a structure you can work with. Here is what each route actually produces, and the mistake that wastes an afternoon.

The four routes, compared

Pick by what you need the file for. An accountant-style one-off record is a different job from a monthly reporting feed, and the routes are not interchangeable.

The mistake that wastes an afternoon

Google Takeout lists two different things that sound identical. Maps (your reviews) exports the reviews you wrote about other businesses. Google Business Profile exports data tied to the business you manage. People pick the first one, wait for the archive, open it and find restaurant reviews they left in 2019 rather than the 300 reviews their customers left them.

If you go the Takeout route, select Google Business Profile specifically, and be prepared to check what the archive actually contains before building anything on it. Reports differ on how completely customer review content comes through, and it arrives as raw JSON rather than a tidy spreadsheet either way. Treat Takeout as a backup of your account, not as a reporting pipeline.

Route 1: the Business Profile API, the only complete official route

For a location you own and have verified, accounts.locations.reviews.list returns all reviews for that location, and accounts.locations.batchGetReviews returns reviews across several locations in one request. Both include the reply you published, which no other route reliably gives you. That is the export most people are actually describing when they ask this question.

The obstacle is access, not code. Google gates the Business Profile APIs behind a manual application, and the published prerequisites include a Google Cloud project, an organization account, a website for the business, and a profile that has been verified and active for at least 60 days. There is a useful trick while you wait: open the API's quota page in Google Cloud Console. A quota of 0 queries per minute means you are not approved yet, and 300 queries per minute means you are. The full breakdown of both Google review APIs, including the five review ceiling on the Places API, is worth reading before you commit a sprint to this.

One thing the API will not do is get you a competitor's reviews. The Places API returns a maximum of five reviews for a business you do not own, and scraping the rest out of Maps breaks the Maps Platform terms. If a tool advertises unlimited review exports for any business on Maps, that is where the data is coming from.

Route 2: a review platform that exports CSV

This is the route most teams end up on, because it skips the approval queue entirely and covers more than Google. A platform connects your profile once, keeps the reviews synced, and exports a CSV you can open immediately. If you collect reviews on G2, Trustpilot or your own site as well, they come out in the same file with a source column, which is the part that makes analysis possible. That consolidation step is what a reviews aggregator is for.

On ReviewJet, CSV import and export plus API access are included on the Pro plan, and pricing is flat per account rather than per location. The practical argument for this route is not the export itself, it is that you stop maintaining an integration whose credentials expire and whose schema changes without warning.

What is actually in the file

Worth setting expectations before you plan the analysis. A Google review export gives you the rating, the review text, the author's display name, the publish timestamp and your reply. It does not give you an email address, an order ID, a customer record or a location the reviewer visited from. There is no key to join reviews to your CRM, and no export route creates one.

That constrains what the file is good for. Rating distribution over time, response rate, response latency, and text analysis of what people complain about: all fine. Attributing revenue to reviewers, or matching a bad review to the specific order that caused it: not possible from the export alone. Teams who need that have to capture the link at request time, by sending the review invitation themselves rather than reconstructing it afterwards.

Getting it somewhere more useful than a spreadsheet

A CSV is fine for a quarterly look. It stops being fine the moment someone wants review data on a dashboard next to support tickets and churn, because now a human is re-exporting a file every Monday.

At that point the job changes shape. You are no longer exporting reviews, you are maintaining a small data pipeline, and it belongs with whatever already connects your apps, APIs and databases rather than living as a folder of dated CSVs on someone's desktop. The review source becomes one input among several. Most businesses reach this point later than they expect, and the tell is when the same person exports the same file on a schedule.

Frequently asked questions

Can I export Google reviews to Excel?

Yes, but not directly from Google. Every official route produces JSON, either from the Business Profile API or a Takeout archive, so something has to convert it to a spreadsheet. Review platforms export CSV, which Excel opens natively. There is no path where Google hands you an .xlsx file.

Is there a free way to export Google reviews?

Google Takeout is free and official, and the Business Profile API has no per-call charge once you are approved. Both cost time instead of money: Takeout gives you a raw archive to sort out yourself, and the API needs approval plus a developer. Free is realistic for a one-off, less so for a monthly report.

How do I download all my Google reviews at once?

Use accounts.locations.reviews.list on the Business Profile API for a single location, or accounts.locations.batchGetReviews across several. Those are the only official endpoints that return a complete review history rather than a sample, and both require approved API access to your own verified profile.

Can I export reviews from someone else's Google Business Profile?

Not through any official route. The Places API caps you at five reviews for a business you do not own, and there is no endpoint that returns more. Tools promising a competitor's full review history are scraping Maps, which the Maps Platform terms prohibit, and the reviews they return are not licensed for you to republish.

Does Google Business Profile have an export button?

No. There is no download or export control for reviews anywhere in the Business Profile dashboard, which is the reason this question exists at all. The nearest official equivalents are a Google Takeout archive of your account data or the Business Profile API.

Why does my Takeout export only have reviews I wrote?

Because you selected Maps (your reviews) rather than Google Business Profile. Those are two separate products in the Takeout list and the names are easy to confuse. Maps (your reviews) contains reviews you left for other businesses, which is almost never what someone exporting for their own company wants.

How often should I export my reviews?

If you are exporting manually, monthly is usually the point where the habit survives and quarterly is where it quietly stops. If you find yourself doing it weekly, that is the signal to connect the source properly rather than keep exporting, because a repeated manual export is a pipeline with a person standing in the middle of it.

The short version

If you own the profile and need everything, apply for Business Profile API access and start now, because the 60 day profile age requirement cannot be shortened later. If you need a file this week, use a platform that exports CSV. If you only want the reviews visible on your own website rather than in a spreadsheet, you do not need an export at all, and a Google reviews widget will do it without an API key or a quota.