CityMarker DE – five digits postcode map Germany


Coloring Postcode Map Germany  – by Excel-Data – set City and Locations automatically

For sophisticated geographical representations of your financial figures on a map of the Germany (five digit postcodes).  PowerPoint editable, coloring, printing map of Germany  to transfer your excel data (postal codes) into a PPT slide for Sales, Marketing and Business-Presentation

Out of stock

SKU: CityMarker-DE-ZIP-5digits

CityMarker DE – five digits postcode map Germany – PowerPoint


Only on request. Contact us »

The CityMarker DE – five digits postcode map of Germany (postcode area map: 5-digits) is a smart and powerful PowerPoint tool to transfer Excel data – based on the ZIP code number (Address-Data, KPI-Values and Labels) – automatically on an integrated Boundary Shape Map for PowerPoint Presentations.

Prepare Management decisions faster than ever. In just three steps you can transfer your locations on a map of Germany with Postcode-Map in PowerPoint (screenshots below).

CityMarker DE – Germany five digits postcode areas, zip-code map 5-digits - Transfer Excel Address Data into a germany postcode area map, create heat map for kpi dashboards


Protect your data, work offline with clear KPI-Values by Regions and geographic Layers. Increase your Sales and Marketing Activities by Heat maps – 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. In PowerPoint: Run Marco – CityMarker
3. Load Excel file and set the desired output options


The CityMarker Germany Postcode-Map is suitable for business simulations – 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. Even large amounts of data can the CityMarker to be transferred 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

Privacy – Protect your Data

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 PowerPoint 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.



Product features – CityMarker DE – five digits postcode map Germany

  • Germany Postcode-Map (5-digits) as PowerPoint template – editable 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 of fixed size
  • Incl. Pins and Flag icons
  • Marker Colors – individual or by color ramp
  • Simple Redesign (CI-Conform) with classic PPT 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 2007, 2010, 2013, 2016 ( MS Office 32-bit System)
  • Operation Systems: Windows XP, Windows Vista, Windows 7, Windows 10
  • License: 1 Single User


Start with this Excel-Template to create powerful maps – easy to use for your own data

Example Map for Reporting

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

Set Marker Size in PowerPoint by Excel-Data xls-Sheet, values, sales - automatically for your sales kpi reporting


Start Makro with your Excel-template

start powerpoint macro germany map - for coloring postcode map de 5 digit zip code by excel data


Use the PPT-Function “selection pane” to recolor your postcode areas for simulations

postcode map germany - sales and marketing, german postcode map coloring by excel data


Zoom into PowerPoint Slide…

citymarker germany postcode area powerpoint, coloring by excel data address


Use the Wizard – to set your Points by Excel-Values or to create Heatmaps

set marker, points by daimond, circle, square, triange, harvey balls in powerpoint


Use the Heatmap by Excel-Values to color States (Shapes)

fill states in germany by excel sum, excel count values


 Example – Output-Maps

Coloring postcode map germany (5digits) group-color by 3-digits.

CityMarker DE - five digits postcode map Germany, PowerPoint Presentation Vector Map


Zoom: Postcode Ares (5digits Germany) per City in PowerPoint