French Companies Finder

Get a clean list of French companies for a given activity, area and size, ready for your CRM or spreadsheet, straight from the official INSEE register (SIRENE).

• One row per company: SIREN, head-office SIRET, name, VAT number, legal form, activity (code + label), full address, GPS, creation date, headcount band, status, executives, latest revenue, and a link to the official record.
• Filters that matter: activity code (NAF/APE), department, city or postal code, headcount band, company category, legal form, creation date, active or closed.
• No ceiling: the public API stops at 10,000 results per query; this Actor splits the query for you and removes duplicates, so a 60,000-company list comes out of a single run.

No French needed, no API key, no account on any French site. $3 per 1,000 companies.

What you get

Sample row (a software company, run with nafCodes: ["62.01Z"], cities: ["Toulouse"], createdAfter: "2020-01-01"):

{
  "siren": "885167940",
  "siret_head_office": "88516794000059",
  "company_name": "INFINITE ORBITS (INFINITE ORBITS) (IO FR)",
  "vat_number": "FR16885167940",
  "status": "active",
  "created_on": "2020-06-01",
  "legal_form_code": "5710",
  "legal_form": "SAS, société par actions simplifiée",
  "naf_code": "62.01Z",
  "naf_label": "Programmation informatique",
  "naf_section_label": "Information and communication",
  "company_category": "PME",
  "employees_range": "20 to 49 employees",
  "employees_year": 2023,
  "head_office_address": "5EME ETAGE 8 RUE DES TRENTE-SIX PONTS 31400 TOULOUSE",
  "postal_code": "31400",
  "city": "TOULOUSE",
  "department": "31",
  "department_name": "Haute-Garonne",
  "region": "Occitanie",
  "latitude": 43.5927539688696,
  "longitude": 1.44579911175757,
  "executives_text": "HADDOUD ADEL (Président de SAS)",
  "executives": [
    { "type": "person", "name": "HADDOUD ADEL", "last_name": "HADDOUD", "first_names": "ADEL", "role": "Président de SAS", "is_auditor": false, "birth_year": 1977 },
    { "type": "company", "name": "DELOITTE & ASSOCIES", "role": "Commissaire aux comptes titulaire", "is_auditor": true, "siren": "572028041" }
  ],
  "revenue_eur": 0,
  "net_income_eur": 798628,
  "financials_year": 2024,
  "register_url": "https://annuaire-entreprises.data.gouv.fr/entreprise/885167940"
}

Every row has the same 47 columns, so the CSV or Excel export opens flat and sorted. Codes always come with a readable label next to them (naf_code + naf_label, legal_form_code + legal_form, department + department_name).

Who it is for

• Sales and marketing teams building a prospect list: "all restaurants in Lyon with 10 to 49 staff", "software companies created since 2022 in the Paris area".
• Market research and consulting: count and map every company of a sector by department, with size and age.
• Compliance, finance, procurement: check a supplier's legal form, status, executives and VAT number from the official source.
• Data teams: a flat, stable schema to feed a warehouse; the raw register record is available on demand (includeRawRecord).

How to use it

1. Type an activity code in Activity codes (e.g. 62.01Z for software, 56.10A for restaurants, 43.21A for electricians). A single letter selects a whole sector (J = information and communication, F = construction). The official list is on insee.fr.
2. Pick an area: Departments (75, 69, 31…), Cities typed as you know them (Toulouse, Lyon, Saint-Denis (93)), or Postal codes. Leave all three empty for the whole country.
3. Optionally narrow by Company size, Company category (PME / ETI / GE), Legal form, Created on or after / before, and Administrative status.
4. Set Maximum number of companies and run. Download the dataset as CSV, Excel, JSON or connect it to Zapier, Make, Google Sheets or your own code through the Apify API.

Tip: the register lists a company as soon as one of its branches is in the area. Switch on Head office in the area only to keep companies headquartered there; otherwise the branch that matched is given in matched_branch_siret / matched_branch_address.

Input summary

Field	Example	What it does
searchText	"boulangerie"	Free text on name, address or executive name. A SIREN or SIRET returns that exact company.
nafCodes	["62.01Z", "62.02A"]	Activity codes, or a section letter A–U.
departments	["75", "92"]	Department codes.
cities	["Toulouse"]	City names or INSEE commune codes.
postalCodes	["31000"]	5-digit postal codes.
employeeRanges	["12", "21"]	Headcount bands (drop-down).
companyCategories	["PME"]	PME, ETI, GE.
legalFormCodes	["5710"]	INSEE legal form codes.
createdAfter / createdBefore	"2020-01-01"	Creation date window.
status	"active"	active (default), closed, all.
headOfficeOnly	true	Keep only companies headquartered in the area.
maxResults	500	Stop after this many companies (duplicates never counted).
includeExecutives / includeFinancials / includeRawRecord	true	What each row carries.
requestsPerSecond	3	Speed, 1 to 6.

Pricing

$3 per 1,000 companies (one paid event per row written to the dataset) plus the standard Actor start event ($0.05 per 1,000 runs). You only pay for rows you get: duplicates are removed before writing, and a run that stops early is charged for what it produced. A 50-company test costs $0.15.

Set Maximum number of companies and, if you like, the run's spending limit in the Apify Console; the Actor stops cleanly at whichever comes first.

Speed and limits

• About 1,000 companies every 20 seconds at the default speed (3 requests per second, 25 companies per request). 10,000 companies take roughly 3 minutes.
• The public API allows 7 requests per second per IP address and 30 per network; the Actor obeys its Retry-After header when asked to slow down, and retries on network errors.
• The register never returns more than 10,000 companies for one combination of filters. The Actor splits large queries by department, then by headcount band, status, activity code and category. If a single slice is still above 10,000 (for instance "every company in Paris, no activity code"), the run tells you so in the log and exports the first 10,000 of that slice: add postal codes or activity codes to reach the rest.
• The creation-date filter is applied after download (the register has no such filter), so a tight date window reads more rows than it exports; you are charged for exported rows only.
• Financials (revenue_eur, net_income_eur) exist only for companies that file accounts and whose figures the register publishes. In a test on software companies, 92 of 100 companies with 10 or more employees had figures, against 13 of 50 in a mixed sample dominated by sole traders.
• Executives come from the national register (RNE). Statutory auditors are flagged is_auditor: true and left out of the one-line executives_text.
• Activity and legal-form labels are the official INSEE wordings, in French. Section labels, headcount bands and department names are in English.
• Not included (by design of the public register): companies that opted out of publication ("non-diffusible"), and companies refused registration. Sole traders may have their address masked as [NON-DIFFUSIBLE], a right they have under French law; the row is still exported with everything else.

Data source and legal notice

All data comes from the public register of French companies published by the French government: the "Recherche d'entreprises" API (recherche-entreprises.api.gouv.fr), which serves the SIRENE database maintained by INSEE together with the national company register (RNE) maintained by INPI. Both datasets are published on data.gouv.fr under the French open licence "Licence Ouverte 2.0" (Etalab): they can be reused, including commercially, provided the source is mentioned ("Source: INSEE, SIRENE / INPI, RNE, via recherche-entreprises.api.gouv.fr").

Executives' names are published by law in the national register. If you build prospect lists with them, you remain responsible for complying with the GDPR and the French rules on business-to-business prospecting.

Support

Something wrong with a row? Open the register_url of that row: it shows the official record the row was built from. For anything else, use the Issues tab of this Actor.