This website requires JavaScript.

Yelp 評論匯出工具

下載任何商家的每則 Yelp 評論 — 含星等、照片、店家回覆與評論者個人檔案資料 — 至 Excel、CSV 或 JSON。

What about Yelp's review filter?

Yelp aggressively filters "not currently recommended" reviews into a separate panel — these don't count toward the public star rating but are still publicly visible. The exporter pulls BOTH the recommended and not-recommended reviews into your file, with an is_recommended column so you can analyse the gap.

Common workflows

  • Reputation reporting — pull all reviews from the last quarter, count by rating bucket, chart trend over time.
  • Multi-location brands — export each location separately via bulk URL upload, then pivot in Excel by location.
  • Owner-response gap audit — filter where owner_response_text is empty — those are the ones the brand never replied to.
  • Bad-review triage — filter rating ≤ 2 and route to your customer-success team via Zapier or webhook.
  • Yelp Elite outreach — filter is_elite = true on competitor reviews; those are influential local voices worth engaging.
  • Local SEO monitoring — schedule weekly exports for each location to catch new reviews before they hit a Google update window.

Plan limits

Per-business size scales with your plan. Free (no signup): up to 100 reviews per business. Personal: 5,000. Premium: 50,000. Business: 250,000 — see pricing for the full feature comparison and API tiers for the API-specific limits.

FAQ

Yelp Reviews Exporter — FAQ

Is the Yelp reviews exporter free?
The free tier (no signup) returns up to 100 reviews per business. Larger reviews and CSV/JSON require a paid plan: Personal 5,000, Premium 50,000, Business 250,000. See pricing.
Are filtered "not currently recommended" reviews included?
Yes — both recommended and not-recommended reviews are in the export, with an is_recommended column to filter on. The "not recommended" panel is publicly visible — Yelp just doesn't count it toward the star rating.
Are owner responses included?
Yes — owner_response_text and owner_response_at columns. Empty when the business never replied — useful for response-rate audits.
Are review photos included?
Photo URLs are in a photos column. We don't download the binary content (would multiply file size).
Are Yelp Elite reviewers flagged?
Yes — is_elite column. Plus reviewer engagement signals (review count, friend count, photo count) that often correlate with influence.
Can I export reviews from many locations at once?
Yes — bulk URL upload on a paid plan processes each URL as a separate export and bundles the resulting files in one ZIP (one file per locations).
Does it support Yelp internationally?
Yes — yelp.com, yelp.ca, yelp.co.uk, yelp.de, yelp.fr, yelp.it, etc. Just paste the URL.
Will Yelp notice that I exported?
No. We read public review pages without authentication.
Is there an API?
Yes — the same pipeline is exposed as a JSON-over-HTTP API on Premium and Business plans.