Local SEO teams
Citation and review checks
Favorable to scraping
Compare names, locations, phone numbers, websites, ratings, and review text against client records before fixing listings or planning reputation work.
Directories$50Free
PagesJaunes.ca Business Details Scraper for CSV Export
This PagesJaunes.ca business details scraper exports Canadian business profile pages and visible review rows into a structured CSV. Import the workflow into the UScraper local desktop app, add the PagesJaunes.ca or YellowPages.ca detail URLs you are allowed to collect, and export business names, addresses, phones, websites, restaurant details, ratings, reviewers, dates, comments, and helpful counts without building a custom crawler.
Output
CSV
Columns
12
Input
Detail URLs
Waits
Built in
Template
Free
At a glance
Export PagesJaunes.ca business details and reviews
Use this template when you already have PagesJaunes.ca /bus/ URLs and need richer profile data than a search-result card provides. It is designed for controlled research batches, directory QA, and local market analysis.
Detail-page CSV export
Export PagesJaunes.ca data to CSV for Excel, Sheets, CRM import staging, enrichment queues, and internal review workflows.
Multi-URL input list
Replace the sample plumbing profile with approved business detail URLs from PagesJaunes.ca or YellowPages.ca and let the workflow visit each page in sequence.
Phone reveal included
The workflow clicks common phone controls before extraction, then checks visible text and attributes for telephone patterns.
Local desktop execution
The stock workflow writes to your configured folder and does not send the export to a hosted scraping dashboard.
Who this is for
PagesJaunes.ca data extractor use cases
B2B researchers
Prospect qualification
Favorable to scraping
Build a reviewed shortlist from Canadian business profiles, then deduplicate and verify the CSV before outreach, enrichment, or CRM import.
Agencies
Category audits
Nuanced outcome
Export restaurants, service providers, contractors, and clinics by profile URL to inspect specialties, languages, comments, and source pages.
Pair this detail workflow with the PagesJaunes.ca Business Info Scraper when you need to collect candidate listing URLs first. For related directory research, compare it with the YellowPages Canada listing scraper, YellowPages.ca product details scraper, and the full UScraper template library.
How to use
Configure the PagesJaunes.ca scraper workflow
2
Add detail URLs
Open the Navigate block and replace the sample Borenstein Plumbing profile with the PagesJaunes.ca or YellowPages.ca business detail URLs you are allowed to collect.
3
Keep waits and reveal steps
Leave the page-load wait, body wait, short sleeps, cookie cleanup, and phone reveal blocks in place for the first run. These blocks make empty or partial exports easier to diagnose.
4
Confirm the export path
Structured Export writes pagesjaunes-ca-detail-scraper.csv with headers enabled and append mode on. Change the save folder before client-specific batches.
5
Run and spot-check
Start with five to ten URLs, open the CSV, compare several rows against the live pages, and only then expand the input list.
Output preview
What the PagesJaunes.ca CSV includes
There was no separate CSV sample in the source bundle, so the preview below mirrors the configured export columns and the default sample detail-page workflow.
pagesjaunes-ca-detail-scraper.csvColumn
nom_du_magasin
Business name from the profile heading or structured page text.
Column
location
Visible address text, cleaned to remove route labels.
Column
téléphone
Best-effort phone number after the template clicks visible reveal controls.
Column
site_web
Outbound website link when PagesJaunes.ca exposes one.
Column
type_de_restaurant
Restaurant type, category, or cuisine-like profile field when present.
Column
spécialité
Specialties or category detail text from the business profile.
Column
Language
Languages spoken when the profile publishes that section.
Column
star_rating
Review-level rating, falling back to business rating when needed.
Column
nom_du_client
Reviewer or author name from visible review rows.
Column
date
Review publication date or timestamp when available.
Column
commentaires
Cleaned review comment without duplicated author, date, helpful, or report labels.
Column
utile
Helpful count parsed from the review row when visible.
Sample rows
2 of many
| nom_du_magasin | location | téléphone | site_web | type_de_restaurant | spécialité | Language | star_rating | nom_du_client | date | commentaires | utile |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Borenstein Plumbing & Heating Inc | 1840 32e Avenue, Lachine, QC H8T 3J7 | 514-555-0181 | Plumbing Contractors | Heating, emergency plumbing | English, French | 4.5 | Marc L. | 2025-09-12 | Fast service and clear communication. | 3 | |
| Restaurant Saint-Laurent | 4520 boul Saint-Laurent, Montreal, QC | 514-555-0144 | Restaurant | Lunch, dinner, takeout | French | 5 | Sophie T. | 2025-06-03 | Good food and a clean dining room. | 1 |
Headers included - every visible review row appends one row with repeated business details
| Field group | Why it matters |
|---|---|
| Business identity | nom_du_magasin, location, téléphone, and site_web support citation checks and contact review. |
| Category context | type_de_restaurant, spécialité, and Language help qualify niche or local-language profiles. |
| Review evidence | star_rating, nom_du_client, date, commentaires, and utile preserve the visible review row for analysis. |
FAQ
Frequently asked questions
PagesJaunes.ca and YellowPages.ca pages may be publicly visible, but automated collection can still be limited by Yellow Pages Canada terms, robots guidance, privacy law, database rights, and marketing rules. Keep runs proportionate, avoid bypassing access controls, and get legal review before using exported rows for resale, enrichment, or outreach.
Before you run
Limits, compliance, and maintenance notes
Guardrails for reliable PagesJaunes.ca exports
Visible reviews
Only loaded review rows are exported
The supplied analysis did not detect review pagination or load-more behavior, so the template exports the reviews visible after the detail page loads.
Layout drift
Directory markup can change
Empty names, missing phones, blank comments, or fewer rows than expected usually mean the page omitted the field, the site changed markup, or the input URL is not a standard business profile.
Compliance
Public pages still have usage rules
Review Yellow Pages Canada terms, robots guidance, privacy obligations, and outreach rules before using exported business or review data in commercial workflows.
UScraper local workflow
TemplateCloud directory actors
AlternativeData flow
CSV stays in your configured local folder
Best for teams that want to inspect the workflow and source URLs.
Rows pass through hosted infrastructure
Useful at scale, but less direct for privacy-sensitive review workflows.
Input
Bring your own approved detail URLs
Good for curated batches from a prior listing export.
Often starts from keywords or categories
Convenient, but may collect a broader set than you need.
Cost
Free template import
UScraper product licensing applies separately.
Usage-based actor pricing
Costs can rise with repeat runs, proxies, or larger queues.
Download the free template, install the app from UScraper download, and use this workflow when you need to export PagesJaunes data from business detail pages into a structured local CSV.
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