Street directory of Germany
4.8 out of 5 stars
72 customer ratings.
The street directory of Germany contains 8,200 delivery postal codes and 1.2 million street names. Including 14,000 destinations and 75,000 district names for download as CSV (Excel) file, compressed as a ZIP archive. This product includes 1 quarterly update. Last update: 08/31/2019, August 2019.
Street directory of Germany - Database Download (CSV)
The current and comprehensive postal code & street directory of Germany 2019. With the street directory of Germany, you have a total of more than 1.2 million street names. In addition to the streets, you will find more information, such as postal codes, city names and their districts. Data lovers beware: official municipality code (AGS), regional code (ARS), NUTS 3 code and many more details are now included. Further information about the Street directory of Germany (currently in German only).
For questions about the street directory of Germany or downloading the file after the purchase, contact us quickly and easily directly by e-mail: firstname.lastname@example.org.
A data record contains the following data fields
The street directory of Germany also contains two Austrian municipalities which are located near the southern German border, since they also have a German postal code. For this reason, the street directory Germany contains three extra columns that refer to the country, to allow clean filtering, if you want to explicitly exclude these places.
A full data record contains the following fields:
- ISO 3166-1, numeric country code (276, 040)
- ISO 3166-1, ALPHA-2 Code (two-letter country code: DE, AT)
- Staat (Deutschland; Österreich)
- Official regional code (ARS) (twelve-digit, should replace the municipality code in the long term)
- Official municipality code (AGS) (eight-digit, often still in use)
- EU NUTS 3 Code (European territorial division of Germany with 402 regions)
- ISO 3166-2, Coding of state subunits (e.g. DE-BE for Berlin, DE-HH for Hamburg)
- Government district (also the former administrative districts, characterized by "früher:")
- Region (only relevant for the state of Baden-Wurttemberg, e.g. Bodensee-Oberschwaben)
- District code (KrS), district type code, district type name, and district name
- Travel area code
- Travel area (e.g. Nordsee, Ostsee, Bergisches Land, Eifel, Sauerland)
- Collective municipality code (nine-digit, for collective municipalities, without the independent municipality code)
- collective municipality code, collective municipality type and name of the collective municipality
- Municipality code and municipality type
- The responsible municipality (name from the municipality directory, Federal Statistical Office)
- Postal code
- Place name
- Additional regional identifier
- Number range (only if street passes through different districts and/or postal codes)
- Parity (even/odd for specified number range)
- Remark (in case of outdated spelling the new street name will be displayed)
The dataset contains all delivery-relevant street data/street names of Germany including the associated postal code (zip code). The street catalog is provided in the Microsoft Excel data format CSV, delimited with the character ";", for easy import of the file and free use in your offline/online systems or software solutions.
50 random lines of test data/excerpt of the street dataset
Please note: The file contains more than 1,048,576 lines, exceeding the limit of Excel 2013/2016. If you want to use Microsoft Excel, you must first divide the file or street records. However, smaller single files, divided by state, are also included.
|06116||Halle (Saale)||Büschdorf||Reideburger Str.||42 - 998||gerade|
|12487||Berlin||KGA Heide am Wasser||Brunhildweg||alle|
|13627||Berlin||Kol. Saatwinkler Damm||Steinweg||alle|
|38118||Braunschweig||Braunschweig||Münchenstr.||1 - 11||ungerade|
|51469||Bergisch Gladbach||Gronau||Buchholzstr.||1 - 103||ungerade|
|60327||Frankfurt am Main||Gutleutviertel||Bachforellenweg||alle|
|60486||Frankfurt am Main||Bockenheim||Emser Str.||alle|
|60488||Frankfurt am Main||Hausen||Praunheimer Landstr.||2 - 80||gerade|
|67067||Ludwigshafen am Rhein||Rheingönheim||Agnes-Miegel-Weg||alle|
|90451||Nürnberg||Mittelfr||Röthenbach b Schweinau||Eibacher Schulstr.||alle|
|97074||Würzburg||Sanderau||Randersackerer Str.||72 - 998||gerade|
Common search terms for this data set
street directory germany download postal codes germany download zip street directory germany download post street directory germany street directory germany csv street directory germany excel postal zip codes germany
Roads in Germany: further topics
Get information on related topics and active competitors in selling street data for Germany. We do not claim to be the best, but we are always up-to-date and cost-effective.
Visible competitors in the market of street data
- Deutsche Post Direkt Datafactory Streetcode (about EUR 2,200 per year)
- Datapuls Streetdata, Straßendaten (about EUR 1,100 per year)
- Do you know other providers of street data and their prices?
With us, you determine whether you need updates or not. Updates can be booked at any time by purchasing the all-in-one package.
Street directories of federal states for download
- Bayern / Bavaria
- Hessen / Hesse
- Niedersachsen / Lower Saxony
- Nordrhein-Westfalen / Northrhine-Westphalia
- Rheinland-Pfalz / Rhineland-Palatinate
- Sachsen / Saxony
- Sachsen-Anhalt / Saxony-Anhalt
- Thüringen / Thuringia
- Special: 80 German cities with a population from 100.000
Street directory of Germany - FAQ
What is the street directory?
The street directory is a directory of over 1.2 million delivery-relevant street names in Germany. This refers to all roads in Germany where there is a private or business address. Roads of wastelands or hamlets are of course included, since at least one inhabited house can be found. Even streets from industrial areas can be found in the street directory of Germany. However, motorways, country roads, small roads, paths or transitions without residents are not included here.
How is the street directory structured?
In addition to the 1.2 million street names, the street directory of Germany contains 8,200 postal (ZIP) codes and corresponding 14,000 destinations and 75,000 district names. Also included are the 11,800 names of municipalities, districts, administrative districts and federal states with the official keys of the Federal Statistical Office. All data is separated by a delimiter, which can be displayed in columns in a program of your choice. A sample file with a detailed structure is offered for download.
Where can I download the street directory?
You can buy the street directory on these pages at low cost and download it immediately after receipt of payment. We are cheaper than our competitors, even if you book the optional updates. We accept the payment with PayPal, with the benefit of Buyer Protection and immediate download after purchase, but also the payment by bank transfer to our German business account. Depending on the bank, this may take 1-3 business days. For large companies, we also offer the purchase by invoice on request.
Technical information about the street directory
There are few technical details for the street directory Germany. It is a text file in CSV format that can theoretically be opened with any text editing program. The file is suitable for direct import into Microsoft Access and Excel (Power Query), SQL, or other programs that support the CSV format. Windows 1252 (Western European) is used as character encoding based on ISO 8859-1 and ISO 8859-15. The semicolon (;) is used as a delimiter, as well as a text recognition character - also called a string delimiter - double quotes (").
How can I open the street directory?
You can open the street directory of Germany in Access, Excel (Power Query), SQL, Delimit, or other programs that support the CSV format. Although Microsoft Excel offers support for up to 1,048,576 lines in the latest versions, it is not sufficient for the street directory, but you have the option to use extended query (power query) in Excel. Do not worry, we also include the 16 federal states separately, so you can open smaller files if necessary.
What happens when changes are made to the street directory?
Nationwide, there are numerous changes to the street directory per quarter. New roads are added, old streets are renamed or removed. Municipalities are being merged, new postal codes are being created, old postal codes are no longer valid, and much more. It's hard to keep track of these changes yourself, as you're not usually involved with every corner of Germany. It's precisely for these cases that we offer optional, quarterly updates, so you always have access to the most up-to-date data. If you purchase the all-in-one version of the street directory, you will automatically receive an up-to-date directory by e-mail every quarter.
Where does the data for the street directory come from?
Every municipality and every place has a list of all streets. These lists are often left to prospective buyers, including OnPageLeads. In some cases, the street directories must also be ordered for a fee, especially the lists including the house numbers, so-called house number lists. Additional information, such as on how OSM deals with it, can be found in the OpenStreetMap-Wiki (German only).
The street system in Germany
The German street system is divided according to different criteria. In the offered street directory of Germany, however, you will find only the delivery-relevant roads, so only those streets where there is also a home or business address.
- Road traffic act
- Dual carriageway
- Roads outside built-up areas
- Roads within closed villages
- Highway-like roads
- Road construction carrier
- Federal highways
- Federal roads
- State roads / national roads
- County roads
- Local roads
- Other public roads
- Field and forest paths
- Federal highways
To the article street system in Germany on Wikipedia (German only).