Export

Company addresses as Excel, CSV or JSON: structure and sample file

We compile exports from the German company database by industry and region. Every file has fifteen columns – from company name, legal form and register number to address, federal state and WZ code, through to phone, email and website. Not every record contains every field. You pay once, with no subscription.

File structure

What the file contains

Each row is a business, each column a data field. The structure is the same for all industries, so you can merge several exports or import them into the same CRM template.

Column in the CSVLabelContent
firmennameCompany namename or registered company name as given in the source, including the legal form suffix.
rechtsformLegal formfor example GmbH, UG (haftungsbeschränkt), AG, KG, OHG, registered merchant (e. K.) or sole proprietorship.
registergerichtRegister courtlocal court (Amtsgericht) that keeps the register entry; empty for unregistered businesses.
registernummerRegister numbercommercial, cooperative or partnership register number (e.g. HRB …), where available.
ust_idnrVAT IDVAT identification number (USt-IdNr.), only if the business publishes it.
strasseStreet and numberbusiness address as given in the source.
plzPostcodefive-digit postcode (PLZ), stored as text so that leading zeros are kept.
ortCitymunicipality or city of the business address.
bundeslandFederal stateone of the 16 states, derived from the address; the main filter for a regional selection.
kreisDistrictrural district or district-free city for a finer regional selection.
brancheIndustryassignment to one of the 15 firmenkontaktdaten.de industries.
wz_codeWZ codeindustry code under WZ 2008, where it can be derived from the source.
telefonPhonepublicly listed business number in international format.
emailEmailpublicly listed general business address, typically from the legal notice (Impressum).
websiteWebsiteaddress of the company website including the protocol.

An empty field means the information was not available in the sources – we never fill it in with an estimate. Column names in the CSV are in German.

Preview

Sample data

The following rows are sample data. The companies in the table and in the sample file are entirely fictitious so that you can see the structure. Register numbers, VAT IDs and phone numbers are deliberately invalid, and the email addresses end in the reserved domain .example. This is neither a real extract nor a set of contacts for outreach.

Company nameLegal formFederal stateIndustryPhoneEmail
Musterbau Lindner GmbHGmbHBerlinConstruction and trades0049 30 0000 0001info@musterbau-lindner.example
Elektro Beispiel e.K.registered merchant (e. K.)BavariaConstruction and trades0049 30 0000 0002info@elektro-beispiel.example
Kanzlei Ahorn & Partner mbBpartnership company (PartG mbB)North Rhine-WestphaliaBusiness and consulting services0049 30 0000 0005info@kanzlei-ahorn.example
Präzisionsteile Weber GmbH & Co. KGGmbH & Co. KGBaden-WürttembergManufacturing and industry––
Hotel Zum Fiktiven Hirschsole proprietorshipSaxonyHospitality and tourism0049 30 0000 0015info@hotel-fiktiver-hirsch.example
Spedition Weitblick GmbHGmbHNorth Rhine-WestphaliaTransport and logistics–info@spedition-weitblick.example
Softwarehaus Codewerk GmbHGmbHBaden-WürttembergIT, software and technology0049 30 0000 0022info@codewerk-software.example
Autohaus Beispielmotor GmbHGmbHLower SaxonyAutomotive and car services0049 30 0000 0029info@beispielmotor.example

In a real export, each row contains all fifteen columns where the information is available.

Technical details

Formats and technical details

The standard format is CSV in UTF-8 with BOM, with a semicolon as the delimiter and CRLF line endings. Excel and LibreOffice Calc open this combination without character errors if you use the CSV import.

Agree on a format

CSV (standard)

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

XLSX on request

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

JSON on request

for direct import into your own applications

Custom column selection

tell us 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

We quote the price on request, depending on industry, region and filters. All prices are final prices. What determines the price is explained under Pricing.

One-off industry export

One-off payment, no term.

Price on request

  • One or more of the fifteen industries
  • Selection by federal state, district and contact fields
  • 15 columns as CSV, XLSX or JSON
  • One-off delivery without a subscription

FAQ

Frequently asked questions about the export

Do not open the file by double-clicking it, otherwise Excel may display umlauts incorrectly and strip leading zeros from postcodes.

In an empty workbook, choose Data › From Text/CSV, set the file origin to Unicode (UTF-8) and the delimiter to semicolon. Set the PLZ column to text and confirm with Load. In LibreOffice Calc, the import dialog opens automatically.

We deliver CSV in UTF-8 with BOM, with a semicolon as the delimiter and CRLF line endings. Excel and LibreOffice recognise this combination reliably. If your application expects a comma or tab, we prepare the file accordingly.

The published data status is 15. Oktober 2026. The date the export was 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 page Data sources and methodology.

Yes. By default we deliver all fifteen columns; on request you receive a file with only the fields you need for importing into your CRM. Records without a phone number or without a website can also be excluded.

Not without the recipients’ prior express consent. Under § 7(2) no. 2 UWG, email advertising without consent is unlawful, towards businesses as well. The email column is for identifying and maintaining business contacts, for example in a CRM – not for sending advertising.

That depends on industry, region and filters. Note the limit of 1,048,576 rows per Excel worksheet: on request, we split very large selections by federal state or deliver them as JSON.

Tell us who you want to reach

We confirm the scope after filters, the price and the data status before you order.