Finland Company Registry Scraper — PRH B2B Leads

---

📌 Overview

The Finland Company Registry Scraper turns the PRH / YTJ open data API — the Finnish Patent and Registration Office (PRH) and the Business Information System (YTJ), Finland's official company registry — into an analysis-ready dataset. It reads directly from the open avoindata.prh.fi API, the same open data the registry publishes, so there is no login, no API key and no captcha.

For every Finnish company you get the business ID (Y-tunnus), current company name, company form (legal form), main line of business (NACE / TOL code), full business address, website and registration date — straight from the official register, with the deeply nested, multi-language JSON flattened into clean columns (English descriptions preferred).

Perfect for Finland B2B lead generation, sales prospecting, market research, CRM enrichment, KYC / compliance and competitor mapping — exported to CSV, Excel, JSON or pushed to Google Sheets and your CRM via API.

✅ Combine a company form + town filter and raise maxResults to assemble a large, targeted Finnish prospect list in a single run.

---

❓ What does the Finland / PRH company registry scraper do?

It queries the official PRH / YTJ open data API with your filters, flattens the registry's nested, multi-language JSON into clean spreadsheet-ready columns, de-dupes by business ID and paginates automatically. You set filters in a simple form; you get a structured dataset back — no code, no registry account, no API integration work.

---

✨ Features

	Feature	Description
🎯	Finland B2B lead data	Business ID (Y-tunnus), company name, company form, main business line, full address, website and registration date.
🔎	Rich filtering	Search by company name, town/location, company form (OY, OYJ, AOY…), main business line (NACE), postcode and registration-date range.
🆕	Find new companies	Filter by registration-date range to surface newly founded Finnish businesses.
🏢	Single-company lookup	Look up one company by exact business ID (Y-tunnus) for CRM enrichment.
📦	Bulk export	Tens of thousands of companies per query, auto-paginated; export to JSON, CSV, Excel, HTML or pull via API & webhooks.
🔓	No API key needed	Reads the official open PRH / YTJ API — no login, no key, no signup, no captcha.

---

📊 What data you get

One clean row per company. Verified output fields:

Field	Description
businessId	Finnish business ID (Y-tunnus)
registrationDate	Date the business ID was registered
name	Current registered company name
companyFormCode / companyForm	Company form code and its English description
mainBusinessLineCode / mainBusinessLine	Main line of business NACE / TOL code and English description
street	Business street address (street + building number)
zip / city	Postcode and city / town
addressType	Address type (1 = visiting, 2 = postal)
website	Company website URL, when registered
lastModified	Last modification timestamp, when present
source	Source register code of the business ID
url	Public YTJ company page URL
scrapedAt	ISO timestamp of the run

---

🚀 How to use

1. Open the actor and set your filters (town, company form, main business line, dates, etc.) — or just type a company name in name.
2. Set maxResults.
3. Run, then export the dataset to CSV, Excel, JSON or Google Sheets.

Input fields

Field	Type	Description
name	string	Company name search, e.g. Nokia (a very broad name like oy can be slow — prefer location)
location	string	Registered town, e.g. Helsinki, Espoo, Tampere, Turku, Oulu
companyForm	string	Company form code: OY, OYJ, AOY, KY, AY, TMI…
mainBusinessLine	string	Main business line (NACE / TOL) code, e.g. 62010 (software), 73110 (advertising)
postCode	string	Business-address postcode, e.g. 00100
businessId	string	Exact business ID (Y-tunnus) for single-company lookup
registrationDateStart / registrationDateEnd	string	Registration-date range (YYYY-MM-DD) — find newly founded firms
maxResults	integer	Cap (default 200, 0 = unlimited)
useProxy	boolean	Route through Apify Proxy (datacenter). Default true
proxyConfiguration	object	Proxy override

Example scenarios

1) Limited companies (OY) in Helsinki

{
  "location": "Helsinki",
  "companyForm": "OY",
  "maxResults": 1000
}

2) Software companies by NACE code

{
  "mainBusinessLine": "62010",
  "maxResults": 2000
}

3) Newly founded companies in 2025

{
  "registrationDateStart": "2025-01-01",
  "maxResults": 1000
}

---

📦 Example output

{
  "businessId": "0100123-2",
  "registrationDate": "1978-03-15",
  "name": "Oy Emar Ab",
  "companyFormCode": "16",
  "companyForm": "Limited company",
  "mainBusinessLineCode": "66190",
  "mainBusinessLine": "Other activities auxiliary to financial services, except insurance and pension funding",
  "street": null,
  "zip": "00131",
  "city": "HELSINKI",
  "addressType": "2",
  "website": null,
  "lastModified": null,
  "source": "3",
  "url": "https://tietopalvelu.ytj.fi/en/yritys/0100123-2",
  "scrapedAt": "2026-06-08T00:00:00.000Z"
}

Export to CSV, Excel, JSON or XML, push to Google Sheets / your CRM, or pull via the Apify API and webhooks.

---

🎯 Use cases

• B2B lead generation — build targeted Finnish prospect lists by town + company form + industry.
• Sales prospecting — filter by company form and business line, and reach companies with a website.
• Market research — count and profile companies by NACE code, town and founding date.
• KYC / compliance & due diligence — verify business IDs (Y-tunnus) and registration details.
• Competitor mapping — survey every company in a vertical or town.
• CRM enrichment — look companies up by business ID and append official registry fields.

---

❓ FAQ

Is there a free PRH / YTJ API?

Yes. The Finnish Patent and Registration Office (PRH) publishes the company registry as fully open, free JSON open data (avoindata.prh.fi/opendata-ytj-api) — no key, no login, no signup. This actor is a friendly, filterable export layer on top of it: set filters in a form, run, and download a clean dataset with pagination handled and nested fields flattened.

How do I export Finnish company data to Excel?

Every run writes one row per company to a dataset you can export to Excel, CSV, JSON or HTML, or pull via the Apify API. Set your filters (town, company form, business line, etc.), run, and use the Export button to download an .xlsx / .csv.

Does it include company websites?

It returns the website that each company registered with PRH / YTJ, when present. This comes straight from the official registry — but not every company registers one.

Is scraping PRH / YTJ legal?

This actor reads only the official open data that PRH publishes via its public open data API — no login or circumvention involved. As always, credit the source (PRH / YTJ) and follow PRH's terms and applicable law for your specific use case.

How do I find company-form or NACE codes?

Company-form codes include OY (limited company), OYJ (public limited), AOY (housing company), KY, AY, TMI. Main-business-line (NACE / TOL) codes are numeric (e.g. 62010 software, 73110 advertising). You can also just search by name or location and read the companyFormCode / mainBusinessLineCode columns in the output.

Is this a PRH / YTJ API alternative for bulk download?

Yes — it's the easiest PRH / YTJ open data alternative for non-developers: no code, automatic pagination, nested multi-language JSON flattened to clean English columns, and direct export to CSV / Excel / JSON.

---

📈 Notes on coverage & limits

• Website fill rate varies. website only appears when the company registered it. Many small or dormant firms leave it blank.
• Large segments. Big towns return tens of thousands of companies (Helsinki ≈ 88,000). For very large segments, split your run by town, postcode or registration-date range and combine the datasets.
• Multi-language source. PRH / YTJ data is in Finnish, Swedish and English; this actor flattens descriptions to English where available, falling back to the first available language.

---