Type what you are looking for and where - Plumbing, San Francisco, CA - and get the businesses back as rows: name, rating, how many reviews, categories, price band, phone, address, the listing link and an image. Ten columns, and one thing to know before you start: Yelp hard-blocks datacentre addresses, so this scraper needs your own US residential proxy.
You give it categories and places separately and it works out the combinations. There is no market to choose and no format to configure.
Prefer to write the queries yourself? Flip the Plain queries switch and paste one per line - either a Yelp search URL, or a category and a location joined with a pipe.
You do not write out every combination. Put the trades in one box and the cities in the other, and each category is searched in each location - the tool builds the grid. Three trades across four cities is twelve searches from eight lines of typing.
Rating and review count sit next to phone, address, categories and price band - plus the listing link and an image. It is a directory row rather than a name and a URL, so a lot of local research finishes at the export instead of starting there.
Yelp blocks free and datacentre addresses outright, so this scraper runs through your own paid US residential proxy. Not residential in general - the tool asks for a US one. Without it a run finishes and comes back empty, which is the one cause the tool names for an empty result.
Each row is a listing from the search results: what it is called, how it is rated, what it is, what it costs, how to reach it, where it is, and where to find it on Yelp.
The column list below is the header row of real run exports, corroborated by the column array the run screen renders - the two match exactly. What it is not is a sample. Read the note under the table before you write code against any of these fields: this page says what three of the columns hold and deliberately declines to guess at the rest, and the note explains where the line falls.
The names are exact - they are the workbook's header row and the run screen's column array, and the two agree. Where we can say what a column holds we say so and say how we know. Where we cannot, we say that instead.
Read this before you plan against the table above. Every run export we hold for this scraper came back empty - three runs between 2026-07-07 and 2026-07-15, each a workbook with this header row and no data rows beneath it - because Yelp hard-blocks free and datacentre IPs and the runs were made without the US residential proxy the tool requires. So there are no example values anywhere on this page. The three things said above about reviews, url and image are not guesses from the column names: each is established by how the reference tool's own results view handles the value. Everything else is left open, and one of those gaps is worth repeating because the obvious assumption is tempting: we do not tell you the scale of rating. Our reviews scraper can, because its tool rounds the value into five star slots; this tool just prints it.
Describe the search as a grid of categories and places, or write the queries out yourself. Either way there is a single numeric setting, and it applies to the run as a whole.
The other two Yelp scrapers limit each business you name. This one is labelled Total results limit, and it means what it says: the cap covers everything the run returns, across every search in it.
That is easy to trip over in the category-and-location mode, because a small grid produces a lot of searches - and they all draw from the same allowance. Widen the grid and you should raise the limit with it, or you will come back with a thin slice of each search rather than a full picture of any.
Leave the box empty, or set it to zero, and there is no cap at all.
File upload belongs to the Plain queries mode - it is not offered alongside the categories and locations boxes. Switch modes first, then upload, and the lines are added to whatever you had already typed and de-duplicated.
One difference from the other two Yelp tools is worth knowing if you are reusing a spreadsheet. For a CSV or TXT this reads the whole line as one query, commas included - not the first column. Only an XLSX is read column by column, and there it takes column A.
The picker lists Parquet alongside CSV, XLSX and TXT, but it cannot actually read one in the browser and will tell you so - use one of the other three.
A few of the ways teams turn a category and a map into something they can work from.
Put your target trades in one box and your territories in the other and let the grid do the writing. Phone and address land on the same row as the rating, so qualifying happens in the spreadsheet rather than in thirty browser tabs.
Search one category across the places you are considering and compare what comes back. Ratings, review counts and price bands side by side say more about how crowded and how contested a market is than any single listing does.
This is the tool that produces the business list; the reviews and photos scrapers consume one. Find the market here, then go deeper on the businesses that matter - worth checking the url column on your first run before you automate the handoff.
No subscription, no minimum, no recurring invoice. Your first 500 rows are on us - after that, pay as you go at the same flat rate as every other scraper here.
On every new account, one time. No credit card. Both input modes, file upload and every export format included. The US residential proxy this scraper needs is yours to supply.
The same flat rate as every other scraper on the platform, and a row here is one business. The estimator shows the row count and credit cost before a run starts - no surprise bills, no compute units to translate.
Volume pricing, dedicated workers and an SLA for ongoing monitoring or very large historical pulls. Tell us your numbers and we will quote it.
LIVESCRAPER10 at checkout.This tool produces the business list. These two take a business and tell you more about it.
The count in this export becomes the actual text over there - reviewer, their location, a rating, the date and what they wrote, one row each.
One image comes back on each row here. That tool gets the rest of the gallery, with a direct link per photo.
Short answer: yes - and this is the gentlest of the three Yelp exports, because a business listing is not a person.
Everything in this export is shown on a Yelp search results page to anyone who runs that search, logged in or not: the name, the rating, the review count, the categories, the price band, the phone number, the address and the listing link. Collecting publicly visible business information for research and prospecting is long-settled practice, and nothing here touches a login or a paywall.
The privacy question is lighter here than on our other two Yelp pages, and it is worth saying why rather than just saying so. Those exports carry a reviewer name and, in one case, a reviewer location - personal data about individuals. This one carries business contact details. That is a different category, though a sole trader's listing can be both, and marketing to the numbers you collect brings its own rules regardless of how you got them.
Yelp's terms restrict automated access, and Yelp enforces that hard at the network level - which is why a US residential proxy is a requirement here rather than a suggestion. That makes this a contractual question as well as a technical one. We run no third-party trackers on the data layer, and your exports self-delete after 30 days.
The questions we get most. Anything else? Talk to us - humans write the answers, not a bot.
url column is the listing link the tool uses when it turns a name into a clickable result. We have not seen a value ourselves, so check the shape of that column on your first run before you wire it into anything automatic.PROXY_URL. Without one a run completes and comes back empty.rating, the format of price, or how categories are separated.500 free rows, one time, on every new account - no expiry. After that it is $0.002 per row, pay as you go, with no card on file until you decide. The US residential proxy is yours to bring.
Livescraper's Yelp Businesses Scraper turns a category and a place into a spreadsheet of local businesses. You type the categories you want in one box and the locations in another - every category is searched in every location - or flip to plain queries and paste Yelp search URLs instead. Then you download the results as a clean CSV, Excel or JSON file.
Each row is one listing: the name, the rating, how many reviews it has, its categories, its price band, a phone number, an address, the listing link and an image. That fourth column is the one people misread most often, so it is worth stating plainly - reviews is a count, not the review text. What customers actually wrote is a separate run against the Yelp Reviews Scraper, and this tool is what produces the business list that run needs.
Sales teams put their target trades in one box and their territories in the other and let the grid write the queries, with phone and address landing beside the rating so qualifying happens in the spreadsheet. Strategy teams search one category across several cities and compare ratings, review counts and price bands to see how crowded a market really is. Data teams treat this as step one of a pipeline and go deeper with the reviews and photos scrapers.
Two things about how this tool behaves are stated here rather than buried, because both differ from its Yelp siblings. The limit is a total for the whole run, not a cap per business, which matters when a small grid of categories and cities becomes a large number of searches sharing one allowance. And Yelp hard-blocks free and datacentre addresses, so this scraper needs your own paid US residential proxy - US specifically - to return anything at all, which is the single cause the tool names when a run comes back empty. This page also publishes no example values, because every run export we hold returned zero rows; in particular it does not tell you the scale of the rating column, even though our reviews page can, because that page earned the claim and this one has not. The ten column names are exact and cross-checked. Start free: your first 500 rows cost nothing and need no card.