Esri Maps for Office is a free Microsoft Excel and PowerPoint Add-in. Esri Maps for Office allows the GI User to visualize excel data as maps right there in the Microsoft Excel workspace. Esri Maps for Office can be downloaded from the ESRI Global site and accessed with an Esri Global Account.
This post will demonstrate how to use Esri Maps for Office add-in for Microsoft Excel to visualize table data as a map as well as publishing it online.
Things to note
-Download the Add-in and Install on PC or Desktop.
– User must be running an Office version from Microsoft Office 2010.
– The Add-in will install in Microsoft Excel and PowerPoint.
– Inspect the Microsoft Excel and PowerPoint to confirm the Add-in was successful.
– Esri Maps for Office is activated when the user is online.
Launch Microsoft Excel. Open the sheet. Excel data must contain address fields such as LongitudeLatitude or Place names.
For the Demo, a excel sheet containing the geographic coordinates of buildings inspected during a survey of their repair state and their attribute data.
Click the ESRI MAPS add-in (red boxed) > Sign In
Sign in when this window opens
Once signed in, Click on Add Map.
When using Cell range option, make sure the cells you need are highlighted before clicking Add MAp so it will automatically be picked up as seen in the previous screenshot.
In the Add Map window, three options are available. For the demo, Cell range is selected.
In the next page, choose Location Type as Coordinates if the address field type on the spreadsheet is XY, or take option that is most suitable to the address field type of the Data on the spreadsheet. For the demo, the spreadsheet address field is in LatLong, so Coordinates is selected from the drop down list.
Next, click on Confirm location columns. Match the coordinates to the values in the proper columns. Choose an appropriate spatial reference. For the demo, WGS 1984 is selected.
Next, Style by Column indicates which attribute field will define how the data will appear on the map. For the demo, Repair State is selected as the survey was to illustrate which buildings are in good or bad repair state.
A Confirm options window opens up. Click Add data after confirming the choices selected previously.
The map page is created.
Customizations can be done on the layer properties. The Pop-ups revealing the attribute values of each point can be edited. Click on the Layer > Pop-ups
Editing can be done on the information displayed on each point pop-up window ( See red boxed area) For the demo- Add no., Address, date established and Repair State are the information preferred for display.
A click on a Point feature on the screenshot to the right displays the pop-up and the edited result.
Style changes are made to the features in the layer. Click Layer Style (cursor finger)
Style Layer window opens on the Left pane. For the Demo, the shape of the Point features with attribute value- good on the repair state field are changed from circle to diamond shape.
The result is seen in the screenshot.
For the demo, both are now changed to the same color.
Click on Share Map (cursor finger) to share the map. This opens a window on the Left pane (red boxed). Fill in the Title, Tags, and Summary details of the map. Check the preferred sharing permisions, for demo, its Everyone (Public).
The User can change the base map. Click on the icon circled in red. A Basemap selector pane opens on the left.
Another good feature for Office is the Copy Map ribbon. Click on the Copy Map, and an image of the map becomes available on the Clipboard.
The Image can be pasted into a PowerPoint slide or even Word document
Thank you for the audience. Let us get to creating and sharing the maps.