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.
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).
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.
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.
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
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:
- Open the file (or prepare this)
- Select all the data in left corner
- Menu: Add Data to map
- Select Address / Zipcodes and click
- Mark Add result column and click Next
- type a Layername (optional)
- Click Finish
- Show the audience the map, move around, show the Result column in your Excel sheet
- Click Show / Hide Layer list
- Click Show / Hide Heatmap
- 45 seconds!!
go on for the next 45 seconds:
- Change Background Map
- Save Map as image or PDF
- Click Object Select , click on a point and see the data highlighted in your Excel
- Click another row in your Excel sheet and see the map zoom to the selected point.
- Click Marquee Select
- Select a rectangle on your map and see the data selected in your Excel Sheet
- Copy and paste the data to a new sheet or
- Add the selection to your map by Add Data to Map
- Optionally you can add a layer with thematic shading of varying in size and of course: labels
- 90 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.