Excel Germany addin 2-digits Post Code Map


Excel Germany addin 2-digits Post Code Map, create heatmaps, colorramp, labels automatically for Sales Territory, Mapping Planning or Businesss Presentations

SKU: Excel-Addin-DE-2-digits-Postcode-Areas

Excel Germany addin 2-digits Post Code Map – Sales Region

The CityMarker – Excel Germany addin 2-digits Post Code Map is a smart and powerful Excel tool to transfer Excel data, based on the postcode numbers (address-data), automatically on a vector-map for Excel worksheets and PowerPoint Slides (Presentation).

Prepare management decisions faster than ever. In just three steps you can transfer your locations on a map of Germay with 2digits-postcode areas (boundary map, two digits postal codes) in Excel and/or to PowerPoint-vector-slides to create Sales and Management Reporting in Germany.

If you need the 5-digit Postcode Map of Germany, please visit this Tool: Excel-Addin 5-digit Postcode Map Germany

Preview: Excel Germany addin 2-digits Post Code Map

Excel Germany addin 2-digits Post Code Map, coloring with Sales oder ZIP-Code Numbers

Excel Germany addin 2-digits Post Code Map- editable Vector-Shapes for Excel and PowerPoint for Sales Regions in Germany


Protect your data, work offline with clear Sales (CRM)-Values by regions and geographic layers. Increase your sales territory and marketing activities by heat map-functions – use points, shapes and labels from Excel data-source to increase your KPI-dashboards in PowerPoint.

1. In Excel: prepare data according to the supplied sample files
2. Select your range and create your own heatmap, color ramp and set points

The CityMarker Excel Germany-Postcode-Map add-in  is designed for sales and marketing presentations, potential analysis, CRM solutions or for your regional service center orientation. An intelligent algorithm ensures the highest precision in the geographical representation of your data and location points. The CityMarker can transfer even large amounts of data to the vector map.

Use “The Golden Rule” and IBCS-Standards for reporting:

Simple data structure in Excel + Digital Maps for PowerPoint + Your KPI values = successful reports

Features at glance

Easy to use and totally offline – to protect your company data source. No Google-Map, Bing-Map or other web-based solutions or services.

Setting locations – with postcode number or addresses from Excel Source

Cities and points are displayed automatically and precisely on the basis of postal code numbers on the Excel  map and formatted according to your data (size and color ramp).

The regions, shapes and areas can be automatically colored, depending on your data source (sum or number) and options.

excel post code numbers germany, select range, values in xls, cells, range for sales and marketing

excel post code numbers in germany by range to create heatmaps, color ramps

Excel Germany addin 2-digits Post Code Map

  • Germany (DE) boundary map with two digits postcode areas as editable vector-shapes
  • Macro to transfer Excel data into map, colorize shapes automatically (count, sum)
  • Set individual markers by types (circle, rectangle, triangle or own icons – e.g. company icons and pictures)
  • Marker size by Excel-values – dynamic or fixed size
  • Marker colors – individual or by color ramp, heatmap
  • Simple redesign (CI-conform) with classic Excel functions
  • High display resolutions: Ideal for printing on large paper sizes or beamer presentations
  • Simple to use: No VBA or programming skills required.
  • Security: No Bing-, Google or other web-based solutions
  • Compatible with MS Office 2010, 2013, 2016, 2019 (365) – MS Office 32-bit System, 64-bit Office only on request, not for MS Office for Mac.
  • Operation Systems: Windows XP, Windows Vista, Windows 7, Windows 10
  • License: 1 single user

Example – Harvey-Balls:

sales map de germany, excel tool for powerpoint 2 digits ZIP-Codes, postcode sector, areas

Excel Germany add-in 2-digits Post Code Map with Harveyballs and your own labels


Example map for reporting

create heatmaps by excel values, ranges – point size by zip code (postcode-id)

All cities, postcode areas and labels can be edited with the simple Excel functions – thanks to the correct naming of forms.

selection pane excel powerpoint map germany postcode sectors, areas

selection pane – for excel and powerpoint to find the right shape, label, harveyball and items


Use the Wizard for different Heamap-Types

mapping tool sales planning excel postcode germany

Use the Wizard – Sales Territory Mapping Planning


Export all Features for great PowerPoint presentations with two digit ZIP-Code Areas

sales planning powerpoint postcode areas germany 2-digits, coloring, labeling map in PPT presentation, slides

PowerPoint map germany – 2-digits postcode, editable


Other formats for the ZIP-Code Map of Germany (Postcode Map)

For other formats or boundary Maps in Germany in KML file, Esri Shp, geoJSON, SVG, Excel, BI systems (Qlik, SAP HANA, CRM Dynamics, ORACLE APEX), please contact us.

For customizing your CRM Database-System, modifying your KPI-System or programming for VBA, Sales-Reporting, MS Access, Excel add-ons please contact our consulting company stallwanger IT.

Example – MS Access database for Germany and Europe Map for Sales Reporting

Albania Map Postcode 2 digits in Europe

Postcode, ZIP-Code Map Europe, Boundary Map for SAP BO, BI-Systems, ORACLE APEX, Qlikview, MS Dynamics