Excel E-Maps 2.0 has a new interface. The ribbon has the new look and feel of the most modern Office and Windows applications.
Even more important is that we have reduced the number of clicks. From addresses in your Excel sheet to a nice thematic map is done through one menu and one sequence. This is good news for the novice GIS users that want to create great looking maps within Excel.
The design of the maps changed. New colour and more informative maps available. The maps will appear automatically when you open the map window.
Import your own map in SHAPE format on top of the background map and get even better looking maps.
If you have a vector map in SHAPE format (extension shp), you may import the map. E-Maps is designed to work with WGS84 format (other projections may work). The base files for the map should have a project file (extension .prj) too.
See the tutorial how to import the map.
Vector maps can be coloured or used for thematic shading.
E-Maps was developed to produce maps and visualisations in Excel in an easy way. There are many ways to create great looking maps with lots of information. We added a “Blank” background. With this option, you can omit the background for example to create maps to use as a transparent image (PNG or GIF).
Heatmaps are based on point locations. The number of points are the bases for the heatmap. Now, we offer a second feature to build heatmaps based on point locations with an attribute. For example, let us have a look below. You will see the number of incidents at a specific postalcode location. See below as an example how eventually this data turns into a heatmap.
The standard E-Maps heatmap functionality (activated through the button) uses only the point locations as the bases for the heatmap. This feature often is used when registring (GPS) locations. With this new functionality, we offer a wider range of visualizing your data.
| ISO3 | Country name |
| ABW | Aruba |
| AFG | Afghanistan |
| AGO | Angola |
| AIA | Anguilla |
| ALA | Åland Islands |
| ALB | Albania |
| AND | Andorra |
| ARE | United Arab Emirates |
| ARG | Argentina |
| ARM | Armenia |
| ASM | American Samoa |
| ATA | Antarctica |
| ATF | French Southern Territories |
| ATG | Antigua and Barbuda |
| AUS | Australia |
| AUT | Austria |
| AZE | Azerbaijan |
| BDI | Burundi |
| BEL | Belgium |
| BEN | Benin |
| BES | Bonaire, Sint Eustatius and Saba |
| BFA | Burkina Faso |
| BGD | Bangladesh |
| BGR | Bulgaria |
| BHR | Bahrain |
| BHS | Bahamas |
| BIH | Bosnia and Herzegovina |
| BLM | Saint Barthélemy |
| BLR | Belarus |
| BLZ | Belize |
| BMU | Bermuda |
| BOL | Bolivia, Plurinational State of |
| BRA | Brazil |
| BRB | Barbados |
| BRN | Brunei Darussalam |
| BTN | Bhutan |
| BVT | Bouvet Island |
| BWA | Botswana |
| CAF | Central African Republic |
| CAN | Canada |
| CCK | Cocos (Keeling) Islands |
| CHE | Switzerland |
| CHL | Chile |
| CHN | China |
| CIV | Côte d’Ivoire |
| CMR | Cameroon |
| COD | Congo, the Democratic Republic of the |
| COG | Congo |
| COK | Cook Islands |
| COL | Colombia |
| COM | Comoros |
| CPV | Cape Verde |
| CRI | Costa Rica |
| CUB | Cuba |
| CUW | Curaçao |
| CXR | Christmas Island |
| CYM | Cayman Islands |
| CYP | Cyprus |
| CZE | Czech Republic |
| DEU | Germany |
| DJI | Djibouti |
| DMA | Dominica |
| DNK | Denmark |
| DOM | Dominican Republic |
| DZA | Algeria |
| ECU | Ecuador |
| EGY | Egypt |
| ERI | Eritrea |
| ESH | Western Sahara |
| ESP | Spain |
| EST | Estonia |
| ETH | Ethiopia |
| FIN | Finland |
| FJI | Fiji |
| FLK | Falkland Islands (Malvinas) |
| FRA | France |
| FRO | Faroe Islands |
| FSM | Micronesia, Federated States of |
| GAB | Gabon |
| GBR | United Kingdom |
| GEO | Georgia |
| GGY | Guernsey |
| GHA | Ghana |
| GIB | Gibraltar |
| GIN | Guinea |
| GLP | Guadeloupe |
| GMB | Gambia |
| GNB | Guinea-Bissau |
| GNQ | Equatorial Guinea |
| GRC | Greece |
| GRD | Grenada |
| GRL | Greenland |
| GTM | Guatemala |
| GUF | French Guiana |
| GUM | Guam |
| GUY | Guyana |
| HKG | Hong Kong |
| HMD | Heard Island and McDonald Islands |
| HND | Honduras |
| HRV | Croatia |
| HTI | Haiti |
| HUN | Hungary |
| IDN | Indonesia |
| IMN | Isle of Man |
| IND | India |
| IOT | British Indian Ocean Territory |
| IRL | Ireland |
| IRN | Iran, Islamic Republic of |
| IRQ | Iraq |
| ISL | Iceland |
| ISR | Israel |
| ITA | Italy |
| JAM | Jamaica |
| JEY | Jersey |
| JOR | Jordan |
| JPN | Japan |
| KAZ | Kazakhstan |
| KEN | Kenya |
| KGZ | Kyrgyzstan |
| KHM | Cambodia |
| KIR | Kiribati |
| KNA | Saint Kitts and Nevis |
| KOR | Korea, Republic of |
| KWT | Kuwait |
| LAO | Lao People’s Democratic Republic |
| LBN | Lebanon |
| LBR | Liberia |
| LBY | Libya |
| LCA | Saint Lucia |
| LIE | Liechtenstein |
| LKA | Sri Lanka |
| LSO | Lesotho |
| LTU | Lithuania |
| LUX | Luxembourg |
| LVA | Latvia |
| MAC | Macao |
| MAF | Saint Martin (French part) |
| MAR | Morocco |
| MCO | Monaco |
| MDA | Moldova, Republic of |
| MDG | Madagascar |
| MDV | Maldives |
| MEX | Mexico |
| MHL | Marshall Islands |
| MKD | Macedonia, the former Yugoslav Republic of |
| MLI | Mali |
| MLT | Malta |
| MMR | Myanmar |
| MNE | Montenegro |
| MNG | Mongolia |
| MNP | Northern Mariana Islands |
| MOZ | Mozambique |
| MRT | Mauritania |
| MSR | Montserrat |
| MTQ | Martinique |
| MUS | Mauritius |
| MWI | Malawi |
| MYS | Malaysia |
| MYT | Mayotte |
| NAM | Namibia |
| NCL | New Caledonia |
| NER | Niger |
| NFK | Norfolk Island |
| NGA | Nigeria |
| NIC | Nicaragua |
| NIU | Niue |
| NLD | Netherlands |
| NOR | Norway |
| NPL | Nepal |
| NRU | Nauru |
| NZL | New Zealand |
| OMN | Oman |
| PAK | Pakistan |
| PAN | Panama |
| PCN | Pitcairn |
| PER | Peru |
| PHL | Philippines |
| PLW | Palau |
| PNG | Papua New Guinea |
| POL | Poland |
| PRI | Puerto Rico |
| PRK | Korea, Democratic People’s Republic of |
| PRT | Portugal |
| PRY | Paraguay |
| PSE | Palestine, State of |
| PYF | French Polynesia |
| QAT | Qatar |
| REU | Réunion |
| ROU | Romania |
| RUS | Russian Federation |
| RWA | Rwanda |
| SAU | Saudi Arabia |
| SDN | Sudan |
| SEN | Senegal |
| SGP | Singapore |
| SGS | South Georgia and the South Sandwich Islands |
| SHN | Saint Helena, Ascension and Tristan da Cunha |
| SJM | Svalbard and Jan Mayen |
| SLB | Solomon Islands |
| SLE | Sierra Leone |
| SLV | El Salvador |
| SMR | San Marino |
| SOM | Somalia |
| SPM | Saint Pierre and Miquelon |
| SRB | Serbia |
| SSD | South Sudan |
| STP | Sao Tome and Principe |
| SUR | Suriname |
| SVK | Slovakia |
| SVN | Slovenia |
| SWE | Sweden |
| SWZ | Swaziland |
| SXM | Sint Maarten (Dutch part) |
| SYC | Seychelles |
| SYR | Syrian Arab Republic |
| TCA | Turks and Caicos Islands |
| TCD | Chad |
| TGO | Togo |
| THA | Thailand |
| TJK | Tajikistan |
| TKL | Tokelau |
| TKM | Turkmenistan |
| TLS | Timor-Leste |
| TON | Tonga |
| TTO | Trinidad and Tobago |
| TUN | Tunisia |
| TUR | Turkey |
| TUV | Tuvalu |
| TWN | Taiwan, Province of China |
| TZA | Tanzania, United Republic of |
| UGA | Uganda |
| UKR | Ukraine |
| UMI | United States Minor Outlying Islands |
| URY | Uruguay |
| USA | United States |
| UZB | Uzbekistan |
| VAT | Holy See (Vatican City State) |
| VCT | Saint Vincent and the Grenadines |
| VEN | Venezuela, Bolivarian Republic of |
| VGB | Virgin Islands, British |
| VIR | Virgin Islands, U.S. |
| VNM | Viet Nam |
| VUT | Vanuatu |
| WLF | Wallis and Futuna |
| WSM | Samoa |
| YEM | Yemen |
| ZAF | South Africa |
| ZMB | Zambia |
| ZWE | Zimbabwe |
63.000 rijksmonumenten
More than 63.000 monuments in The Netherlands are plotted on a Here map with Excel E-Maps. The X and Y coördinates that we used, came from the file that we downloaded from the ‘Cultureel Erfgoed’ (Cultural Heritage).
Delft centre monuments
Pakhuis De Liefde Delft
We developed a script to show your colleagues how to create a map in 45 seconds.
The script for the 45 second demo:
go on for the next 45 seconds:
We added the funtionality to display the result of address matching (geocoding) as an extra column.
This feature enables you to check the quality of your addresses and location of the points on your map.
Preferably, a country code will be used in the data field: Country.
See the list of ISO3 country codes.
Addresses can be geocoded with Pitney Bowes Spectrum or Nokia Here.
