Decide this rule before importing. It usually makes sense to keep your own verified details and not to treat missing import values as deletion instructions. Test the field mapping with a copy and check your system’s preview.
Export
Before a real import, check how your application handles the export fields. The fictitious sample file helps you test delimiters, accented characters and text columns. CSV is the standard format; XLSX, JSON and custom columns are agreed before delivery. A direct integration with a particular CRM is not guaranteed.
File structure
Each row is a business or establishment, each column a data item. The structure is the same for all industries, so you can combine several exports or import them into the same CRM template.
| Column in the CSV | Label | Content |
|---|---|---|
raison_sociale | Company name | registered or trading name as given in the source. |
forme_juridique | Legal form | for example SAS, SASU, SARL, EURL, SA, SCI, association or sole trader (entrepreneur individuel, EI), from the Sirene database once the business has been matched to its SIREN. |
siren | SIREN | 9-digit number of the legal unit (check digit verified), once matched with the Sirene database. |
siret | SIRET | 14-digit number of the establishment (SIREN + NIC), where known. |
tva_intracommunautaire | EU VAT number | FR + key + SIREN, only if the business publishes it itself. |
adresse | Address | street number and street of the business address as given in the source. |
code_postal | Postcode | five digits, stored as text (leading zero kept). |
commune | Municipality | municipality (commune) of the business address. |
departement | Department | code and name of the département, derived from the postcode. |
region | Region | one of the 18 regions, derived from the département; the main filter for a regional selection. |
secteur | Industry | assignment to one of the 21 basedecontacts.fr industries. |
code_naf | NAF code | main activity (APE code) under NAF rév. 2, from the Sirene database once matched. |
telephone | Phone | published business number in international format (+33 …). |
email | published business address as given in the source; a data field for CRM and matching, not a consent to marketing. | |
site_web | Website | address of the company website including the protocol. |
An empty field means the information was not available in the sources. We never fill it with assumed values. As of 4 November 2026, the records come from Overture Maps and from company websites: SIREN, SIRET, legal form and NAF code will come from the matching with the Sirene database, which is in progress, and the industry will follow from it. The quote states which fields your selection contains.
Import guide
code_postal, telephone, siren and siret in particular as text. Before loading, check a phone number with +33 and a postcode starting with 0.A large file may be of little use for your purpose if a field you need is often missing. Compare the agreed required fields and the confirmed selection size. The database status page explains what the contact figures say and what they leave open.
Preview
The following rows are sample data. The businesses in the table and in the sample file are entirely fictitious so that you can see the structure. SIREN, SIRET and VAT numbers are deliberately invalid, the phone numbers belong to the range that ARCEP reserves for works of fiction, and the email addresses end in the reserved domain .example. This is neither a real extract nor a list of contacts to approach.
| Company name | Legal form | Region | Industry | Phone | |
|---|---|---|---|---|---|
| Bâti Exemple Lambert SAS | SAS | Île-de-France | Construction and building trades | +33 1 99 00 00 01 | contact@batiexemple-lambert.example |
| Électricité Démo Martin | Sole trader (EI) | Auvergne-Rhône-Alpes | Construction and building trades | +33 1 99 00 00 02 | contact@electricite-demo-martin.example |
| Atelier Mécanique Démo SA | SA | Grand Est | Manufacturing | +33 1 99 00 00 06 | contact@atelier-mecanique-demo.example |
| Hôtel du Parc Fictif SARL | SARL | Auvergne-Rhône-Alpes | Hotels, restaurants and tourism | +33 1 99 00 00 11 | contact@hotel-parc-fictif.example |
| Transports Modèle Express SAS | SAS | Normandy | Transport and logistics | +33 1 99 00 00 15 | contact@transports-modele.example |
| Logiciels Démo Occitanie SAS | SAS | Occitanie | IT, software and digital services | +33 1 99 00 00 16 | contact@logiciels-demo.example |
| Architectes Associés Fictifs SARL | SARL | Occitanie | Architects and engineering firms | +33 1 99 00 00 18 | contact@architectes-fictifs.example |
| Garage Exemple Automobiles SARL | SARL | Normandy | Motor trade and repair | +33 1 99 00 00 23 | contact@garage-exemple.example |
In a real export, every row contains all 15 columns where the information is available. The column names in the CSV are in French.
Technical details
The standard format is CSV in UTF-8 with BOM, semicolons as delimiters and CRLF line endings. Excel and LibreOffice Calc open this combination without character errors if you use the CSV import.
UTF-8 with BOM, semicolon, header row with column names
ready-made Excel workbook; very large selections are split across several sheets or files
for direct import into your own applications
name the fields you need
You receive the file by email as a download link. Other delivery methods or regular deliveries are agreed individually.
Price
Exporting a whole industry costs €229 to €449, depending on the industry. Selections by region, department or your own filters are quoted on request. Prices shown are the full price – nothing is added. Prices per industry are on the pricing page.
FAQ
Decide this rule before importing. It usually makes sense to keep your own verified details and not to treat missing import values as deletion instructions. Test the field mapping with a copy and check your system’s preview.
An identical or similar name alone is not enough. Use the SIRET or SIREN where available, plus address information. One SIREN can cover several establishments: for an establishment, the key is the SIRET. The export does not guarantee a complete key for every record.
Do not open the file by double-clicking, otherwise Excel may display accented characters incorrectly, drop the leading zero of postcodes and read phone numbers with a leading plus as a formula.
In an empty workbook choose Data › From Text/CSV, set the file origin to Unicode (UTF-8) and the delimiter to semicolon. Set the postcode, phone, SIREN and SIRET columns to text and confirm with Load. LibreOffice Calc opens the import dialogue automatically.
We deliver CSV in UTF-8 with BOM, semicolons as delimiters and CRLF line endings. Excel and LibreOffice recognise this combination reliably. If your application expects commas or tabs, we prepare the file accordingly.
The published figures are as of 4 November 2026; the records come from Overture Maps (release 2026-10-21.0) and from company websites. Every quote states the date of the data in your selection. The date an export is created is not the date each individual contact was checked.
We do not guarantee a fixed update interval for all sources. Details are on the data sources and methodology page.
Yes. By default we deliver all 15 columns; on request you receive a file with only the fields you need for your CRM or campaign. Records without a complete address or without a website can also be excluded.
Towards businesses, yes, within the CNIL framework: an offer related to the recipient’s profession, sender identification and an unsubscribe link in every message, and respect for objections. Generic company addresses (contact@, info@) are not subject to these principles. Details: B2B email and phone prospecting.
That depends on industry, region and filters. An Excel worksheet holds at most 1,048,576 rows; on request we split very large selections by region or deliver them as JSON.
We state the size after filters, price and the date of the data before you order.