This tutorial shows how to scrape Gelbe Seiten leads from a list of detail URLs into CSV with UScraper's Gelbe Seiten Scraper by URLs template. You will import the workflow, replace sample /gsbiz/ URLs, set the export path, run a test, and validate the output.
Before you start
Prerequisites and Gelbe Seiten policy checks
You need UScraper installed as a local desktop app, a set of Gelbe Seiten business detail URLs you are allowed to process, and a folder where CSV exports can be written. The template is not a keyword-search crawler. It is the URL-list stage of the workflow: you already have the profile pages, including any city, category, or circle selection that produced them, and now you want to extract structured contact fields from each detail page.
Start with three to five URLs. Gelbe Seiten profiles can differ by category, missing contact options, review state, and profile completeness. A small batch helps you catch selector drift before you append hundreds of rows.
Compliance first: review Gelbe Seiten terms, check the live robots.txt file, avoid login-only or private data, keep request volume modest, and do not bypass verification screens or access controls.
Workflow anatomy
Gelbe Seiten scraper by URLs: how the template works
The companion JSON uses a simple block graph: Navigate -> Wait for Page Load -> Wait for Element -> Structured Export -> Loop Continue. Navigate owns the list of Gelbe Seiten detail URLs. The wait blocks keep the scraper from exporting before the company heading appears. Structured Export writes one CSV row from the page body. Loop Continue advances to the next URL.
| Block | What to check | Why it matters |
|---|---|---|
| Navigate | Replace the sample /gsbiz/ URLs with your approved list | This is the only input list the template loops through. |
| Wait for Page Load | Keep a practical timeout for slower profile pages | Reduces blank rows caused by partial renders. |
| Wait for Element | Confirm the business heading selector still appears | Protects the CSV from pages that did not load correctly. |
| Structured Export | Confirm filename, save folder, headers, append mode, and columns | Controls the final Gelbe Seiten to CSV output. |
| Loop Continue | Leave it at the end of the flow | Moves from the current detail URL to the next one. |
Runbook
How to scrape Gelbe Seiten leads to CSV
Replace the URL list
Open Navigate and paste your approved Gelbe Seiten /gsbiz/ detail URLs. Keep one clean list for each market, search radius, or client project.
Set the export path
In Structured Export, confirm gelbe-seiten-scraper-nach-urls.csv, headers, append mode, and a project-specific save folder.
Run one profile
Execute a single URL first. Compare the CSV row against the browser page for name, phone, email, website, rating, address, and lead URL.
Run the batch
When the first row checks out, reconnect the loop and run the remaining URLs. Keep the browser visible for prompts, slow pages, or unexpected blank rows.
After the first batch, sort by lead_url. One detail URL should create one row. If rows repeat, dedupe the input list and check whether a previous append run resumed mid-flow.
Output
Export shape for Gelbe Seiten leads
The bundle did not include a CSV sample, so the JSON workflow is the authoritative sample of the export shape. Its Structured Export block writes gelbe-seiten-scraper-nach-urls.csv with headers and append mode.
gelbe-seiten-scraper-nach-urls.csvColumn
titel
Business name from the profile heading.
Column
bewertung
Rating value when a review summary is available.
Column
anzahl_der_bewertungen
Review count parsed from the rating area.
Column
branche
Industry or category label from the profile header.
Column
adresse
Street address text from the profile.
Column
plz
Postal code for filtering and cleanup.
Column
standort
City or local area displayed on the page.
Column
e_mail
Email address from mail links when present.
Column
telefon
Visible or linked telephone number.
Column
website
External business website, excluding directory domains.
Column
lead_url
The source Gelbe Seiten URL that produced the row.
Use the CSV as a review file, not an unquestioned source of truth. Optional fields are expected to be blank when a profile does not publish them or the live page layout changes.
Validation
Validate the Gelbe Seiten scraper export
Validation is where most scraper projects become useful. Open the CSV beside the browser and inspect rows from the start, middle, and end of the run. Confirm that required fields are present and URLs point back to the profile that produced each row.
| Symptom | Likely cause | Fix |
|---|---|---|
Empty titel | The page never reached the expected heading state | Extend the wait, handle prompts, and rerun one URL. |
Blank e_mail | The profile does not expose an email link or the module changed | Treat email as optional and verify a few examples manually. |
Directory URL in website | The external-site filter needs updating | Refresh the blocked-domain list in the JavaScript column. |
| Address split looks wrong | Gelbe Seiten changed header markup for that profile type | Update the selectors against the live page. |
| Duplicate rows | Duplicate inputs or a resumed append run | Deduplicate by lead_url before CRM import. |
Alternatives
UScraper vs Octoparse, Apify, APIs, and scripts
If you are searching for the best Gelbe Seiten scraper, the right answer depends on execution model. Octoparse-style templates are useful when you prefer a hosted no-code environment. Apify actors are useful when developers want cloud runs, datasets, and API access. Enterprise data providers fit managed extraction and larger recurring programs. Python scripts fit engineering teams that want full control over selectors, retries, storage, and proxies.
UScraper is different: it is a local desktop app workflow for teams that want to inspect the browser, edit blocks visually, and write a CSV to a chosen folder. That makes this template a practical Octoparse Gelbe Seiten alternative for controlled URL lists, local QA, and spreadsheet-first lead research.
| Option | Best fit | Main trade-off |
|---|---|---|
| UScraper Gelbe Seiten URL template | Local CSV from a known list of detail URLs | Best for controlled batches, not unattended high-volume crawling. |
| Hosted no-code scraper | Teams that want vendor scheduling and cloud execution | Data and run history live in a third-party workflow. |
| Marketplace actor or scraping API | Developers who need API calls, datasets, and automation hooks | Requires platform setup and usage-based cost review. |
| Custom script | Engineering teams with custom parsing and storage needs | Requires code maintenance every time the page changes. |
For more local desktop workflows, browse the UScraper template library. For publishing updates and scraper walkthroughs, keep an eye on the UScraper blog.
FAQ