You can use ArcGIS for Excel to display data on a map, and combine your data with content from ArcGIS to add context. When you add data to a map in ArcGIS for Excel, the data is converted to a layer in the map and is added to the Layers list. Once the layer is created, you can configure how it is styled, turn on labels, and set other formatting options. You can create a map in a Microsoft Excel workbook using ArcGIS for Excel.
To create a map in a Microsoft Excel workbook, complete the following steps:
- Click the ArcGIS tab on the Microsoft Excel ribbon to display the ArcGIS for Excel tools.
- In the Map section, click Show Map.
The map window appears displaying the default basemap.
- Sign in to your ArcGIS account or click Continue to proceed as a guest user.
- From the map tools, click Layers
.
The Layers list appears on the map.
- Optionally, do any of the following:
- To add layers to the map, click Add
.
Follow the instructions to add a data layer to the map or add layers from ArcGIS.
- Style the layer to represent the data in various ways—using a heat map, for example—and customize the appearance of symbols in the layer.
- Customize the map by configuring clustering, labels, and pop-ups.
- If you are signed in, share the map or share a layer in it if your organization administrator has enabled these permissions.
- To add layers to the map, click Add