A map provides a geographic view of data and allows you to explore and interact with that data.
With Esri Maps for Office, data that you have stored in an Excel spreadsheet can be displayed on a map. Additionally, data from ArcGIS Online can be combined with your data in a single map, allowing for visual analysis of relationships and sharing the information with others.
Starting at version 3.0, we've improved the way you can work with maps in Excel. New in Esri Maps for Office is the ability to add multiple maps to an Excel worksheet. Maps are now floating in their own windows, making it easy to move the map onto a second monitor - or get it out of the way entirely when you don't want to see it. We've also made it easier to get your spreadsheet data on the map by updating the add data workflow. As soon as you click Add map, you are asked to choose the data you want to map and you are presented with some visual styling choices for how your map will look. With these improvements you will be able to make a great map very quickly.
To bring these capabilities into your spreadsheet and work with your data in a map in Excel, first add a map into your worksheet.
Open Microsoft Excel and open the desired workbook.
Click the Add Map button. A new window appears in the middle of the screen.
Esri Maps for Office scans your spreadsheet data and attempts to find your location-based data.
If Maps for Office successfully finds location-based data in your spreadsheet, you will be presented with a carousel loaded with options that are specific to your data. Review the data source, location type, and style by column selections and verify they are correct.
Data allows you to choose the data in your spreadsheet that will be used to create the map. Use the dropdown menu to choose from tables and named ranges detected in your spreadsheet. To select a new cell range, click 'More...' in the dropdown menu and click the 'Cell range' button.
Location type determines how your data will be mapped and controls what is displayed in the carousel. If you select address, city, or lat/long, your locations will be mapped as points. If you select state, province, or other area location type, your data will be mapped as polygons. You can also map your data to custom location types, such as park boundaries or sales territories, that aren't included in the default list. To add custom location types, click on 'More...' in the dropdown menu and add a new location under 'My locations'. Refer to the section on location types for more information.
Style by column lets you pick which column will be used to compare the points, lines, or areas on your map. For example if you want to compare all the stores in a franchise based on sales, you would choose the column that has the sales information. The carousel will display different ways you can compare the records on the map. Typically you can compare records by varying the size or color of icons. To simply map your records without comparison, choose None in the Style by column dropdown menu.
Hover over a thumbnail to see more information. Click a map thumbnail to select that style and click Add data to add your data to the map.
If Esri Maps for Office is not able to find location data in your spreadsheet, you will have to choose the data you want to map. Maps for Office works best when data are in tables, but cell ranges and named ranges are also supported.
To add a blank map, click the X in the upper right corner (or click cancel) to close the Add Data workflow.