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.
Easy and less complicated
We developed E-Maps to produce maps and visualisations in Excel in an easy way. There are many ways to create noice maps and now we added the “Blank” background. With this option, you can omit the background and create maps with transparency (PNG of GIF) or just without a background map.
Heatmaps are based on point locations. The number of points are the bases for the heat map. Now, we offer a second feature to build heatmaps based on point locations with an attribute.
For example, the number of incidents at a postalcode location.
At the standard E-Maps heatmap functionality, activated through the button, only the point locations are the bases for the heatmap. This feature often is used when registring (GPS) locations. With the new functionality, we offer a wider range of visualizing your data.
More than 63.000 monuments in The Netherlands plotted on a Here map with Excel E-Maps. The X and Y coördinates were in 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:
- 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.