DEV Community

SIKOUTRIS
SIKOUTRIS

Posted on

Building a Qualiopi Training Directory: Helping French Professionals Find Certified Programs

France has a unique approach to professional training. Unlike many countries where vocational education operates in a loosely regulated market, the French system requires training organizations to obtain a national quality certification called Qualiopi before they can access public or mutual funding. This single requirement has reshaped the entire training landscape since its full enforcement in January 2022.

I have been building tools to help professionals navigate this ecosystem, and the journey taught me a lot about working with French administrative data, building search interfaces for non-technical users, and the surprising complexity hidden behind a simple directory.

What Is Qualiopi and Why Does It Matter?

Qualiopi is a quality certification based on the Referentiel National Qualite (RNQ), a framework of 7 criteria and 32 indicators that training organizations must meet. It covers:

  • Information provided to the public about training offerings
  • Clear identification of training objectives and adaptation to learners
  • Adequacy of pedagogical methods and resources
  • Qualification and professional development of trainers
  • Integration of learner feedback
  • Engagement with the socio-economic environment
  • Continuous improvement processes

The practical impact is enormous. In France, most professional training is funded through a system of OPCO (Operateurs de Competences) — sectoral bodies that collect mandatory employer contributions and redistribute them as training budgets. Without Qualiopi, a training organization simply cannot tap into these funds. And since employer-funded training represents the majority of the market, Qualiopi is effectively a license to operate.

As of early 2026, roughly 45,000 organizations hold active Qualiopi certification across mainland France and overseas territories.

The Problem: Finding the Right Training Provider

Here is where things get frustrating for professionals looking for training. The official list of Qualiopi-certified organizations exists, but it is essentially a raw database dump. Try searching for "management training in Lyon" or "cybersecurity certification in Ile-de-France" and you will quickly understand the gap between data availability and data usability.

Professionals face several pain points:

  • No thematic search. The official database lists organizations, not their actual training programs.
  • No geographic filtering beyond department-level.
  • No reviews or quality signals beyond the binary Qualiopi yes/no.
  • Certification validity confusion. Qualiopi is granted for 3 years (4 years on renewal), and organizations can lose it. The database is not always current.

This is exactly what motivated building annuairequaliopi.fr — a searchable directory that makes it genuinely easy to find Qualiopi-certified training providers by topic, location, and specialization.

Data Sources and Challenges

Building this directory required combining several data sources:

The Official Qualiopi List

The Liste Publique des Organismes de Formation is published by the Caisse des Depots and available as open data. It includes:

  • Organization name and SIRET number
  • Certification status and dates
  • Categories (training actions, skills assessments, VAE, apprenticeship)

The data is updated regularly but has quirks. Organization names are often in ALL CAPS, addresses may be incomplete, and there is no standardized categorization of training topics.

SIRENE for Business Data

Cross-referencing with the INSEE SIRENE database provides additional context: actual business address, legal form, workforce size, and NAF code (the French activity classification). The NAF code helps, but a single code like 8559A ("Autres enseignements") covers everything from yoga instruction to advanced AI training.

Enrichment Through Scraping

To provide genuinely useful search results, we had to go beyond administrative data. This meant:

  1. Website extraction — Pulling training catalogs, specializations, and pedagogical approaches from organization websites.
  2. Geographic enrichment — Geocoding addresses and identifying actual training locations (many organizations list their headquarters but deliver training elsewhere).
  3. Topic classification — Using NLP to categorize organizations by domain: IT, management, health, safety, languages, etc.

Technical Architecture

The directory runs on a fairly standard stack, but a few decisions were driven by the specific constraints of French administrative data:

Full-text search with accent handling. French text search needs to handle accents properly. Searching for "securite" should match "securite" with accents. We use PostgreSQL unaccent extension combined with trigram indexes for fuzzy matching.

Geographic search. Users think in terms of cities and regions, not department codes. We built a location resolver that maps user input to geographic areas and then filters by proximity.

Freshness management. Qualiopi certifications expire and get renewed. We run weekly sync jobs against the official data source and flag organizations whose certification status has changed.

-- Example: Finding Qualiopi-certified IT training providers near Lyon
SELECT o.name, o.city, o.qualiopi_expiry,
       ST_Distance(o.location, ST_MakePoint(4.835, 45.764)::geography) / 1000 AS km
FROM organizations o
JOIN org_topics t ON o.id = t.org_id
WHERE t.topic = 'informatique' 
  AND o.qualiopi_active = true
  AND ST_DWithin(o.location, ST_MakePoint(4.835, 45.764)::geography, 50000)
ORDER BY km;
Enter fullscreen mode Exit fullscreen mode

Lessons Learned

Administrative data is necessary but not sufficient. The official Qualiopi list gets you 30% of the way. The remaining 70% — making it searchable, categorized, and genuinely useful — is where the real work happens.

Users do not care about certifications, they care about outcomes. Nobody searches for "Qualiopi-certified organization". They search for "Excel training Marseille" or "management certification Paris". The certification is a filter, not a search term.

Data quality is an ongoing battle. Organizations change addresses, merge, rebrand, and sometimes lose their certification without the database reflecting it immediately. Building trust means being more current than the official source.

The French training market is local. Despite remote training growth post-COVID, most professionals still prefer local providers. Geographic search is not a nice-to-have, it is the primary use case.

What Comes Next

The Qualiopi ecosystem continues evolving. The French government is working on Mon Compte Formation improvements and better data interoperability between training databases. For directory builders, this means more data to work with but also higher user expectations.

If you are working with French administrative open data or building tools for the education and training sector, I would love to hear about your experiences. The intersection of regulatory compliance and user-friendly tooling is a fascinating space to build in.

Top comments (0)