Local SEO teams
Citation checks
Favorable to scraping
Export source URLs, names, phone numbers, addresses, websites, and ratings to compare directory listings against client records.
Directories$50Free
YellowPages.ca Scraper for Product Details CSV
This YellowPages.ca scraper exports Canadian business detail pages into a structured CSV for lead research, market mapping, and directory data QA. Import the workflow into the UScraper local desktop app, replace the sample detail URLs, and collect names, ratings, addresses, coordinates, hours, phone numbers, websites, services, brands, specialities, and source URLs without writing a custom scraper.
Output
CSV
Columns
16
Input
Detail URLs
Waits
Built in
Template
Free
At a glance
Export YellowPages.ca business details to CSV
Use this template when you already have YellowPages.ca business detail URLs and need a repeatable export. It is suited to controlled research batches, not broad category crawling from an unknown starting point.
Spreadsheet-ready directory data
Export YellowPages.ca data to CSV for Excel, Sheets, CRM import staging, enrichment queues, or internal review workflows.
Multi-URL product detail loop
Replace the sample URLs with approved /bus/ pages and let the workflow visit each profile one by one.
Local desktop execution
The stock workflow writes to your configured folder and does not send the export to a hosted scraping dashboard.
Fallback extraction logic
The export columns combine structured page data and visible text lookups so common profile variations still produce useful rows.
Who this is for
YellowPages.ca data extractor use cases
B2B researchers
Prospect review
Favorable to scraping
Collect Canadian business details by category or city, then deduplicate and qualify the CSV before any outreach or enrichment.
Operations teams
Vendor discovery
Nuanced outcome
Build a starting list of suppliers with contact, hours, service, brand, and specialty fields, then verify important entries manually.
Pair this detail-page template with the YellowPages Canada listing scraper when you need to collect candidate URLs first. For broader directory work, compare it with the Yellow Pages Scraper, the Yellow Pages Australia Details Scraper, and the full UScraper template library.
How to use
Configure the YellowPages.ca scraper workflow
2
Replace the sample URLs
Open the Navigate block and replace the two sample Toronto restaurant pages with your approved YellowPages.ca /bus/ detail URLs.
3
Confirm the export path
Structured Export writes yellow-pages-canada-scraper-product-details.csv with headers enabled and append mode on. Change the save folder before client-specific runs.
4
Run the loop
UScraper loads each URL, waits for the page, attempts cookie consent, confirms the body is visible, exports the configured fields, and advances to the next input.
5
Review the CSV
Spot-check several source URLs, remove duplicates, and validate phone or website fields before using the file in a CRM, report, or outreach workflow.
Output preview
What the YellowPages.ca CSV includes
yellow-pages-canada-scraper-product-details.csvColumn
name
Business name from JSON-LD, itemprop markup, merchant selectors, or the page heading.
Column
rating
Rating value when the business profile exposes one.
Column
address
Street, city, province, and postal code when available.
Column
latitude
Latitude from structured geo data or embedded page attributes.
Column
longitude
Longitude from structured geo data or embedded page attributes.
Column
opening_hours
JSON-LD or visible hours normalized into one row cell.
Column
phone
Primary telephone number from structured data or a tel link.
Column
website
Outbound business website link when present.
Column
products_and_services
Products, services, or service list text from profile sections.
Column
source_url
Final page URL opened during the run.
Sample rows
2 of many
| name | rating | address | latitude | longitude | opening_hours | phone | website | products_and_services | source_url |
|---|---|---|---|---|---|---|---|---|---|
| Bardi's Steak House | 4.2 | 56 York St, Toronto, ON M5J 1S8 | 43.6458 | -79.3822 | Monday: 11:30-22:00 | Tuesday: 11:30-22:00 | 416-555-0140 | Steak, seafood, private dining | ||
| Farmhouse Tavern | 1627 Dupont St, Toronto, ON | 43.6646 | -79.4510 | Open until 10:00 pm | 416-555-0188 | Restaurant, brunch, local food |
Headers included - every supplied detail URL appends into one local file
| Extra field | Why it helps |
|---|---|
current_status | Captures visible status text such as open, closed, or temporarily closed when the page shows it. |
language, brands_carried, specialities | Useful for niche qualification, but often blank when a profile does not publish those sections. |
description, editor_s_pick | Adds review context and source signals for manual QA. |
FAQ
Frequently asked questions
YellowPages.ca pages may be publicly visible, but automated collection can still be restricted by the site's terms of use, robots directives, privacy law, database rights, and marketing rules. Keep runs modest, avoid bypassing access controls, and get legal review before resale, enrichment, or outbound outreach.
Before you run
Practical limits and maintenance
Guardrails for reliable YellowPages.ca exports
Pacing
Avoid aggressive unattended batches
Keep the built-in waits, avoid parallel loops against the same directory, and pause if YellowPages.ca returns CAPTCHA, rate-limit, or unusual response pages.
Input quality
Use valid detail URLs
This is a detail-page extractor. If a supplied URL redirects to a search results page, the template makes a best-effort export from visible data, but the cleanest rows come from business profile pages.
Layout drift
Directory markup can change
Empty names, missing phones, or blank service fields usually mean the page omitted that field or YellowPages.ca changed markup. Test a small batch before large exports.
Get Started
Download and use this template instantly
$50Free
What's Included
- Template JSON file ready to import
- Pre-configured scraping nodes
- Works with UScraper desktop app
Open-source templates
UScraper templates are open source. Improve this workflow or contribute a new one to help the community grow.
Contribute on GitHubBrowse more templates in the library
All Templates