How to Export All Google Maps Reviews to a Spreadsheet (2026 Guide)

If you've ever needed every review for a business on Google Maps — your own locations, a competitor's, or a whole list of them — you've probably discovered there's no "Export to CSV" button. Google gives you an infinite-scroll list on the page and nothing else.

This guide covers three ways to get those reviews into a spreadsheet, from most tedious to most painless, and is honest about the trade-offs of each.

What you can actually get per review

Before the how, here's the data that's publicly visible on each review and worth capturing:

• Reviewer name and whether they're a Google Local Guide
• Star rating (1–5)
• Review text and the date
• The business owner's response (if any)
• The place's overall rating and total review count

That's enough for reputation tracking, competitor analysis, or sentiment work.

Option 1: Copy-paste by hand

For a handful of reviews on one business, just scroll and copy. It's free and takes zero setup.

It also falls apart fast: Google lazy-loads reviews as you scroll, dates are relative ("2 months ago"), owner responses are collapsed, and doing this across 10 locations — or 500 reviews — is a soul-crushing afternoon. Fine for a quick look, useless at any scale.

Option 2: Build your own scraper

If you write code, your instinct is to script it. Here's the honest reality of that path in 2026:

• Google blocks datacenter IPs. A naive requests or Puppeteer script gets a challenge page or empty results within a page or two. You'll need residential proxies, which cost money and add complexity.
• The reviews live behind an infinite-scroll feed that only loads as you scroll a specific container — and Google periodically changes the underlying markup, so your selectors break without warning.
• The UI is localized to the proxy's country, so a proxy that exits in France hands you a French page and your English-text selectors silently return nothing.

None of this is insurmountable — it's just a genuine, ongoing maintenance job. If you scrape Google Maps for a living, build it. If you need reviews in a spreadsheet by this afternoon, it's overkill.

Option 3: Use a maintained scraper (no code)

The pragmatic middle ground is a hosted actor that already solves the proxy + anti-bot + maintenance problem, so you just hand it a URL and get structured data back. I built one on the Apify platform for exactly this: Google Maps Reviews Scraper.

Here's the full workflow:

1. Grab the place URL. Open Google Maps, search the business, click it, and copy the URL from your address bar.
2. Paste it into the actor (placeUrls). Add as many businesses as you want — it processes them in one run.
3. Set how many reviews per place (up to 500) and a sort order — newest, most relevant, highest, or lowest rating.
4. Run it. It uses residential proxies to load the real page in English, opens the reviews tab, scrolls the feed, and extracts every review.
5. Export the dataset as CSV, Excel, or JSON — one click.

A row of output looks like this:

{
  "place_name": "Eiffel Tower",
  "place_rating": 4.7,
  "reviewer_name": "John Smith",
  "is_local_guide": true,
  "rating": 5,
  "date": "2026-07-30",
  "text": "Absolutely stunning views from the top.",
  "owner_response": "Thank you for visiting!"
}

What it costs

It's pay-per-use at $4 per 1,000 reviews — no subscription. So pulling 500 reviews each from 3 locations (1,500 reviews) runs about $6. For a one-off competitive teardown or a monthly reputation export, that's cheaper than the hour you'd spend copy-pasting.

Which should you pick?

Need	Best option
10 reviews, one business, once	Copy-paste
You scrape Google daily and want full control	Build your own
A clean spreadsheet across several businesses, today	Hosted scraper

Common questions

Do I need a Google API key? No — Google's official Places API caps reviews at five per business, which is why scraping the public page is the only way to get them all. No key required.

Is this allowed? You're collecting publicly visible data. As always, use scraped data responsibly and in line with applicable terms and privacy law.

Can I track reviews over time? Yes — re-run on a schedule and diff the output to watch ratings and sentiment move week over week.

---

If you try the Google Maps Reviews Scraper, I'd genuinely value your feedback — it's new, and honest notes on what to add next help a lot.