New interface Excel E-Maps

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.

e-maps-first-toolbar

Import a Shape map

Import shape map buttonImport 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.

thematic schanged

 

 

 

 

 

 

 

 

 

Less is more

A simple map for more information

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

Background map choice

MapExport_double

Data point entry for a heatmap with a weight attribute

Data point entry

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.

incidents per postcode

 

 

 

 

 

heatmap2

heatmap3

 

 

 

 

 

 

 

 

 

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 codes

ISO3 countrycode table

ISO3Country name
ABWAruba
AFGAfghanistan
AGOAngola
AIAAnguilla
ALAÅland Islands
ALBAlbania
ANDAndorra
AREUnited Arab Emirates
ARGArgentina
ARMArmenia
ASMAmerican Samoa
ATAAntarctica
ATFFrench Southern Territories
ATGAntigua and Barbuda
AUSAustralia
AUTAustria
AZEAzerbaijan
BDIBurundi
BELBelgium
BENBenin
BESBonaire, Sint Eustatius and Saba
BFABurkina Faso
BGDBangladesh
BGRBulgaria
BHRBahrain
BHSBahamas
BIHBosnia and Herzegovina
BLMSaint Barthélemy
BLRBelarus
BLZBelize
BMUBermuda
BOLBolivia, Plurinational State of
BRABrazil
BRBBarbados
BRNBrunei Darussalam
BTNBhutan
BVTBouvet Island
BWABotswana
CAFCentral African Republic
CANCanada
CCKCocos (Keeling) Islands
CHESwitzerland
CHLChile
CHNChina
CIVCôte d’Ivoire
CMRCameroon
CODCongo, the Democratic Republic of the
COGCongo
COKCook Islands
COLColombia
COMComoros
CPVCape Verde
CRICosta Rica
CUBCuba
CUWCuraçao
CXRChristmas Island
CYMCayman Islands
CYPCyprus
CZECzech Republic
DEUGermany
DJIDjibouti
DMADominica
DNKDenmark
DOMDominican Republic
DZAAlgeria
ECUEcuador
EGYEgypt
ERIEritrea
ESHWestern Sahara
ESPSpain
ESTEstonia
ETHEthiopia
FINFinland
FJIFiji
FLKFalkland Islands (Malvinas)
FRAFrance
FROFaroe Islands
FSMMicronesia, Federated States of
GABGabon
GBRUnited Kingdom
GEOGeorgia
GGYGuernsey
GHAGhana
GIBGibraltar
GINGuinea
GLPGuadeloupe
GMBGambia
GNBGuinea-Bissau
GNQEquatorial Guinea
GRCGreece
GRDGrenada
GRLGreenland
GTMGuatemala
GUFFrench Guiana
GUMGuam
GUYGuyana
HKGHong Kong
HMDHeard Island and McDonald Islands
HNDHonduras
HRVCroatia
HTIHaiti
HUNHungary
IDNIndonesia
IMNIsle of Man
INDIndia
IOTBritish Indian Ocean Territory
IRLIreland
IRNIran, Islamic Republic of
IRQIraq
ISLIceland
ISRIsrael
ITAItaly
JAMJamaica
JEYJersey
JORJordan
JPNJapan
KAZKazakhstan
KENKenya
KGZKyrgyzstan
KHMCambodia
KIRKiribati
KNASaint Kitts and Nevis
KORKorea, Republic of
KWTKuwait
LAOLao People’s Democratic Republic
LBNLebanon
LBRLiberia
LBYLibya
LCASaint Lucia
LIELiechtenstein
LKASri Lanka
LSOLesotho
LTULithuania
LUXLuxembourg
LVALatvia
MACMacao
MAFSaint Martin (French part)
MARMorocco
MCOMonaco
MDAMoldova, Republic of
MDGMadagascar
MDVMaldives
MEXMexico
MHLMarshall Islands
MKDMacedonia, the former Yugoslav Republic of
MLIMali
MLTMalta
MMRMyanmar
MNEMontenegro
MNGMongolia
MNPNorthern Mariana Islands
MOZMozambique
MRTMauritania
MSRMontserrat
MTQMartinique
MUSMauritius
MWIMalawi
MYSMalaysia
MYTMayotte
NAMNamibia
NCLNew Caledonia
NERNiger
NFKNorfolk Island
NGANigeria
NICNicaragua
NIUNiue
NLDNetherlands
NORNorway
NPLNepal
NRUNauru
NZLNew Zealand
OMNOman
PAKPakistan
PANPanama
PCNPitcairn
PERPeru
PHLPhilippines
PLWPalau
PNGPapua New Guinea
POLPoland
PRIPuerto Rico
PRKKorea, Democratic People’s Republic of
PRTPortugal
PRYParaguay
PSEPalestine, State of
PYFFrench Polynesia
QATQatar
REURéunion
ROURomania
RUSRussian Federation
RWARwanda
SAUSaudi Arabia
SDNSudan
SENSenegal
SGPSingapore
SGSSouth Georgia and the South Sandwich Islands
SHNSaint Helena, Ascension and Tristan da Cunha
SJMSvalbard and Jan Mayen
SLBSolomon Islands
SLESierra Leone
SLVEl Salvador
SMRSan Marino
SOMSomalia
SPMSaint Pierre and Miquelon
SRBSerbia
SSDSouth Sudan
STPSao Tome and Principe
SURSuriname
SVKSlovakia
SVNSlovenia
SWESweden
SWZSwaziland
SXMSint Maarten (Dutch part)
SYCSeychelles
SYRSyrian Arab Republic
TCATurks and Caicos Islands
TCDChad
TGOTogo
THAThailand
TJKTajikistan
TKLTokelau
TKMTurkmenistan
TLSTimor-Leste
TONTonga
TTOTrinidad and Tobago
TUNTunisia
TURTurkey
TUVTuvalu
TWNTaiwan, Province of China
TZATanzania, United Republic of
UGAUganda
UKRUkraine
UMIUnited States Minor Outlying Islands
URYUruguay
USAUnited States
UZBUzbekistan
VATHoly See (Vatican City State)
VCTSaint Vincent and the Grenadines
VENVenezuela, Bolivarian Republic of
VGBVirgin Islands, British
VIRVirgin Islands, U.S.
VNMViet Nam
VUTVanuatu
WLFWallis and Futuna
WSMSamoa
YEMYemen
ZAFSouth Africa
ZMBZambia
ZWEZimbabwe

63.000 Dutch monuments plotted on an Aerial map

Rijksmonumenten in Excel E-Maps

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 city centre monuments

Delft centre monuments

 

 

 

 

 

 

 

 

location First Element

Pakhuis De Liefde Delft

45 seconds demo script

E-Maps demo script

We developed a script to show your colleagues how to create a map in 45 seconds.

The script for the 45 second demo:

  1. Open the file (or prepare this)
  2. Select all the data in left corner
  3. Menu: Add Data to map
  4. Select Address / Zipcodes and click
  5. Mark Add result column and click Next
  6. type a Layername (optional)
  7. Click Finish
  8. Show the audience the map, move around, show the Result column in your Excel sheet
  9. Click Show / Hide Layer list
  10. Click Show / Hide Heatmap
  11. 45 seconds!!

go on for the next 45 seconds:

  1. Change Background Map   
  2. Save Map as image or PDF
  3. Click Object Select , click on a point and see the data highlighted in your Excel
  4. Click another row in your Excel sheet and see the map zoom to the selected point.
  5. Click  Marquee Select
  6. Select a rectangle on your map and see the data selected in your Excel Sheet
  7. Copy and paste the data to a new sheet or
  8. Add the selection to your map by Add Data to Map
  9. Optionally you can add a layer with thematic shading of varying in size and of course: labels
  10. 90 seconds!!

Address matching with result code

add_result geocodingWe 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.