Export

Importing company data into Excel: fields, sample file and checks

Before a real import, check how your application handles the export fields. The fictitious sample file helps you test delimiters, accents 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

What the file contains

Each row is a business, 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 CSVLabelContent
bedrijfsnaamCompany namename or trading name as given in the source, including the legal form where it is shown.
rechtsvormLegal formfor example BV/SRL, NV/SA, CV/SC, CommV/SComm, VOF/SNC, vzw/asbl or sole trader, only where the source or the name shows it.
ondernemingsnummerEnterprise numberten digits (0xxx.xxx.xxx or 1xxx.xxx.xxx); the VAT number is BE plus the same number. Empty for now: numbers found on websites are not yet linked to the records.
straatStreet and numberaddress of the establishment as given in the source.
postcodePostcodefour digits, stored as text.
gemeenteMunicipalitymunicipality or former municipality (deelgemeente) of the address.
provincieProvinceone of the 10 provinces or the Brussels-Capital Region, derived from the postcode; the main filter for a regional selection.
gewestRegionFlemish Region, Walloon Region or Brussels-Capital Region.
brancheIndustryone of the 21 basedecontacts.be industries.
nace_codeNACE-BEL codeeconomic activity under NACE-BEL 2008, where it can be derived from the source.
telefoonPhonepublicly listed business number in international format (+32 …).
e_mailEmailpublicly listed business address as given in the source or on the website; a data field for CRM and matching, not a consent to advertising.
e_mail_typeEmail address type“algemeen” (general: info@, contact@, sales@ …), “persoonlijk” (personal: firstname.lastname@ …) or “freemail”; for a selection under the Royal Decree of 4 April 2003 keep only general addresses of legal entities.
websiteWebsiteaddress 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 5 November 2026, all records come from Overture Maps, supplemented with contact details from the businesses’ websites: industry and NACE-BEL code are not yet filled in, the legal form only where it appears in the name, and the enterprise number found on websites is not yet linked to the records, so industry, NACE-BEL code and enterprise number are empty for now, and the legal form mostly as well. The quote states which fields your selection contains.

Import guide

From CSV test to a checked import

  1. Keep the original: store the delivered file unchanged. For testing, work with a copy and an empty target table.
  2. Open the import preview: choose your application’s text/CSV import, UTF-8 and semicolon. Check accents (é, è, ë, ç) and that each header is in its own column.
  3. Set data types: treat postcode, telefoon and ondernemingsnummer in particular as text. Before loading, check a phone number with +32 and an enterprise number with its leading zero.
  4. Handle empty fields: import missing details as empty, not as the number 0. When matching, make sure empty import values do not automatically overwrite your existing details.
  5. Check for duplicates: use the address and the website domain; the enterprise number is not yet linked. Similar company names (also in two languages), identical phone numbers or websites are only hints; check doubtful cases before merging.
  6. Compare the result: do the row count, columns and samples match the original file? Only then move the checked import into your working data.

Field coverage before file size

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

Sample data

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. Enterprise numbers (with a wrong check digit) and phone numbers are deliberately invalid, and the email addresses end in the reserved domain .example. This is neither a real extract nor a list of contacts to approach.

Company nameLegal formProvinceIndustryPhoneEmailAddress type
Bouwwerken Voorbeeld BVBVAntwerpConstruction and installation+32 3 0000 001info@bouwwerken-voorbeeld.examplealgemeen
Sanitair De Proefsole traderWest FlandersConstruction and installation+32 56 0000 03jan.voorbeeld@sanitair-de-proef.examplepersoonlijk
Construction Exemple SRLSRLLiègeConstruction and installation+32 4 0000 004contact@construction-exemple.examplealgemeen
Hôtel Exemple Bruxelles SASABrussels-Capital RegionHospitality and tourism+32 2 0000 009reservations@hotel-exemple-bruxelles.examplealgemeen
Frituur De Proefpatatsole traderWest FlandersHospitality and tourism+32 59 0000 08frituur.proefpatat@freemail.examplefreemail
Code & Co Fictief BVBVFlemish BrabantIT and software+32 16 0000 12hello@code-co-fictief.examplealgemeen
Logistique Démo SRLSRLHainautTransport and logistics+32 71 0000 11––
Apotheek VoorbeeldBVFlemish BrabantPharmacies, opticians and hearing care+32 16 0000 24apotheek@apotheek-voorbeeld.examplealgemeen

In a real export, every row contains all 14 columns where the information is available. The column names and the values of e_mail_type in the CSV are Dutch.

Technical details

Formats and 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.

Agree the format

CSV (standard)

UTF-8 with BOM, semicolon, header row with column names

XLSX on request

ready-made Excel workbook; very large selections are split across several sheets or files

JSON on request

for direct import into your own applications

Your own column selection

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

What an export costs

Exporting a whole industry costs €239 to €469 excluding VAT, depending on the industry. Selections by province, municipality or your own filters are quoted on request. Prices per industry are on the pricing page.

One-off industry export

One-off payment, no term.

from €239 / whole industry

  • One or more of the 21 industries
  • Selection by province, municipality and contact fields
  • 14 columns as CSV, XLSX or JSON
  • One-off delivery without a subscription

FAQ

Frequently asked questions about the export

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, especially in Belgium, where many businesses use a Dutch and a French name. Use the address and the website domain; the enterprise number is not yet linked (column empty for now). An establishment unit number identifies a site, not the business. The export does not guarantee a universally complete key.

Do not open the file by double-clicking, otherwise Excel may display accents such as é or ë incorrectly, read phone numbers with a leading plus as a formula and drop the leading zero of an enterprise number.

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 and enterprise number 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 5 November 2026: the places come from Overture Maps (release 2026-10-21.0), the additional email addresses and phone numbers from the businesses’ websites, which we are still collecting. We state the data status of your selection with every quote. 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 sources and methodology page.

Yes. By default we deliver all 14 columns; on request you receive a file with only the fields you need, for example only records whose email address is of the type “algemeen” (a general address such as info@ or sales@; whether the holder is a legal entity is only shown where the legal form appears in the name). Records without a complete address or without a website can also be excluded.

Only within the exception of the Royal Decree of 4 April 2003: impersonal addresses of legal entities, for products intended for legal entities, with an unsubscribe option in every message. For personal addresses (firstname.lastname@), freemail addresses and sole traders you need prior consent. The column e_mail_type helps you make that selection; it is a technical classification, not legal advice. More: B2B email and the Royal Decree of 2003.

That depends on industry, region and filters. A whole industry in Belgium fits into one Excel worksheet (limit 1,048,576 rows); on request we split very large selections by province or deliver them as JSON.

Tell us whom you want to reach

We state the size after filters, price and data status before you order.