This is an archive related to a previous version of ArcGIS Maps for Office. If you need the current version go to http://doc.arcgis.com/en/maps-for-office.

Add layers from your spreadsheet

Once you have added a map to your spreadsheet, you can add layers to it. To add layers from the data in your spreadsheet, click From worksheet in the map ribbon.

  1. Make sure you are signed in.
  2. 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.

    • 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.

      After selecting your data source, you will be presented with the carousel of choices shown above.

  3. 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.