How to scrape Yelp to Excel (free, no code)

Yelp is one of the richest free sources of local-business data on the web: star ratings, review counts, price level, category, neighborhood, and — once you open a profile — full address and phone, for millions of businesses. If you’re doing local SEO prospecting, building a sales territory list, researching competitors, or studying review patterns by category, that’s exactly the raw material you need — except it’s trapped in an endless scroll of cards, roughly ten results at a time.

This guide shows you how to scrape Yelp business data into a clean spreadsheet, free and without writing any code, using the free Grabby web scraper Chrome extension. It’s built for agencies, local SEO practitioners, sales and business-development teams, and researchers — anyone who wants Yelp’s local-business data as rows and columns instead of an infinite scroll.

Is it legal to scrape Yelp?

Be aware going in: Yelp’s terms of service explicitly prohibit using “any robot, spider, service search/retrieval application, or other automated device, process or means to access, retrieve, copy, scrape, or index” the site or its content, except where Yelp’s own robots.txt expressly allows it. Yelp also actively defends against automated traffic on the technical side, not just contractually. None of that makes casual, small-scale browsing illegal — it’s a terms-of-service matter, meaning the consequence is Yelp blocking your access or account rather than a criminal one — but it does mean you should treat Yelp as one of the stricter sites to collect from.

Grabby doesn’t crawl Yelp’s servers on its own; it reads the search results and profile pages already loaded in your own browser, one page at a time, the same way a person browsing would. That’s a materially gentler footprint than a bot hitting the site continuously, but it doesn’t override Yelp’s terms, so keep your pulls modest, spread larger jobs out, and don’t try to harvest the whole platform. If you need guaranteed compliance for a production use case, Yelp’s own Fusion API is the sanctioned, paid alternative — see the comparison below.

Once you have contact details, how you use them is separately regulated: GDPR generally permits B2B outreach on a “legitimate interest” basis if you can show where the data came from and honor opt-outs quickly, and CAN-SPAM in the US requires accurate sender information and a working unsubscribe link, honored within 10 business days. (This is a how-to, not legal advice.)

What you’ll need

• Google Chrome, Microsoft Edge, or Brave.
• The free Grabby extension — no account, runs locally.
• A Yelp search results page for your niche and city.

Four ways to get Yelp data into a spreadsheet

Before diving in, here’s how the realistic options actually compare:

Grabby is the fastest, free path to a spreadsheet without a line of code — the rest of this guide walks through it step by step.

Step 1: Run your Yelp search

Search Yelp for a category and location — “coffee shops in Portland”, “plumbers near me” — and apply the filters worth narrowing on first: distance, price, rating, “open now”, or a more specific category. Filtering before you scrape means fewer rows to clean up afterward. Scroll once so the first page of results has fully loaded.

Step 2: Select the results list

Click the Grabby icon, choose Scrape List, then Select the list and click any one business result. Grabby highlights the whole set and grabs them all with a live preview:

• Business name
• Star rating and review count
• Price tier ($ to $$$$)
• Category
• Neighborhood or area
• Open/closed status
• The link to each business’s Yelp profile

Depending on the category, Yelp also surfaces service options right in the results — delivery, takeout, outdoor seating — and a short review snippet. Grabby captures whatever is visible on the card, so if those fields matter for your list, they’ll come along with the rest.

Step 3: Walk every page of results

Yelp paginates its search results roughly ten businesses at a time, which means a 200-business search is about twenty pages — painful to click through by hand. Choose Pagination or Auto-scroll in Grabby, set a maximum if you want one, and hit Start. Grabby walks each page of the Yelp search and appends every business to the same table.

One thing to watch for: Yelp mixes sponsored placements and an ad carousel into organic results, and those rows don’t always carry the same fields as a normal listing. They’re easy to spot and remove once everything is in a table — sort by rating or review count and the ads tend to stand out immediately.

Step 4: Pull the full address and phone from each profile

Some fields — the full street address, a direct phone number, sometimes a website — live on each business’s own Yelp profile rather than the search-results card. Hand Grabby the profile-link column and use detail-page scraping to follow it: it opens each business’s profile in turn and pulls those extra fields back into the matching row.

Add an email for each business

Once you have a website column, send it through Grabby’s built-in email extractor. It visits each business’s own site and pulls out any contact email it finds, merging it back into the table. That’s how a list of Yelp listings becomes a genuinely contactable outreach list.

Step 5: Clean and export

In the editable table, remove duplicate or empty rows and columns, rename headers to match your CRM, hide what you don’t need, and sort by rating or review count to prioritize. Then click Export and choose CSV, Excel, or JSON — or copy the table straight into Google Sheets. Everything stays on your machine; nothing is uploaded anywhere.

Going further: bigger, cleaner, richer lists

Beat broad-search limits. Very broad Yelp searches (a whole city, a generic category) stop offering further pages long before they’ve shown you every match. Narrow by neighborhood or add a more specific category filter, run the scrape on each narrower search, then merge the exports for full coverage.

Dedupe across searches. Overlapping neighborhood searches will return some of the same businesses twice. Use the editable table’s duplicate-row removal — matching on the Yelp profile link or on name-plus-address — to collapse them into one clean list.

Enrich once, at the end. Run detail-page scraping and the email extractor after you’ve merged and deduped, not before, so you’re not paying for the same work twice.

Clean up phone and address formatting. Yelp listings mix formats — (503) 555-0100 versus 503-555-0100 — and neighborhood names aren’t always full addresses. Standardize both columns before importing into a CRM or dialer.

Use cases

• Local SEO and agency prospecting — find businesses with a review-count or rating gap worth pitching.
• Sales and BD prospecting — turn a category-and-city search into a structured account list.
• Market research — compare price tiers, rating distribution, and category density across neighborhoods.
• Reputation-management outreach — target businesses with lower ratings or thin review counts.
• Competitive benchmarking — see how a client stacks up against every similarly categorized business nearby, price tier included.

Troubleshooting

• Only the first page captured? Make sure Pagination or Auto-scroll is switched on before you hit Start — a single scrape only grabs what’s currently loaded.
• Address or phone missing? Those fields often live on the business’s own Yelp profile rather than the results card — use detail-page scraping on the profile-link column to pull them in.
• A run looks blocked or slows down? Stop, wait a few minutes, and narrow your search (add a category or neighborhood filter) before trying again — Yelp’s anti-bot measures are more sensitive on very broad searches.
• Some rows look like ads? Sponsored placements sometimes get captured alongside organic results — filter them out in the editable table once you spot the pattern.

Frequently asked questions

Is it really free? Yes. Grabby is free while in early access, with every feature unlocked and no sign-up.

Which Yelp fields can I capture? Whatever the search results show: business name, star rating, review count, price tier ($ to $$$$), category, neighborhood, open/closed status, and the link to each profile. Following that link into each profile adds the full address and phone.

Can I get phone numbers, websites and emails? Phone and full address usually live on each business’s Yelp profile even when they’re not shown in the search results. Follow the profile link with Grabby’s detail-page scraping to pull them in, then send the website column through the email extractor to add a contact email.

Can I collect every page of results? Yes. Yelp paginates its results roughly ten at a time; choose Pagination or Auto-scroll in Grabby and it walks every page of your search automatically.

Is scraping Yelp allowed? Yelp’s terms of service explicitly prohibit automated scraping except where its own robots.txt allows it, and it actively guards against bots. Grabby reads the page you’ve already loaded in your browser rather than crawling the site itself, which is a gentler approach, but keep runs modest and review Yelp’s terms before relying on this at scale. (Not legal advice.)

How does this compare to the Yelp Fusion API? Fusion is Yelp’s official API, but it’s paid-only: a 30-day trial gives you about 5,000 calls, then plans start around $7.99 per 1,000 calls with a default cap of 30,000 calls a month. It’s the compliant route for an app or a large recurring pull; Grabby is the faster, free option for building a one-off or occasional list yourself.

Can I export to Excel or Google Sheets? Yes — export CSV, Excel or JSON, or copy the table straight into Google Sheets.

Does this work for any category? Yes — restaurants, contractors, salons, auto shops, anything you can search for on Yelp.

Build a fuller lead list

Yelp pairs well with other local sources. See scraping Google Maps to Excel for a second angle on the same businesses, scraping any business directory for leads, and extracting emails from a website for lists you’ve already built elsewhere.