This said: Power Map determines the location of each row by the city and country: I’ve tried it as well with German streets and the geocoding was a disaster. In my situtation the city names in the colums city are of course cities and countries are countries. So as we add the layer Power Map asks you to determine the geometry columns and lets you determine the type opf the column. Please keep in mind that the only information we have is the city and the country. What is interesting: Microsoft Power Map don’t use bing maps as basemap (:-/)…Īs we have the list of skyscrapers in the spreadsheet let’s add this data to the map. After starting the plugin you will see a nice globe: Power Map splash screen Normally I would upload the csv to QGIS/ ArcGIS and use a geocoder to geolocate the cities in my GIS. The Power Map plugin will be placed inside your ribbons in Excel and have to possibilities: start it and add data to it…Īs I’ve already mentioned I am using a list of skyscrapers from Wikipedia ( here is my clean-up version of it as xlsx) and I would like to create a nice map of it.
Yet you will need to be connected to the web to use all the functionalities. It is a small plugin of about 12 mb but it will give you some great opportunities in Excel without the need of a separate GIS. Yet it was new to me and you can download the preview (why is there no progress in status?) on the Microsoft pages. The Power Map plugin/add-on seems to be a little older with regards to this video: For this purpose I used a list of worldwide skyscrapers and their places in the world. So Let me show you a quick example and describe my recent fallbacks.
Power map excel 2016 download software#
Today Aleks blew my mind with a feature on a preview addon for Microsoft’s leading spreadsheet software Excel: The Power Map Plugin.