Excel Netherland add-in – 2digits Post Code Map


NL – Excel Netherland Add-in, with two digit Postcode areas for KPI Sales-Reporting and Excel-Dashboards

SKU: NL-Excel-Addin-Postcode-2digits

Excel Netherland add-in – 2 digits postcode map


The CityMarker – Excel Netherland add-in – 2 digits postcode-area map is a smart and powerful Excel tool to transfer Excel data – based on the postcode numbers (address-data) – automatically on avector-map for Excel worksheets and PowerPoint presentations.

Prepare management decisions faster than ever. In just three steps you can transfer your locations on a map of Netherland with 2digits-postcode areas (two digits) in Excel and/or to PowerPoint-slides.

Preview Dashboard – Excel Addin Netherland for Sales and KPI Reporting

Excel Netherland Add-in - 2digits Post Code Map, set range (xls) values, address data on the NL map autoamtically

Excel NL Postcode Map – two digits – color by Cells- and Range-Values


Protect your data, work offline and with clear KPI-Values by regions and geographic layers. Increase your sales 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 Netherland 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

Privacy – Protect your data

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


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.

prepare excel sheet (cells, range) to transfer more address data on NL postcode map

prepare excel sheet (cells, range, values) to transfer more address data on NL postcode map -select range and start macro



Excel Netherland add-in – 2digits postcode map

  • NL boundary map – 2digits 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: Sales Reporting with Harvey-Balls

excel nl map, harveyballs by crm-values, kpi-dashboards in xls


Example NL map for reporting

Create heatmaps by excel data and edit your Map in PowerPoint.

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

excel selection postcode areas two-digits nl map - color, editable rename

excel – use selection pane to recolor shapes


Export your map – for great PowerPoint presentations

ribbon export excel NL map to powerpoint presentation

ribbon export excel NL map to powerpoint presentation


Other formats for the two digit ZIP-Code Map of NL

For other formats or boundary Maps of NL in KML file, Esri Shp, geoJSON, SVG, Excel, BI systems (Qlik, SAP HANA, CRM Dynamics, ORACLE APEX), please contact us – or for customizing your CRM Database-System, please contact our consulting company stallwanger IT.